Hi Jawad
Thanks for all the detail, it all looks correct. I just want to clarify: it
works in console, but not through a browser/application? What is the query
you're using for testing?
--
Pat
On 25/10/2011, at 9:21 PM, Jawad Rashid wrote:
> I am currently have installed sphinx and using thinking
> sphinx v2.0.5. Currently i am using rails 3.0.7 and ruby 1.9.2-p180.
> I am using sphinx 0.9.9. I have followed instructions on thinking
> sphinx and after fixing some problems was able to install sphinx using
> source and it was successful. I have set up indexes on on my model
> file name "Recipe" on a simple db column recipeName of type string. I
> am using phusion passenger server. Right now i am working on
> development server.
> This is the index i have defined in my model file:
>
> define_index do
> indexes :recipeName
> end
>
> After this i have started the rake task for generating configure,then
> rake task for build index and started the rake task for searchd
> daemon.
>
> Now the problem is i am able to search from the database using rails/
> console by using command:
>
> Recipe.search "Query"
>
> and i do get results. I then also tried a command to search from the
> application directory and i again got results. The problem is when i
> used the same query of
>
> Recipe.search "Query"
>
> i got no results...actually nothing happens...i don't even get an
> error from my development log or nginx error file.
> I noticed then when i use the command form rails/console i do get an
> entry in searchd.query.log file but when i use the same command from
> one of controller action there is no entry in this log file which
> tells me that even the call is not going to the searchd daemon.
>
> The only configuration file for sphinx is config/
> development.sphinx.conf and i can't find any problem. This file was
> automatically created when i use index rake task. I have not declared
> any configuration for sphinx. Here is the configuration file...i have
> intentionally commented out username and password:
>
> indexer
> {
> }
>
> searchd
> {
> listen = 127.0.0.1:9312
> log = /Users/jawadrashid/RecipeProject/log/searchd.log
> query_log = /Users/jawadrashid/RecipeProject/log/searchd.query.log
> pid_file = /Users/jawadrashid/RecipeProject/log/
> searchd.development.pid
> }
>
> source recipe_core_0
> {
> type = mysql
> sql_host = localhost
> sql_user = **********
> sql_pass = *********
> sql_db = RecipeProject_dev
> sql_query_pre = SET NAMES utf8
> sql_query_pre = SET TIME_ZONE = '+0:00'
> sql_query = SELECT SQL_NO_CACHE `recipes`.`id` * CAST(1 AS SIGNED) +
> 0 AS `id` , `recipes`.`recipeName` AS `recipeName`, `recipes`.`id` AS
> `sphinx_internal_id`, 0 AS `sphinx_deleted`, 3710170113 AS `class_crc`
> FROM `recipes` WHERE (`recipes`.`id` >= $start AND `recipes`.`id` <=
> $end) GROUP BY `recipes`.`id`, `recipes`.`recipeName`, `recipes`.`id`
> ORDER BY NULL
> sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
> FROM `recipes`
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = sphinx_deleted
> sql_attr_uint = class_crc
> sql_query_info = SELECT * FROM `recipes` WHERE `id` = (($id - 0) /
> 1)
> }
>
> index recipe_core
> {
> source = recipe_core_0
> path = /Users/jawadrashid/RecipeProject/db/sphinx/development/
> recipe_core
> charset_type = utf-8
> }
>
> index recipe
> {
> type = distributed
> local = recipe_core
> }
>
>
>
>
> I don't know what is the problem. I have tried many things by
> following common problems and solutions on google but i am not able to
> understand what i am doing wrong as i am getting results from rails
> console but not from any controller action.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" 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/thinking-sphinx?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" 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/thinking-sphinx?hl=en.
