Page MenuHomePhabricator

deleteOldRevisions.php: SQL syntax error: "WHERE page_id IN ()"
Closed, ResolvedPublic

Description

Nothing critical, but if deleteOldRevisions.php finds nothing, it errors in a SQL syntax error because an empty IN() is not allowed.

Maybe it's better to fix this in Database.php, not sure.

Limiting to mw_page.page_id IN ()
Searching for active revisions...A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: SELECT page_latest FROM mw_page WHERE page_id IN ()
Function:
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 ')' at line 1 (localhost)


Version: unspecified
Severity: normal

Details

Reference
bz42601

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:09 AM
bzimport set Reference to bz42601.

Fix pending in Gerrit change #36390.

Landed in master (1.21alpha).