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 <[email protected]> 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}
>
>
_______________________________________________
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/
