Hi Everyone,
We upgraded to MW 1.34.1. maintenance/update.php was run during the upgrade process.
We are now doing post-install maintenance, like running a cleanup script (https://github.com/weidai11/website/blob/master/root/cleanup-wiki.sh). The script is complaining:
Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/html/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT ar_id,ar_user,ar_user_text,ar_id FROM `wikicryptopp_archive` WHERE (1=1) ORDER BY ar_id LIMIT 100 Function: CleanupUsersWithNoId::cleanup Error: 1054 Unknown column 'ar_user' in 'field list' (localhost)
#0 /var/www/html/w/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Unknown column ...', 1054, 'SELECT ar_id,a...', 'CleanupUsersWit...') #1 /var/www/html/w/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError('Unknown column ...', 1054, 'SELECT ar_id,a...', 'CleanupUsersWit...', false) #2 /var/www/html/w/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query('SELECT ar_id,a...', 'CleanupUsersWit...') #3 /var/www/html/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select('archive', Array, Array, 'CleanupUsersWit...', Array) #4 /var/www/html/w/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call('select', Array) #5 /var/www/html/w/maintenance/cleanupUsersWithNoId.php(153): Wikimedia\Rdbms\DBConnRef->select('archive', Array, Array, 'CleanupUsersWit...', Array) #6 /var/www/html/w/maintenance/cleanupUsersWithNoId.php(63): CleanupUsersWithNoId->cleanup('archive', Array, 'ar_user', 'ar_user_text', Array, Array) #7 /var/www/html/w/maintenance/Maintenance.php(1746): CleanupUsersWithNoId->doDBUpdates() #8 /var/www/html/w/maintenance/doMaintenance.php(99): LoggedUpdateMaintenance->execute() #9 /var/www/html/w/maintenance/cleanupUsersWithNoId.php(212): require_once('/var/www/html/w...') #10 {main}
The script used to work with MW 1.33.
Jeff
Hi Jeffrey, see the deprecation notice on < https://www.mediawiki.org/wiki/Manual:Archive_table#ar_user%3E and the documentation at https://www.mediawiki.org/wiki/Actor_migration.
Emufarmers
On Mon, Apr 20, 2020 at 5:36 PM Jeffrey Walton noloader@gmail.com wrote:
Hi Everyone,
We upgraded to MW 1.34.1. maintenance/update.php was run during the upgrade process.
We are now doing post-install maintenance, like running a cleanup script ( https://github.com/weidai11/website/blob/master/root/cleanup-wiki.sh). The script is complaining:
Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/html/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT ar_id,ar_user,ar_user_text,ar_id FROM `wikicryptopp_archive` WHERE (1=1) ORDER BY ar_id LIMIT 100 Function: CleanupUsersWithNoId::cleanup Error: 1054 Unknown column 'ar_user' in 'field list' (localhost)
#0 /var/www/html/w/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Unknown column ...', 1054, 'SELECT ar_id,a...', 'CleanupUsersWit...') #1 /var/www/html/w/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError('Unknown column ...', 1054, 'SELECT ar_id,a...', 'CleanupUsersWit...', false) #2 /var/www/html/w/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query('SELECT ar_id,a...', 'CleanupUsersWit...') #3 /var/www/html/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select('archive', Array, Array, 'CleanupUsersWit...', Array) #4 /var/www/html/w/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call('select', Array) #5 /var/www/html/w/maintenance/cleanupUsersWithNoId.php(153): Wikimedia\Rdbms\DBConnRef->select('archive', Array, Array, 'CleanupUsersWit...', Array) #6 /var/www/html/w/maintenance/cleanupUsersWithNoId.php(63): CleanupUsersWithNoId->cleanup('archive', Array, 'ar_user', 'ar_user_text', Array, Array) #7 /var/www/html/w/maintenance/Maintenance.php(1746): CleanupUsersWithNoId->doDBUpdates() #8 /var/www/html/w/maintenance/doMaintenance.php(99): LoggedUpdateMaintenance->execute() #9 /var/www/html/w/maintenance/cleanupUsersWithNoId.php(212): require_once('/var/www/html/w...') #10 {main}
The script used to work with MW 1.33.
Jeff
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org