Have you run all of your migrations on your production server? -- Pat
On 13/09/2011, at 6:54 AM, gerberdata <[email protected]> wrote: > 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. > -- 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.
