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
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l