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
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
