Is your test db using the same schema as your dev db? Seems something's not quite right in the SQL for item_core in your test.sphinx.conf file.
-- Pat On 26/08/2009, at 10:54 AM, mix wrote: > > Hi, i've a similar problem. > Running rake ts:in RAILS_ENV=test i get this: > > (in /home/user/NetBeansProjects/App) > Generating Configuration to /home/user/NetBeansProjects/App/config/ > test.sphinx.conf > Sphinx 0.9.9-id64-rc2 (r1785) > Copyright (c) 2001-2009, Andrew Aksyonoff > > using config file '/home/user/NetBeansProjects/App/config/ > test.sphinx.conf'... > WARNING: key 'address' is deprecated in /home/user/NetBeansProjects/ > App/config/test.sphinx.conf line 7; use 'listen' instead. > WARNING: key 'port' is deprecated in /home/user/NetBeansProjects/App/ > config/test.sphinx.conf line 8; use 'listen' instead. > indexing index 'item_core'... > ERROR: index 'item_core': sql_range_query: You have an error in your > SQL syntax; check the manual that corresponds to your MySQL server > version for the right syntax to use near 'AS `all_categories`, CRC32() > AS `all_categories_facet`, `item_details`.`shop_cat' at line 1 > (DSN=mysql://rails:*...@localhost:3306/App_test). > > > I'm using sphinx 0.9.9, thinking_sphinx 1.2.8 and rails 2.3.2 > > This is my test.rb enviroment: > > config.cache_classes = true > config.whiny_nils = true > config.action_controller.consider_all_requests_local = true > config.action_controller.perform_caching = false > config.action_view.cache_template_loading = true > config.action_controller.allow_forgery_protection = false > config.action_mailer.delivery_method = :test > > > > I'm also looking for a way of rebuilding the indexes during the unit > tests (without running one time rake ts:in RAILS_ENV=test because i > change the values during the tests, so i need to rebuild them), with > ferret was Model.rebuild_index, which is in sphinx? > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
