Problem with "Thinking Sphinx"

Hi,
I am implementing the "sphinx" search using "Thinking Sphinx" search.
I have done everything configured.
I have added the index fields in my model like this
"
define_index do
    indexes :name,:sortable => true
    indexes description
    has created_at, updated_at
  end
"
My sphinx configuration file is as
"
source post_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = development
  sql_sock = /var/lib/mysql/mysql.sock
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `posts`.`id` * 1 + 0 AS `id` ,
`posts`.`name` AS `name`, `posts`.`description` AS `description`,
`posts`.`id` AS `sphinx_internal_id`, 1921285768 AS `class_crc`, 0 AS
`sphinx_deleted`, IFNULL(`posts`.`name`, '') AS `name_sort`,
UNIX_TIMESTAMP(`posts`.`created_at`) AS `created_at`,
UNIX_TIMESTAMP(`posts`.`updated_at`) AS `updated_at` FROM `posts`
WHERE `posts`.`id` >= $start AND `posts`.`id` <= $end AND deleted = 0
GROUP BY `posts`.`id` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
FROM `posts`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_timestamp = created_at
  sql_attr_timestamp = updated_at
  sql_attr_str2ordinal = name_sort
  sql_query_info = SELECT * FROM `posts` WHERE `id` = (($id - 0) / 1)
}"

The searching works well but I am seeing in the log that it is firing a
queri like " SELECT * FROM `posts` WHERE `id` = (1,2)"

Is my configuration right?

Also, if I am doing indexing like " indexes description, :as=>
:post_desc" and if I try to access it like this:-
"search=ThinkingSphinx.search "test"
puts search.post_desc
"
Giving me an error that "post_desc" is undefined.

Can anyone tell me wwhat is happening?

Thanks,
Mike

try search = C.search ‘test’

C == Class that implements thinking sphinx

finally:

search.each do |s|

s.post_desc

end

Hi,
I am tried like this:-
Still no success
s=Post.search "pune"
=> [#<Post id: 3, name: "Neovasolution", description: "This is pune
company", created_at: "2010-07-14 12:17:16", updated_at: "2010-07-14
12:17:16", delta: false>]

>> s.post_desc
NoMethodError: undefined method `desc' for
#<ThinkingSphinx::Search:0xb6f1bde4>
  from
/usr/local/ruby/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/thinking_sphinx/search.rb:116:in
`method_missing'
  from (irb):2

Thanks,
Mike

this is a valid return:

=> [#<Post id: 3, name: “Neovasolution”, description: “This is pune
company”, created_at: “2010-07-14 12:17:16”, updated_at: “2010-07-14
12:17:16”, delta: false>]

for access after try:

s.each do |sa|

sa.post_desc

end

Hi Mike

The reason for the message in the logs is that Thinking Sphinx/Sphinx
only knows the ids of your search results, and needs to load the
actual objects to return - hence why it talks to the database as well.

As for post_desc - this isn't available as a method anywhere (on the
search collection or search results) - the alias you've given that
column is only for Sphinx, not Ruby. So you can use it when searching:

  Post.search :conditions => {:post_desc => 'foo'}

But if you want the value of post_desc, you will need to access it as
description:

  post = Post.search('foo').first
  post ? post.description : 'No Post'

Hope this clarifies things. If you have any more questions, feel free
to ask on the Thinking Sphinx Google Group (I only spotted your posts
here via some noisy twitter bots):
http://groups.google.com/group/thinking-sphinx

Cheers