[MediaWiki-l] What is this database error relating to ipb_id?

Jeffrey Walton noloader at gmail.com
Sun Dec 23 02:43:15 UTC 2018


I'm trying to perform another 1.30 -> 1.31 upgrade. MariaDB version 5.5.60.

I've tried to run upgrade.php with our standard user (mwuser) and db
administrator (root). upgrade.php has always worked in the past using
our standard user (mwuser).

I've run "mysql_upgrade --user=root ..." again just in case because of
the hint below. Everything is OK.

What is the error and how do I fix it?

###################################

# php maintenance/update.php
MediaWiki 1.31.1 Updater

Your composer.lock file is up to date with current dependencies!
Going to run database updates for my_wiki-wikicryptopp_
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick)
 ... 0
Turning off Content Handler DB fields for this part of upgrade.
Adding ipb_id field to table ipblocks ...[33b892a93ece4b42600cbd2b] [no req]   W
ikimedia\Rdbms\DBQueryError from line 1457 of /var/www/html/w/includes/libs/rdbm
s/database/Database.php: A database query error has occurred. Did you forget to
run your application's database schema updater after upgrading?
Query: ALTER TABLE `mediawiki`.`wikicryptopp_ipblocks`
 ADD ipb_auto tinyint NOT NULL default '0',
 ADD ipb_id int NOT NULL auto_increment,
 ADD PRIMARY KEY (ipb_id)

Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/html/w/maintenance/arch
ives/patch-ipblocks.sql )
Error: 1142 ALTER command denied to user 'mwuser'@'localhost' for table 'wikicry
ptopp_ipblocks' (localhost)

Backtrace:
#0 /var/www/html/w/includes/libs/rdbms/database/Database.php(1427): Wikimedia\Rd
bms\Database->makeQueryException(string, integer, string, string)
#1 /var/www/html/w/includes/libs/rdbms/database/Database.php(1200): Wikimedia\Rd
bms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /var/www/html/w/includes/libs/rdbms/database/Database.php(4194): Wikimedia\Rd
bms\Database->query(string, string)
#3 /var/www/html/w/includes/libs/rdbms/database/Database.php(4129): Wikimedia\Rd
bms\Database->sourceStream(unknown type, NULL, NULL, string, NULL)
#4 /var/www/html/w/includes/installer/DatabaseUpdater.php(683): Wikimedia\Rdbms\
Database->sourceFile(string)
#5 /var/www/html/w/includes/installer/DatabaseUpdater.php(751): DatabaseUpdater-
>applyPatch(string, boolean, string)
#6 /var/www/html/w/includes/installer/DatabaseUpdater.php(482): DatabaseUpdater-
>addField(string, string, string)
#7 /var/www/html/w/includes/installer/DatabaseUpdater.php(446): DatabaseUpdater-
>runUpdates(array, boolean)
#8 /var/www/html/w/maintenance/update.php(200): DatabaseUpdater->doUpdates(array
)
#9 /var/www/html/w/maintenance/doMaintenance.php(94): UpdateMediaWiki->execute()
#10 /var/www/html/w/maintenance/update.php(245): require_once(string)
#11 {main}



More information about the MediaWiki-l mailing list