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.
