I'm running MediaWiki 1.35.1, which has been working flawlessly for several years now, and have just suddenly run into all pages throwing up a RevisionAccessException error. I have not changed the credentials, database location or contents, or users at all; the only activity has been normal user edits to articles over the past few weeks. I have two other MediaWiki installations of the same version on the same server that are still humming along just fine without any issues. Connectivity is fine, disk space is fine, and CHECK TABLE finds no corruption issues to be repaired. I'm running a number of extensions; none of those have been changed recently, either, but I went ahead and commented them out to see if that solved the issue, to no avail. I've done my due diligence digging around online, but other users with this issue seem to all be due to corruption from migration or upgrade, neither of which I've performed lately, and I can't find any corrupted tables to fix anywhere.

Anyone have any idea what's going on before I start doing drastic things like restoring from a backup (which unfortunately will lose some user edits/articles) or upgrading?

Error:

MediaWiki internal error.

Original exception: [Zq503mGc9ZlRHsLWMP7pQAAAAJU] /DCWiki/index.php/Main_Page MediaWiki\Revision\RevisionAccessException from line 1033 of /home/gothamby/public_html/DCWiki/includes/Revision/RevisionStore.php: Failed to load data blob from tt:11347: Unable to fetch blob at tt:11347

Backtrace:

#0 /home/gothamby/public_html/DCWiki/includes/Revision/RevisionStore.php(1280): MediaWiki\Revision\RevisionStore->loadSlotContent(MediaWiki\Revision\SlotRecord, NULL, NULL, NULL, integer)

#1 [internal function]: MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(MediaWiki\Revision\SlotRecord)

#2 /home/gothamby/public_html/DCWiki/includes/Revision/SlotRecord.php(307): call_user_func(Closure, MediaWiki\Revision\SlotRecord)

#3 /home/gothamby/public_html/DCWiki/includes/Revision/RevisionRecord.php(175): MediaWiki\Revision\SlotRecord->getContent()

#4 /home/gothamby/public_html/DCWiki/includes/page/Article.php(525): MediaWiki\Revision\RevisionRecord->getContent(string, integer, User)

#5 /home/gothamby/public_html/DCWiki/includes/page/Article.php(757): Article->fetchRevisionRecord()

#6 /home/gothamby/public_html/DCWiki/includes/actions/ViewAction.php(74): Article->view()

#7 /home/gothamby/public_html/DCWiki/includes/MediaWiki.php(527): ViewAction->show()

#8 /home/gothamby/public_html/DCWiki/includes/MediaWiki.php(313): MediaWiki->performAction(Article, Title)

#9 /home/gothamby/public_html/DCWiki/includes/MediaWiki.php(940): MediaWiki->performRequest()

#10 /home/gothamby/public_html/DCWiki/includes/MediaWiki.php(543): MediaWiki->main()

#11 /home/gothamby/public_html/DCWiki/index.php(53): MediaWiki->run()

#12 /home/gothamby/public_html/DCWiki/index.php(46): wfIndexMain()

#13 {main}

Exception caught inside exception handler: [Zq503mGc9ZlRHsLWMP7pQAAAAJU] /DCWiki/index.php/Main_Page MediaWiki\Revision\RevisionAccessException from line 1033 of /home/gothamby/public_html/DCWiki/includes/Revision/RevisionStore.php: Failed to load data blob from tt:2590: Unable to fetch blob at tt:2590

Backtrace:

#0 /home/gothamby/public_html/DCWiki/includes/Revision/RevisionStore.php(1280): MediaWiki\Revision\RevisionStore->loadSlotContent(MediaWiki\Revision\SlotRecord, NULL, NULL, NULL, integer)

#1 [internal function]: MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(MediaWiki\Revision\SlotRecord)

#2 /home/gothamby/public_html/DCWiki/includes/Revision/SlotRecord.php(307): call_user_func(Closure, MediaWiki\Revision\SlotRecord)

#3 /home/gothamby/public_html/DCWiki/includes/Revision/RevisionRecord.php(175): MediaWiki\Revision\SlotRecord->getContent()

#4 /home/gothamby/public_html/DCWiki/includes/cache/MessageCache.php(1185): MediaWiki\Revision\RevisionRecord->getContent(string)

#5 /home/gothamby/public_html/DCWiki/includes/libs/objectcache/wancache/WANObjectCache.php(1529): MessageCache->{closure}(boolean, integer, array, NULL, array)

#6 /home/gothamby/public_html/DCWiki/includes/libs/objectcache/wancache/WANObjectCache.php(1376): WANObjectCache->fetchOrRegenerate(string, integer, Closure, array, array)

#7 /home/gothamby/public_html/DCWiki/includes/cache/MessageCache.php(1205): WANObjectCache->getWithSetCallback(string, integer, Closure)

#8 /home/gothamby/public_html/DCWiki/includes/libs/objectcache/BagOStuff.php(149): MessageCache->{closure}(integer)

#9 /home/gothamby/public_html/DCWiki/includes/cache/MessageCache.php(1207): BagOStuff->getWithSetCallback(string, integer, Closure)

#10 /home/gothamby/public_html/DCWiki/includes/cache/MessageCache.php(1109): MessageCache->loadCachedMessagePageEntry(string, string, string)

#11 /home/gothamby/public_html/DCWiki/includes/cache/MessageCache.php(1017): MessageCache->getMsgFromNamespace(string, string)

#12 /home/gothamby/public_html/DCWiki/includes/cache/MessageCache.php(988): MessageCache->getMessageForLang(LanguageEn, string, boolean, array)

#13 /home/gothamby/public_html/DCWiki/includes/cache/MessageCache.php(930): MessageCache->getMessageFromFallbackChain(LanguageEn, string, boolean)

#14 /home/gothamby/public_html/DCWiki/includes/language/Message.php(1304): MessageCache->get(string, boolean, LanguageEn)

#15 /home/gothamby/public_html/DCWiki/includes/language/Message.php(862): Message->fetchMessage()

#16 /home/gothamby/public_html/DCWiki/includes/language/Message.php(966): Message->toString(string)

#17 /home/gothamby/public_html/DCWiki/includes/skins/Skin.php(1696): Message->plain()

#18 /home/gothamby/public_html/DCWiki/includes/skins/Skin.php(1644): Skin->addToSidebar(array, string)

#19 /home/gothamby/public_html/DCWiki/includes/skins/Skin.php(1673): Skin->{closure}()

#20 /home/gothamby/public_html/DCWiki/includes/skins/SkinTemplate.php(384): Skin->buildSidebar()

#21 /home/gothamby/public_html/DCWiki/includes/skins/SkinTemplate.php(127): SkinTemplate->prepareQuickTemplate()

#22 /home/gothamby/public_html/DCWiki/includes/skins/SkinTemplate.php(144): SkinTemplate->generateHTML()

#23 /home/gothamby/public_html/DCWiki/includes/OutputPage.php(2615): SkinTemplate->outputPage()

#24 /home/gothamby/public_html/DCWiki/includes/exception/MWExceptionRenderer.php(153): OutputPage->output()

#25 /home/gothamby/public_html/DCWiki/includes/exception/MWExceptionRenderer.php(65): MWExceptionRenderer::reportHTML(MediaWiki\Revision\RevisionAccessException)

#26 /home/gothamby/public_html/DCWiki/includes/exception/MWExceptionHandler.php(106): MWExceptionRenderer::output(MediaWiki\Revision\RevisionAccessException, integer)

#27 /home/gothamby/public_html/DCWiki/includes/exception/MWExceptionHandler.php(185): MWExceptionHandler::report(MediaWiki\Revision\RevisionAccessException)

#28 /home/gothamby/public_html/DCWiki/includes/MediaWiki.php(576): MWExceptionHandler::handleException(MediaWiki\Revision\RevisionAccessException, string)

#29 /home/gothamby/public_html/DCWiki/index.php(53): MediaWiki->run()

#30 /home/gothamby/public_html/DCWiki/index.php(46): wfIndexMain()

#31 {main}

For reference, list of extensions:

CategoryTree

Cite

ImageMap

InputBox

MP3MediaHandler

PageImages

ParserFunctions

Popups

TextExtracts

WikiEditor

Have a look for findBadBlobs.php. It should be located under ~/maintenance subdir. HTH --M7 (talk) 18:43, 3 August 2024 (UTC)

Thank you!

It's there, but unfortunately I don't have shell access (this is hosted remotely via Byethost) so I can't run it directly. The Maintenance extension also can't help me, as the error itself is preventing access to all Special pages.

It looks like I might be down to having to write a custom script?

May I suggest to mirror the malfunctioning installation to a local test environment and to try figuring out with a direct access. Then re-upload once fixed. --M7 (talk) 19:20, 3 August 2024 (UTC)

Hi, I'm looking to import templates from Wikipedia, such as Infobox: military conflict or Template: flag but can't figure it out. Can anyone tell me how I can import Templates or do I have to write my own?

Thanks for any help.

English Wikipedia has extremely complex infoboxes, and they are pretty difficult to import. You'll need a good dose of knowledge of Wikipedia, and several extensions like ParserFunctions, Scribunto, TemplateStyles. And even then, many Infoboxes now have a level of integrations with Wikidata, which you won't have, that might require you to explicitly REMOVE that code from your imported templates. In many cases it will be easier to make your own simpler version of infoboxes.

It may be worth looking at older versions of the infobox, or those from other wikis, which may be less complex.

I'm having this issue with infoboxes (that IIRC I imported from the Miraheze Developers Wiki). I didn't have this issue when I originally imported them, something has broken. I can't find anything online about this specific error.

Please see "Post a new question" in the sidebar.

If that's a request for more information, my wiki is cyberpedia.miraheze.org and the MediaWiki version is 1.42.1

Does miraheze have a global lua module system? If so, this sounds like it would be related to that. You might have better luck at miraheze support.

Can anyone tell me how can I properly run update.php

Database error

A database query error has occurred. This may indicate a bug in the software.

[158efade797e34701c69d478] /globaltest/mediawiki-1.42.1/mediawiki-1.42.1/index.php?title=Special:UserLogin&returnto=Main+Page Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'steward.globalblocks' doesn't exist

Function: MediaWiki\Extension\GlobalBlocking\Services\GlobalBlockLookup::getGlobalBlockingBlock

Query: SELECT gb_id,gb_address,gb_target_central_id,gb_by,gb_by_central_id,gb_by_wiki,gb_reason,gb_timestamp,gb_anon_only,gb_expiry,gb_range_start,gb_range_end FROM `globalblocks` WHERE ((gb_expiry > '20240802161626' AND (gb_range_start LIKE 'v6-0000%' ESCAPE '`' AND gb_range_start <= 'v6-00000000000000000000000000000001' AND gb_range_end >= 'v6-00000000000000000000000000000001')))

You should follow the instructions on the extension's documentation page or if any of the steps are unclear, ask for help on the specific step.

I've been having a problem for a few days where not all edits are listed in the recent changes. For example, file uploads or page deletions are not appearing. When I run therebuildrecentchanges.php, everything shows up, but I can't run it every minute? Last week, I ran the rebuildall.php script... could that be the cause?

In the logs, everything is displayed correctly.

Can you check if the job queue is running properly (e.g. run showJobs.php --group

0 queued; 4 claimed (0 active, 4 abandoned); 0 delayed

Unfortunately, I still have the problem. Only with running therebuildrecentchanges.php I get everything...

Huh, im not sure.

Could you enable mediawiki debug logging, - $wgDebugLogFile, do one of the actions that arent being logged, and check for any exceptions, particularly those marked [deferred] or anything marked recentchanges, logging, or jobqueue. (Note, it is expected that this is a very verbose log. Most entries will be totally normal noise and not errors).

i want to move the storage to cloud is it possible

You might be interested in Extension:AWS.

Hi. I want to update MediaWiki from version 1.40 to 1.42.1 and during the update I get this error:

Updating category collations... Selecting next 100 pages from cl_from = 0... processing... 0 done. Selecting next 100 pages from cl_from = 100... processing... 0 done. Selecting next 100 pages from cl_from = 200... processing... 0 done. Selecting next 100 pages from cl_from = 300... processing... 0 done. Selecting next 100 pages from cl_from = 400... processing... 0 done. Selecting next 100 pages from cl_from = 500... processing... 0 done. Selecting next 100 pages from cl_from = 600... processing... 0 done. Selecting next 100 pages from cl_from = 700... processing... 0 done. Selecting next 100 pages from cl_from = 800... processing... 0 done. Selecting next 100 pages from cl_from = 900... processing... 0 done. Selecting next 100 pages from cl_from = 1000... processing... 0 done. Selecting next 100 pages from cl_from = 1100... processing... 0 done. Selecting next 100 pages from cl_from = 1200... processing... 0 done. Selecting next 100 pages from cl_from = 1300... processing... 0 done. Selecting next 100 pages from cl_from = 1400... processing... 0 done. Selecting next 100 pages from cl_from = 1500... processing... 0 done. Selecting next 100 pages from cl_from = 1600... processing... 0 done. Selecting next 100 pages from cl_from = 1700... processing... 0 done. 0 rows processed ...done. ...have rev_actor field in revision table. ...watchlist_expiry table already exists. ...page_restrictions field does not exist in page table, skipping modify field patch. ...index ipb_address_unique already set on ipblocks table. ...archive table does not contain ar_text_id field. ...lc_lang is up-to-date. ...ll_lang is up-to-date. ...site_language is up-to-date. ...index ipb_address_unique on table ipblocks has no field ipb_anon_only; added. ...ipb_address_unique index up-to-date. ...actor_name in table actor already modified by patch patch-actor-actor_name-varbinary.sql. ...site_global_key in table sites already modified by patch patch-sites-site_global_key.sql. ...iwl_prefix in table iwlinks already modified by patch patch-extend-iwlinks-iwl_prefix.sql. ...rd_title in table redirect already modified by patch patch-redirect-rd_title-varbinary.sql. ...pl_title in table pagelinks already modified by patch patch-pagelinks-pl_title-varbinary.sql. ...tl_title field does not exist in templatelinks table, skipping modify field patch. ...il_to in table imagelinks already modified by patch patch-imagelinks-il_to-varbinary.sql. ...ll_title in table langlinks already modified by patch patch-langlinks-ll_title-varbinary.sql. ...iwl_title in table iwlinks already modified by patch patch-iwlinks-iwl_title-varbinary.sql. ...cat_title in table category already modified by patch patch-category-cat_title-varbinary.sql. ...qc_title in table querycache already modified by patch patch-querycache-qc_title-varbinary.sql. ...qcc_title in table querycachetwo already modified by patch patch-querycachetwo-qcc_title-varbinary.sql. ...wl_title in table watchlist already modified by patch patch-watchlist-wl_title-varbinary.sql. ...user_last_timestamp in table user_newtalk already modified by patch patch-user_newtalk-user_last_timestamp-binary.sql. ...pt_title in table protected_titles already modified by patch patch-protected_titles-pt_title-varbinary.sql. ...ir_type in table ipblocks_restrictions already modified by patch patch-ipblocks_restrictions-ir_type.sql. ...index wl_namespace_title already set on watchlist table. ...job_title in table job already modified by patch patch-job-job_title-varbinary.sql. ...job_timestamp in table job already modified by patch patch-job_job_timestamp.sql. ...job_token_timestamp in table job already modified by patch patch-job_job_token_timestamp.sql. ...wl_notificationtimestamp in table watchlist already modified by patch patch-watchlist-wl_notificationtimestamp.sql. ...role_id in table slot_roles already modified by patch patch-slot_roles-role_id.sql. ...model_id in table content_models already modified by patch patch-content_models-model_id.sql. ...cl_to in table categorylinks already modified by patch patch-categorylinks-cl_to-varbinary.sql. ...log_title in table logging already modified by patch patch-logging-log_title-varbinary.sql. ...us_timestamp in table uploadstash already modified by patch patch-uploadstash-us_timestamp.sql. ...index up_property already set on user_properties table. ...index site_global_key already set on sites table. ...index log_type_time already set on logging table. ...fa_name in table filearchive already modified by patch patch-filearchive-fa_name.sql. ...oi_name in table oldimage already modified by patch patch-oldimage-oi_name-varbinary.sql. ...exptime in table objectcache already modified by patch patch-objectcache-exptime-notnull.sql. ...index ar_name_title_timestamp already set on archive table. ...img_name in table image already modified by patch patch-image-img_name-varbinary.sql. ...img_timestamp in table image already modified by patch patch-image-img_timestamp.sql. ...index si_key already set on site_identifiers table. ...rc_title in table recentchanges already modified by patch patch-recentchanges-rc_title-varbinary.sql. ...rc_timestamp in table recentchanges already modified by patch patch-recentchanges-rc_timestamp.sql. ...rc_id in table recentchanges already modified by patch patch-recentchanges-rc_id.sql. ...index rc_new_name_timestamp already set on recentchanges table. ...ar_title in table archive already modified by patch patch-archive-ar_title-varbinary.sql. ...page_title in table page already modified by patch patch-page-page_title-varbinary.sql. ...user_name in table user already modified by patch patch-user_table-updates.sql. ...index rev_page_timestamp already set on revision table. ...have modtoken field in objectcache table. ...index oi_timestamp already set on oldimage table. ...index page_name_title already set on page table. ...index ct_rc_tag_id already set on change_tag table. ...page_restrictions table does not contain pr_user field. ...fa_id in table filearchive already modified by patch patch-filearchive-fa_id.sql. ...img_major_mime in table image already modified by patch patch-image-img_major_mime-default.sql. ...linktarget table already exists. ...rev_page_id key doesn't exist. ...pr_page in table page_restrictions already modified by patch patch-page_restrictions-pr_page.sql. ...pp_page in table page_props already modified by patch patch-page_props-pp_page.sql. ...ir_value in table ipblocks_restrictions already modified by patch patch-ipblocks_restrictions-ir_value.sql. ...have tl_target_id field in templatelinks table. ...user_autocreate_serial table already exists. ...ir_ipb_id in table ipblocks_restrictions already modified by patch patch-ipblocks_restrictions-ir_ipb_id.sql. ...ipb_id in table ipblocks already modified by patch patch-ipblocks-ipb_id.sql. ...user_editcount in table user already modified by patch patch-user-user_editcount.sql. Running maintenance/migrateRevisionActorTemp.php... ...Update 'MigrateRevisionActorTemp' already logged as completed. Use --force to run it again. done. ...revision_actor_temp doesn't exist. Running maintenance/updateRestrictions.php... Migration is not needed. done. ...page table does not contain page_restrictions field. ...templatelinks table has already been migrated. ...tl_namespace field does not exist in templatelinks table, skipping modify field patch. ...templatelinks table does not contain tl_title field. ...have el_to_path field in externallinks table. ...have user_is_temp field in user table. Running maintenance/migrateRevisionCommentTemp.php... ...Update 'MigrateRevisionCommentTemp' already logged as completed. Use --force to run it again. done. ...revision_comment_temp doesn't exist. Running maintenance/migrateExternallinks.php... ...Update 'MigrateExternallinks' already logged as completed. Use --force to run it again. done. ...el_to field does not exist in externallinks table, skipping modify field patch. ...have pl_target_id field in pagelinks table. ...externallinks table does not contain el_to field. Running maintenance/fixInconsistentRedirects.php... ...Update 'FixInconsistentRedirects' already logged as completed. Use --force to run it again. done. ...img_size in table image already modified by patch patch-image-img_size_to_bigint.sql. ...fa_size in table filearchive already modified by patch patch-filearchive-fa_size_to_bigint.sql. ...oi_size in table oldimage already modified by patch patch-oldimage-oi_size_to_bigint.sql. ...us_size in table uploadstash already modified by patch patch-uploadstash-us_size_to_bigint.sql. Adding uas_year field to table user_autocreate_serial...done. Creating block_target table...done. Dropping cl_collation_ext index from table categorylinks...done. Running maintenance/populateUserIsTemp.php... done. Dropping site_type index from table sites...done. Dropping iwl_prefix_from_title index from table iwlinks...done. Running /home/xx/xx/x/wiki/extensions/OATHAuth/maintenance/updateTOTPScratchTokensToArray.php...

An error occurred: Error 1044: Access denied for user '12345_wiki'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`

Please help.

Do you run a separate wgOATHAuthDatabase (and/or what is the current setting) or do you use wgSharedTables ?

I downloaded the 1.42.1 package from the MediaWiki website, sent the contents of the files from this package to the FTP server, overwriting the current ones. I started the update process.

Example:

mysite.pl/wiki/mw-config

I entered the $wgUpgradeKey from LocalSettings.php on the update page and then I get these errors.

And I don't understand why I have a connection error:

An error occurred: Error 1044: Access denied for user '12345_wiki'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`

And I don't understand why I have this error:

/home/xx/xx/x/wiki/extensions/OATHAuth/maintenance/updateTOTPScratchTokensToArray.php...

I don't have anything like $wgOATHAuthDatabase or wgSharedTables in the LocalSettings.php file

Ah.

> overwriting the current ones

But that doesn't delete the files that have been removed, which can cause issues when loading the site. Please read again Manual:Upgrading.

Additionally, you didn't update your extensions yet and therefor your OathAuth extension is not compatible with this newer MediaWiki version. You can either choose to update all your extensions, or a bit easier / less confusing, can be to

1. first disable all your extension in LocalSettings.php
2. upgrade the core with the updater
3. install the newer versions of extensions
4. re-enable the extensions in your LocalSettings.php
5. run the updater again to ensure the extensions can run all their updates

Hi. I left only the images directory and the LocalSettings.php file on the server, then I uploaded new content from the mediawiki-1.42.1 package and the latest versions of the extensions I use. I started the MediaWiki update process and I get the same error:

...site_type key doesn't exist. ...iwl_prefix_from_title key doesn't exist. Running /home/xx/xx/mysite.pl/wiki/extensions/OATHAuth/maintenance/updateTOTPScratchTokensToArray.php...

An error occurred: Error 1044: Access denied for user '12345_wiki'@'%' to database 'virtual' Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain Query: USE `virtual`

You are like the fourth person to report this. Would you be able to post your LocalSettings.php (redacting passwords)

Which data do you want to see? Do you mean the entire contents of this file? How did those people solve this problem? These are the extensions I have installed:

CreatePageUw DarkMode PageForms TinyMCE

This is the skin I have installed:

Citizen

None of them did (afaik). I was just hoping that the LocalSettings.php file would reveal some difference in configuration that might hint at what the issue is.

hello. i got the following error when using my wiki on localhost. [5bd33e289f61b2dad3206ac6] 2024-08-01 21:31:35: Fatal exception of type "Wikimedia\Rdbms\DBQueryDisconnectedError"

Hi, I noticed that if a user with "bot" permission pinging in the edit summary, the ping is not sent. what can be done? Thanks in advance!

Bots are often excluded from pings yes. Which bot and which wiki are we talking about ?

@TheDJ This is a wiki site that does not belong to the Wikimedia Foundation. Manual edits are made through the bot account, so it is necessary for pings to be sent.

@TheDJ?

Thank you!

@AhmadF.Cheema Thank you for providing this response, but none of the extension solutions worked. In my case, I am trying to migrate a wiki from a much older version to a new version by installing the extensions and then doing an XML import of the data from the older wiki. The old wiki does not have the problem of displaying the category as a prefix, but the new one does after the XML import. Should I have "Extension:Display Title" installed prior to the import? Does the order of XML import and extension installation matter?