Sorry for reviving an old forum thread. But I gave up in the end and I was in the hospital for several weeks (and finally also completely forgot about this).
Anyways. I decided to update the current installation from 1.31.1 to the latest stable version 1.34.
At first everything seemed okay. However I noticed again some articles are missing. No real special characters or such.
I looked at the upgrade log and I noticed the following:
Completed migration, updated 2341 row(s) with 33 new actor(s), 1370 error(s)
Beginning migration of archive.ar_user and archive.ar_user_text to archive.ar_actor
User name "Mr coko" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.
User name "Michel" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.
Okay, so I did some searching on this. Apparantly I need to run:
php cleanupUsersWithNoId.php --dbuser=DBUSER--dbpass=DBPASSWORD --force --prefix=* --conf=../LocalSettings.php
Well again errors:
Beginning cleanup of revision
... rev_timestamp=20150617134238 rev_id=381
... rev_timestamp=20150722094638 rev_id=518
... rev_timestamp=20151127085305 rev_id=642
... rev_timestamp=20160426071624 rev_id=747
... rev_timestamp=20170427053837 rev_id=1354
... rev_timestamp=20171025135944 rev_id=1863
... rev_timestamp=20180626112633 rev_id=2994
... rev_timestamp=20191210182547 rev_id=3718
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of archive
Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/vhosts/sub.domain.com/httpdocs/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)
#0 /var/www/vhosts/sub.domain.com/httpdocs/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Unknown column ...', 1054, 'SELECT ar_id,a...', 'CleanupUsersWit...')
#1 /var/www/vhosts/sub.domain.com/httpdocs/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError('Unknown column ...', 1054, 'SELECT ar_id,a...', 'CleanupUsersWit...', false)
#2 /var/www/vhosts/sub.domain.com/httpdocs/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query('SELECT ar_id,a...', 'CleanupUsersWit...')
#3 /var/www/vhosts/sub.domain.com/httpdocs/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select('archive', Array, Array, 'CleanupUsersWit...', Array)
#4 /var/www/vhosts/sub.domain.com/httpdocs/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call('select', Array)
#5 /var/www/vhosts/sub.domain.com/httpdocs/maintenance/cleanupUsersWithNoId.php(153): Wikimedia\Rdbms\DBConnRef->select('archive', Array, Array, 'CleanupUsersWit...', Array)
#6 /var/www/vhosts/sub.domain.com/httpdocs/maintenance/cleanupUsersWithNoId.php(63): CleanupUsersWithNoId->cleanup('archive', Array, 'ar_user', 'ar_user_text', Array, Array)
#7 /var/www/vhosts/sub.domain.com/httpdocs/maintenance/Maintenance.php(1746): CleanupUsersWithNoId->doDBUpdates()
#8 /var/www/vhosts/sub.domain.com/httpdocs/maintenance/doMaintenance.php(99): LoggedUpdateMaintenance->execute()
#9 /var/www/vhosts/sub.domain.com/httpdocs/maintenance/cleanupUsersWithNoId.php(212): require_once('/var/www/vhosts...')
Apparently you have to do that before running php update?
Anyways, reverted to the previous database and ran it again. This time no errors, but also not much happening:
Beginning cleanup of revision
... rev_timestamp=20150617134238 rev_id=381
... rev_timestamp=20150722094638 rev_id=518
... rev_timestamp=20151127085305 rev_id=642
... rev_timestamp=20160426071624 rev_id=747
... rev_timestamp=20170427053837 rev_id=1354
... rev_timestamp=20171025135944 rev_id=1863
... rev_timestamp=20180626112633 rev_id=2994
... rev_timestamp=20191210182547 rev_id=3718
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of archive
... ar_id=72
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of logging
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of image
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of oldimage
... oi_name=Da_bfm_settings.png oi_timestamp=20170116082129
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of filearchive
... fa_id=4
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of ipblocks
Completed cleanup, assigned 0 and prefixed 0 row(s)
Beginning cleanup of recentchanges
... rc_id=3706
... rc_id=3779
Completed cleanup, assigned 0 and prefixed 0 row(s)
Running the update (once again) resulted in the exact same errors. Catch-22?
Why is it so difficult to update Mediawiki 1.31.1 to 1.34? I really do not understand. I haven't had these issues with prior (pre 1.31.x) updates.
Anyways, I will restore everything back and redo everything again. And update from 1.31 to 1.32...... 1.34.
Maybe that will work. I will also run that cleanupUsersWithNoId.php command on my restored 1.31.1 installation.
No clue. Maybe it helps.