Page MenuHomePhabricator

maintainance/rebuildrecentchanges.php dies with "Error: 1146 Table 'wikidb_test.cur' doesn't exist"
Closed, ResolvedPublic

Description

Author: andersk

Description:
The rebuildrecentchanges script is broken:

$ php rebuildrecentchanges.php
Loading from CUR table...
A database error has occurred
Query: INSERT 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
cur_timestamp,cur_timestamp,cur_user,cur_user_text,cur_namespace,cur_title,cur_comment,cur_minor_edit,0,cur_is_new,cur_id,0,0,
IF(cur_is_new != 0, 1, 0) FROM cur
Function: rebuildRecentChangesTablePass1
Error: 1146 Table 'wikidb_test.cur' doesn't exist (localhost)

Backtrace:
GlobalFunctions.php line 424 calls wfBacktrace()
Database.php line 395 calls wfDebugDieBacktrace()
Database.php line 345 calls DatabaseMysql::reportQueryError()
Database.php line 1221 calls DatabaseMysql::query()
rebuildrecentchanges.inc line 38 calls DatabaseMysql::insertSelect()
rebuildrecentchanges.php line 19 calls rebuildRecentChangesTablePass1()

Additionally, Special:Recentchanges is empty after the script fails.


Version: 1.5.x
Severity: normal

Details

Reference
bz2792

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:40 PM
bzimport set Reference to bz2792.
bzimport added a subscriber: Unknown Object (MLST).

mikevalstar wrote:

yeah same in 1.5b4

no more old table

Hm, do we actually want/need such a script anyway? It can either be fixed up or just removed.
(But it should be easier to do on 1.5 than old schema anyway. :)

Fixed on CVS HEAD and REL1_5, will be in next 1.5 release candidate (or final release if there is no other rc)