I am getting an error when I index on production but not on my local machine
Here is the error ERROR: index 'injury_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 ' `injuries`.`id`, `injuries`.`name`, `injuries`.`id`, `injuries`.`injury_area_id' at line 1 (DSN=mysql://root:***@localhost:3306/m10_production). total 0 docs, 0 bytes total 0.001 sec, 0 bytes/sec, 0.00 docs/sec indexing index 'injury_delta'... ERROR: index 'injury_delta': 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 ' `injuries`.`id`, `injuries`.`name`, `injuries`.`id`, `injuries`.`injury_area_id' at line 1 (DSN=mysql://root:***@localhost:3306/m10_production). total 0 docs, 0 bytes WARNING: failed to scanf pid from pid_file '/var/sport195/sphinx/log/ searchd.pid'. WARNING: indices NOT rotated. I am not getting this same error on development machine total 0.093 sec, 123640 bytes/sec, 1343.11 docs/sec indexing index 'athlete_injury_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.012 sec, 0 bytes/sec, 0.00 docs/sec distributed index 'athlete_injury' can not be directly indexed; skipping. indexing index 'brand_core'... collected 2789 docs, 0.2 MB collected 5877 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 2789 docs, 151761 bytes total 399.961 sec, 379 bytes/sec, 6.97 docs/sec Any ideas what might be causing this? -- 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.
