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