Re: Upgrade trouble MediaWiki 1.39.1 to MediaWiki 1.43.1

This sounds like https://phabricator.wikimedia.org/T371849

A workaround is to upgrade first to 1.41.


On 12/4/25 08:22, [email protected] wrote:
> Dear Wikians,
>
> I am having trouble upgrading teflpedia.com 
> <http://teflpedia.com/> from MediaWiki 1.39.1 to MediWiki 1.43.1.
>
> I tried webgetting MediaWiki 1.43.1 and then running "php 
> maintenance/run.php update" and it kinda worked, but I couldn't log 
> in. Got a log in error like this:
>
> -------------------------------
> Database error
> A database query error has occurred. This may indicate a bug in the 
> software.
> ! [c93cfb4e1d37618f6a3dcd5f] 2025-04-11 23:55:53: Fatal exception of 
> type "Wikimedia\Rdbms\DBQueryError"
> ------------------------------
>
> So I tried a clean fresh Web install of MediaWiki 1.43.1 onto a clean 
> new database (that I created in cPanel first). I selected all the 
> extensions and options except Use Commons Images. That worked. Blank 
> new MediaWiki 1.43.1. I can log in with no error.
>
> But I need my wiki and all its pages.
>
> So I restored my wiki database using cPanel > Backup > Restore A 
> Database Backup and my wiki's MediaWiki 1.39.1 database backup that I 
> had made with cPanel yesterday. And then ran "php maintenance/run.php 
> update". Output snip below.
>
> Now I have my wiki pages, but I get the above login error again.
>
> A similar error message appears when you try to visit 
> https://teflpedia.com/index.php/Special:SpecialPages
>
> I put $wgShowExceptionDetails = true; at the bottom on 
> LocalSettings.php in teflpedia.com <http://teflpedia.com/> but don't 
> see any details from that showing.
>
> Do you see any hints in the below  "php maintanance/run.php update" 
> output  what may be causing the above error?
>
> Any clues at all will be greatly appreciated.
>
> Thank you, Roger
>
> -----------------------snip of very long maintenance/update.php output 
> --------------------------
> Running MediaWiki\Extension\AbuseFilter\Maintenance\MigrateActorsAF...
> Beginning migration of abuse_filter.af_user and 
> abuse_filter.af_user_text to abuse_filter.af_actor
> ... af_id=16
> Completed migration, updated 16 row(s) with 0 new actor(s), 0 error(s)
> Beginning migration of abuse_filter_history.afh_user and 
> abuse_filter_history.afh_user_text to abuse_filter_history.afh_actor
> ... afh_id=16
> Completed migration, updated 16 row(s) with 0 new actor(s), 0 error(s)
> done.
> Table abuse_filter contains af_user field. Dropping...done.
> Table abuse_filter_history contains afh_user field. Dropping...done.
> ...discussiontools_subscription table already exists.
> ...discussiontools_items table already exists.
> ...echo_event table already exists.
> ...echo_push_provider table already exists.
> ...echo_push_subscription table already exists.
> ...echo_push_topic table already exists.
> ...index eps_user already set on echo_push_subscription table.
> ...echo_push_subscription_token key doesn't exist.
> ...index eps_token already set on echo_push_subscription table.
> ...have eps_topic field in echo_push_subscription table.
> ...echo_unread_wikis table already exists.
> ...linter table already exists.
> ...have linter_namespace field in linter table.
> ...have linter_template field in linter table.
> Modifying linter_params field of table linter...done.
> ...loginnotify_seen_net table already exists.
> Dropping table mathoid ...done.
> Dropping table mathlatexml ...done.
> Running 
> MediaWiki\Extension\OATHAuth\Maintenance\UpdateTOTPScratchTokensToArray...
> Done.
> done.
> Running 
> MediaWiki\Extension\OATHAuth\Maintenance\UpdateForMultipleDevicesSupport...
> Wikimedia\Rdbms\DBQueryError from line 1198 of 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/database/Database.php: 
> Error 1146: Table 'bilbo_teflpedia.oathauth_types' doesn't exist
> Function: 
> MediaWiki\Extension\OATHAuth\OATHAuthModuleRegistry::getModuleIdsFromDatabase
> Query: SELECT  oat_id,oat_name  FROM `oathauth_types`
>
> #0 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/database/Database.php(1182): 
> Wikimedia\Rdbms\Database->getQueryException()
> #1 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/database/Database.php(1156): 
> Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
> #2 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/database/Database.php(647): 
> Wikimedia\Rdbms\Database->reportQueryError()
> #3 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/database/Database.php(1345): 
> Wikimedia\Rdbms\Database->query()
> #4 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/database/DBConnRef.php(127): 
> Wikimedia\Rdbms\Database->select()
> #5 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/database/DBConnRef.php(351): 
> Wikimedia\Rdbms\DBConnRef->__call()
> #6 
> /home/bilbo/public_html/teflpedia/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(745): 
> Wikimedia\Rdbms\DBConnRef->select()
> #7 
> /home/bilbo/public_html/teflpedia/extensions/OATHAuth/src/OATHAuthModuleRegistry.php(132): 
> Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
> #8 
> /home/bilbo/public_html/teflpedia/extensions/OATHAuth/src/OATHAuthModuleRegistry.php(93): 
> MediaWiki\Extension\OATHAuth\OATHAuthModuleRegistry->getModuleIdsFromDatabase()
> #9 
> /home/bilbo/public_html/teflpedia/extensions/OATHAuth/maintenance/UpdateForMultipleDevicesSupport.php(56): 
> MediaWiki\Extension\OATHAuth\OATHAuthModuleRegistry->getModuleIds()
> #10 
> /home/bilbo/public_html/teflpedia/maintenance/includes/LoggedUpdateMaintenance.php(51): 
> MediaWiki\Extension\OATHAuth\Maintenance\UpdateForMultipleDevicesSupport->doDBUpdates()
> #11 
> /home/bilbo/public_html/teflpedia/includes/installer/DatabaseUpdater.php(1140): 
> MediaWiki\Maintenance\LoggedUpdateMaintenance->execute()
> #12 
> /home/bilbo/public_html/teflpedia/includes/installer/DatabaseUpdater.php(595): 
> MediaWiki\Installer\DatabaseUpdater->runMaintenance()
> #13 
> /home/bilbo/public_html/teflpedia/includes/installer/DatabaseUpdater.php(552): 
> MediaWiki\Installer\DatabaseUpdater->runUpdates()
> #14 /home/bilbo/public_html/teflpedia/maintenance/update.php(195): 
> MediaWiki\Installer\DatabaseUpdater->doUpdates()
> #15 
> /home/bilbo/public_html/teflpedia/maintenance/includes/MaintenanceRunner.php(703): 
> UpdateMediaWiki->execute()
> #16 /home/bilbo/public_html/teflpedia/maintenance/run.php(51): 
> MediaWiki\Maintenance\MaintenanceRunner->run()
> #17 {main}
>
>
> _______________________________________________
> MediaWiki-l mailing list [email protected]
> To unsubscribe send an email [email protected]
> https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/

_______________________________________________
MediaWiki-l mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/