Mailing List Archive: MW 1.34 cleanupUsersWithNoId.php may be out of sync

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

Hi Jeffrey, see the deprecation notice on <
https://www.mediawiki.org/wiki/Manual:Archive_table#ar_user> 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 mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l