[MediaWiki-l] MW 1.31 ==> 1.34 DB Schema (cleanupUsersWithNoId.php)

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[MediaWiki-l] MW 1.31 ==> 1.34 DB Schema (cleanupUsersWithNoId.php)

Valerio Pelliccioni
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