Hi Jawad How are you running the server? Via 'script/rails server', or Passenger, or something else? Are you seeing anything in the development log for the search query? How are you using the search results in your views?
Cheers -- Pat On 26/10/2011, at 11:12 AM, Jawad Rashid wrote: > Yes the query works on rails console but not on the application. > The query i am using is: > > Recipe.search "Recipe" > and i have also tried > ThinkingSphinx.search "Recipe" > > for both cases i get the correct results in the application console > but when i use it in a controller action for Recipe i get no results > at all. Not even a warning or error in my log files for server or > development log. Plus, when using these commands on the console i do > get entry in the searchd.query.log but there is no entry when using in > application. > > On Oct 26, 3:06 am, Pat Allan <[email protected]> wrote: >> 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 >>> athttp://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. > -- 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.
