Dear Wikians,

I am having trouble upgrading 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 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}