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}
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}
This sounds like https://phabricator.wikimedia.org/T371849
A workaround is to upgrade first to 1.41.
On 12/4/25 08:22, rogerchrisman@gmail.com 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 --mediawiki-l@lists.wikimedia.org To unsubscribe send an email tomediawiki-l-leave@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
mediawiki-l@lists.wikimedia.org