Fixed!

Claud AI suggested I comment out the OATHAuth extension call in LocalSettings and run update.php. It worked!

Here is what Claud said, when I asked if I need OATHAuth:

If you're not currently using 2FA and don't plan to implement it, you can safely disable this extension. Here's how:

1. Edit your LocalSettings.php file and look for a line like:

php

wfLoadExtension('OATHAuth');

2. Comment it out by adding // at the beginning:

php

// wfLoadExtension('OATHAuth');

3. Then run the update script again:

php maintenance/run.php update

So I did that and hm, what else may I have broken today?

My sharpie,

Thank you fellow Wikians, for your confidence, Claud also!

See Mom, no hands!

https://teflpedia.com/index.php/Special:SpecialPages

Now to implement short urls which this wiki is supposed to have because I was so cleaver decades ago... surely...

Roger

On Fri, Apr 11, 2025 at 5:22 PM rogerchrisman@gmail.com wrote:

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}