Hi, everybody,
I think I have a problem (I don't know how serious) related to the DB schema of my
wiki (
tunearch.org).
Having said that everything seems to work correctly (navigate, search, edit, …), If I run
php cleanupUsersWithNoId.php --force --prefix=* the program works only with the revision
table
for archive, logging, image, oldimage, filearchive, ipblocks and recentchanges tables I
get an error similar to this:
===============
Beginning cleanup of archive
Wikimedia\Rdbms\DBQueryError from line 1603 of
/var/www/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 `archive` WHERE (1=1) ORDER BY
ar_id LIMIT 100
Function: CleanupUsersWithNoId::cleanup
Error: 1054 Unknown column 'ar_user' in 'field list' (localhost)
and this backtrace.
===============
#0 /var/www/w/includes/libs/rdbms/database/Database.php(1574):
Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Unknown column ...', 1054,
'SELECT ar_id,a...', 'CleanupUsersWit...')
#1 /var/www/w/includes/libs/rdbms/database/Database.php(1152):
Wikimedia\Rdbms\Database->reportQueryError('Unknown column ...', 1054,
'SELECT ar_id,a...', 'CleanupUsersWit...', false)
#2 /var/www/w/includes/libs/rdbms/database/Database.php(1807):
Wikimedia\Rdbms\Database->query('SELECT ar_id,a...',
'CleanupUsersWit...')
#3 /var/www/w/includes/libs/rdbms/database/DBConnRef.php(68):
Wikimedia\Rdbms\Database->select('archive', Array, Array,
'CleanupUsersWit...', Array)
#4 /var/www/w/includes/libs/rdbms/database/DBConnRef.php(315):
Wikimedia\Rdbms\DBConnRef->__call('select', Array)
#5 /var/www/w/maintenance/cleanupUsersWithNoId.php(153):
Wikimedia\Rdbms\DBConnRef->select('archive', Array, Array,
'CleanupUsersWit...', Array)
#6 /var/www/w/maintenance/cleanupUsersWithNoId.php(63):
CleanupUsersWithNoId->cleanup('archive', Array, 'ar_user',
'ar_user_text', Array, Array)
#7 /var/www/w/maintenance/Maintenance.php(1746): CleanupUsersWithNoId->doDBUpdates()
#8 /var/www/w/maintenance/doMaintenance.php(99): LoggedUpdateMaintenance->execute()
#9 /var/www/w/maintenance/cleanupUsersWithNoId.php(212):
require_once('/var/www/w/main...')
#10 {main}
——
I ran cleanupUsersWithNoId.php to then run migrateActors.php because an error received
during the installation of an extension (e.g. Extension:Comments) suggested that I had not
run my "application's database schema updater after upgrading".
Any help is appreciated
==========
MediaWiki 1.34.0 (ae6e0c0) 09:53, December 27, 2019
PHP 7.2.17-0ubuntu0.18.04.1 (apache2handler)
MariaDB 10.1.38-MariaDB-0ubuntu0.18.04.1
Valerio Pelliccioni
https://tunearch.org