Pat thanks so much for your help on this issue. Indexing is now working for us. Still having an issue with injury model but for now have commented that out and will look into what might be the issue.
On Sep 12, 4:54 pm, Pat Allan <[email protected]> wrote: > Can you share the generated production.sphinx.conf file from the server? > Don't forget to remove db passwords from each source. > > -- > Pat > > On 13/09/2011, at 6:54 AM, gerberdata 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 > > 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.
