See all the details of this in this node from the user "alexandreracine" (me). This include a lot of infos...

In resume:

The problem

I create a new node, and I get this

[I add a new node here]
[cron is started via poormanscron]
[in the logs]Column count doesn't match value count at row 1 query: INSERT INTO search_index (word, sid, type, score) VALUES ('danse', 1011, 'node', 191,201536224) à la ligne 120 du fichier /[PATH TO DRUPAL]/includes/database.mysql.inc.
[all other errors from all other words in the new node]
[cron has been completed here]
[in the logs and on screen]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 '000178787587144 WHERE word = 'danse'' at line 1 query: UPDATE search_total SET count = 0,000178787587144 WHERE word = 'danse' à la ligne 120 du fichier /[PATH TO DRUPAL]/includes/database.mysql.inc.

HOW TO REPRODUCE - what works, what does not

0- Open up two different web browsers. IE and Firefox, or Firefox and Konqueror. More important, one as admin the other as anonymous.
1- Configure poormanscron so that he runs at each 5 minutes.
2- Create a new node. It does not have to be frontpage, but publish it for inclusion in the search.module. Use fewer words, as this will give you less errors. Actually, just put "bbbb" in it.
3- Look in admin/settings when your next cron job will occur and when you are near enough, use your anonymous browser to reload any of your webpage rapidly until you have the error. I say rapidly since that there is a lot of people on my website, but if your website has not a lot of traffic, this will be likely easier.

Note that, if you use the anonymous browser to run the cron.php manually, there will be no errors... Hence, this is really related to poormanscron.

My system specs are :
Mysql 4.1.21-standard
PHP 4.4.4
Drupal 4.7.x

I don't know what to do and this was not happening in 4.6.x (or I did not saw it). Thanks.

CommentFileSizeAuthor
#3 search_4.diff737 bytesfhuberts

Comments

alexandreracine’s picture

Priority: Normal » Critical

Bump.

fhuberts’s picture

Version: 4.7.x-1.0 » 5.x-1.1

i have this too on the latest stable release.
somewhere on the web I found that the php function number_format() must be used to compensate for locales in floating point numbers.

fhuberts’s picture

StatusFileSize
new737 bytes

I tracked it to the search module (I use drupal 5.2):
patch attached

fhuberts’s picture

previous patch is outdated, see http://drupal.org/node/170722

dave reid’s picture

Status: Active » Closed (duplicate)

Problem is in core's search.module so I'm closing this issue as a duplicate of #170722: Search module & cron & number format.