Page MenuHomePhabricator

maintenance/rebuildrecentchanges.php fails
Closed, ResolvedPublic


rebuildrecentchanges.php fails with an error on SQL syntax. Shell input/output below. Found in 1.13alpha (r32654).

/var/www/w/maintenance# php rebuildrecentchanges.php
Loading from page and revision tables...
$wgRCMaxAge=31104000 (360 days)
Updating links and size differences...
A database query syntax error has occurred.
The last attempted database query was:
"UPDATE bw_recentchanges SET rc_last_oldid=72650,rc_new=0,rc_type=0,rc_old_len=,rc_new_len=198 WHERE rc_cur_id=712 AND rc_this_oldid=103803"
from within function "".
MySQL returned 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 'rc_new_len=198 WHERE rc_cur_id=712 AND rc_this_oldid=103803' at line 1 (localhost)"

Version: 1.13.x
Severity: normal
OS: Linux
Platform: Other



Event Timeline

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

that only happens when $lastSize is empty; this is supposed to be filled in based on the value of rev_len which is fetched by the previous query. If for any reason (like old database contents lacking rev_len values), the value is not numeric, the above error takes place. A work around was applied with r32656.