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 -~----------~----~----~----~------~----~------~--~---
