Last modified: 2012-12-03 21:23:40 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T44601, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 42601 - deleteOldRevisions.php: SQL syntax error: "WHERE page_id IN ()"
deleteOldRevisions.php: SQL syntax error: "WHERE page_id IN ()"
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
unspecified
All All
: Normal normal (vote)
: 1.21.0 release
Assigned To: Alexandre Emsenhuber [IAlex]
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-12-01 11:29 UTC by Krinkle
Modified: 2012-12-03 21:23 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Krinkle 2012-12-01 11:29:55 UTC
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)
Comment 1 Alexandre Emsenhuber [IAlex] 2012-12-02 14:09:02 UTC
Fix pending in Gerrit change #36390.
Comment 2 Krinkle 2012-12-03 21:20:02 UTC
Landed in master (1.21alpha).

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links