Steps to replicate the issue (include links if applicable):
- Use update script php update.php in ./maintenance directory after a git pull
What happens?:
Database error :
Table revision contains rev_text_id field. Dropping...Wikimedia\Rdbms\DBQueryError from line 1618 of /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/Database.php: Error 1091: Can't DROP 'user_timestamp'; check that column/key exists Function: Wikimedia\Rdbms\Database::sourceFile( /home/ebullisc-virgile/wiki/w/maintenance/archives/patch-revision-actor-comment-MCR.sql ) Query: ALTER TABLE `wiki_revision` DROP INDEX user_timestamp, DROP INDEX page_user_timestamp, DROP INDEX usertext_timestamp, DROP COLUMN rev_text_id, DROP COLUMN rev_comment, DROP COLUMN rev_user, DROP COLUMN rev_user_text, DROP COLUMN rev_content_model, DROP COLUMN rev_content_format #0 /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException('Can't DROP 'use...', 1091, 'ALTER TABLE `wi...', 'Wikimedia\\Rdbms...') #1 /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Can't DROP 'use...', 1091, 'ALTER TABLE `wi...', 'Wikimedia\\Rdbms...') #2 /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError('Can't DROP 'use...', 1091, 'ALTER TABLE `wi...', 'Wikimedia\\Rdbms...', false) #3 /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/Database.php(3302): Wikimedia\Rdbms\Database->query('ALTER TABLE `wi...', 'Wikimedia\\Rdbms...') #4 /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/Database.php(3241): Wikimedia\Rdbms\Database->sourceStream(Resource id #1108, NULL, NULL, 'Wikimedia\\Rdbms...', NULL) #5 /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->sourceFile('/home/ebullisc-...') #6 /home/ebullisc-virgile/wiki/w/includes/libs/rdbms/database/DBConnRef.php(807): Wikimedia\Rdbms\DBConnRef->__call('sourceFile', Array) #7 /home/ebullisc-virgile/wiki/w/includes/installer/DatabaseUpdater.php(718): Wikimedia\Rdbms\DBConnRef->sourceFile('/home/ebullisc-...') #8 /home/ebullisc-virgile/wiki/w/includes/installer/DatabaseUpdater.php(843): DatabaseUpdater->applyPatch('/home/ebullisc-...', false, 'Table revision ...') #9 /home/ebullisc-virgile/wiki/w/includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->dropField('revision', 'rev_text_id', 'patch-revision-...') #10 /home/ebullisc-virgile/wiki/w/includes/installer/DatabaseUpdater.php(511): DatabaseUpdater->runUpdates(Array, false) #11 /home/ebullisc-virgile/wiki/w/maintenance/update.php(202): DatabaseUpdater->doUpdates(Array) #12 /home/ebullisc-virgile/wiki/w/maintenance/includes/MaintenanceRunner.php(309): UpdateMediaWiki->execute() #13 /home/ebullisc-virgile/wiki/w/maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run() #14 /home/ebullisc-virgile/wiki/w/maintenance/update.php(312): require_once('/home/ebullisc-...') #15 {main}
Software version (skip for WMF-hosted wikis like Wikipedia):
1.39.2