[Mediawiki-l] [MediaWiki-l] sql error when Rebuilding recentchanges table

[Jasmin Hannemann]

Hi,

i get an error when i rebuild the table of the recent changes.

In our company, we have a global wiki as intranet. every day, we dump
this wiki and store these dump in the lokal wiki on our notebooks. this
is for backup and for the case that you work offline. to import the dump
is not a big problem. but after the dump i make a

php rebuildAll.php

the part which is rebuilding the recentchanges table doesn't work. There
I get the error message:

** Rebuilding recentchanges table:
Loading from page and revision tables...
A database error has occurred
Query: INSERT rev_timestamp 5000 INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type) SELECT rev_timestamp,rev_timestamp,rev_user,rev_user_text,page_namespace,page_title,rev_comment,rev_minor_edit,0,page_is_new,page_id,rev_id,0, IF(page_is_new != 0, 1, 0)  FROM `page`,`revision` WHERE (rev_timestamp > 20060704044648) AND (rev_page=page_id)
Function: rebuildRecentChangesTablePass1
Error: 1064 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 '5000 INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_user,rc_user_text,rc_name' at line 1 (localhost)


the technial datas from our global wiki are:

    * wiki 1.6.7
    * PHP 4.3.10
    * mysql 4.1.10

the technical datas from my local wiki are:

    * wiki 1.5.7
    * PHP 4.4.2
    * mysql 5.0.22

the technical datas from my college, who has no problems with the dump
and the rebuild:

    * wiki 1.6.1
    * PHP 4.3.10
    * mysql 4.1.11


Has anybody an idea, what the problem could be?


Regards
Jasmin



-- 
Jasmin Hannemann
jasmin.hannemann at macd.com		http://www.macd.com
Tel.: +49 (0)241 44597 29		Macdonald Associates GmbH
Fax : +49 (0)241 44597 10		Lothringerstraße 52, D-52070 Aachen