By alexandreracine on

Since I made the upgrade from 4.6 to 4.7, I have somtimes, and only sometimes, errors similar to this in the logs :

Someplace : example http://www.salsamontreal.com/montrealsalsa/event/2006/03/27/table/

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 '00169315801944 WHERE word = 'midis'' at line 1 query: UPDATE search_total SET count = 0,00169315801944 WHERE word = 'midis' à la ligne 120 du fichier /PATH TO DRUPAL/includes/database.mysql.inc.

Looking the url, everything is fine. Sometimes it is in the cache database, or the access log tables or like this example coming from the event module. It's pretty random.

MySQL version 4.1.21-standard
PHP version 4.4.4
Drupal 4.7.4

Thanks for hints!

⋅ Categories: Drupal 4.7.x

Comments

cog.rusty’s picture

cog.rusty commented

That looks like a comma there.

http://php.net/manual/en/language.types.float.php#58824

There might be a bug worth reporting. Not sure if MySQL understands than number.

alexandreracine’s picture

alexandreracine commented

I'll try to search for other occurrence if there is always a comma...

Alexandre Racine

www.salsamontreal.com La référence salsa à Montréal
www.alexandreracine.com - mon site perso

cog.rusty’s picture

cog.rusty commented

If you find anything there is an open issue here http://drupal.org/node/106206

derieppe’s picture

derieppe commented

Hi,

I got same problem on a migrated version of drupal (4.6 to 4.7) and on a fresh 4.7 version. It seem to have a relation with search index because search module can't find any word and messages comme back a sson as i force drupal to reindex the site...

I have not find the solution...

Cheers.

alexandreracine’s picture

alexandreracine commented

Alexandre Racine

Let's concentrate that here : http://drupal.org/node/106206

www.salsamontreal.com La référence salsa à Montréal
www.alexandreracine.com - mon site perso