We are experiencing hundreds of these errors in our log when cron tries to update the index on our site:
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 '301029995664 WHERE word = 'conducted'' at line 1 query: UPDATE sp_search_total SET count = 0,301029995664 WHERE word = 'conducted' in /www/htdocs/w00bdef4/drupal/drupal-6.17/modules/search/search.module in Zeile 287.
The error seems to be related to [...]SET count = 0,301029995664[...].
When I run a query with a decimal dot instead of the decimal comma [...]SET count = 0.301029995664[...] from myPHPAdmin, everythings works fine.
If that's the reason indexing fails: Why is search using a comma instead of a dot?
Related to this is: Those failed indexing attempts result in unclosed connections in the database, which eventually take down our sites, because max_user_connections for the database is exceeded.
Thanks
Jörg
Comments
Comment #1
dddave commentedDid you search for related issues? Cron failures while indexing are not that uncommon and can have various reasons.
Sidenote: Are you really using Drupal 6.9? This version is way behind not only security-wise.
Comment #2
joergvk commentedWe are using 6.19, sorry for the mistake. Yes, I searched for related issues, but didn't find any.
Comment #3
dddave commentedYou might wanna check out the irc support channel: http://drupal.org/irc for faster help. In case you are able to resolve the issue a quick write-up here would be nice.
Sorry that I cannot help you further.
Comment #4
joergvk commentedWill try irc. Interestingly we encounter these errors in only one of our three sites in the multisite install.
Comment #5
joergvk commentedNo answers on irc. Issue persists.
Comment #6
joergvk commentedError is now in logs of all sites.
Comment #7
joergvk commentedCreated a bug issue for it and closed the support request.
Comment #8
dddave commented#1211604: Computed value $total used in SQL-queries may be in invalid format