[Mediawiki-l] Update fails: Rebuilding recentchanges table and other

J.D. spamsammler at pixelfeuer.de
Wed May 10 07:58:57 UTC 2006


Hi,

we work step by step on the Update from 1.4.7 to 1.5.8
What we found now was due the update this failure:
--------------
** Rebuilding recentchanges table:
Loading from page and revision tables...
A database error has occurred
INSERT rev_timestamp 5000 INTO `wik_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 `wik_page`,`wik_revision` WHERE
(rev_timestamp > 20060503074223) 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 `wik_recentchanges` (rc_timestamp,rc_cur_time,rc_user
(localhost)
................

Any ideas whats going wrong?

Regards



More information about the MediaWiki-l mailing list