Project:Support desk

Welcome to the MediaWiki Support desk. This is a place where you can ask any questions you have about installing, using or administrating the MediaWiki software.

(Read this message in a different language)

See also

• Other places to ask for help

Before you post

• Check the FAQ and Errors and symptoms .
• If your question is about a specific feature, check the relevant technical manual , end-user help or extension page and consider asking on its talk page .
• For issues about the mediawiki.org website, report to Village Pump instead.
• Ask technical questions about Wikimedia websites on meta:Tech instead.

Post a new question

1. To help us answer your questions, please indicate which version of MediaWiki you are using, as found on your wiki's Special:Version page:
2. If possible, add $wgShowExceptionDetails = true;error_reporting( -1 );ini_set( 'display_errors', 1 ); to LocalSettings.php in order to make MediaWiki show more detailed error messages.
3. Please include the web address (URL) to your wiki if possible. It's often easier for us to identify the source of the problem if we can see the error directly.
4. To start a new thread, click the box with the text "Start a new topic".

I moved the wiki to a new server location and am encountering some errors.

For the moving proceedure I simply moved the files and database anc changed LocalSettigs to reflect the new server location.

After a little tweaking the wiki works mainly as normal. I can use the edit source button but the edit button gives me an error like this

[36608ab44f7e307376a5e9ba] Exception caught: Could not open '/home/user_13589/tmp_zswknl/mw-GlobalIdGenerator1021-UUID-128'.

I wonder if there is another step I need to run to ensure everything works as it should?

hi guys!

I was sure I'd find something quickly on this, but getting stuck it seems - and cannot find exactly the same error which is weird

basically trying to restore my old wiki XML dump on newer wiki, which is running on Synology

• MediaWiki 1.39.2
• PHP 8.0.28 (fpm-fcgi)
• MariaDB 10.11.2-MariaDB
• ICU 64.2

the file is quite big and has multiple languages in it (mostly english, but also Russian and Japanese etc).

what else can I try? I am hoping that I can import it like this (without having to restore older files & try to match MySQL version for mysqldump which I also have etc etc).

appreciate any tips !

user@Syn:/var/services/web_packages/mediawiki/maintenance$ php74 importDump.php --conf ../LocalSettings.php < /volume1/Syn/User/mediawiki_backups/wikidb_20140913.xml

MWException from line 724 of /volume1/web_packages/mediawiki/includes/import/WikiImporter.php: Expected <mediawiki> tag, got mysqldump

#0 /volume1/web_packages/mediawiki/maintenance/importDump.php(364): WikiImporter->doImport()

#1 /volume1/web_packages/mediawiki/maintenance/importDump.php(305): BackupReader->importFromHandle(Resource id #760)

#2 /volume1/web_packages/mediawiki/maintenance/importDump.php(139): BackupReader->importFromStdin()

#3 /volume1/web_packages/mediawiki/maintenance/includes/MaintenanceRunner.php(309): BackupReader->execute()

#4 /volume1/web_packages/mediawiki/maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run()

#5 /volume1/web_packages/mediawiki/maintenance/importDump.php(369): require_once('/volume1/web_pa...')

#6 {main}

just for reference beginning of this XML file is

<?xml version="1.0"?>

<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<database name="wikidb">

<table_structure name="mw_archive">

<field Field="ar_id" Type="int(10) unsigned" Null="NO" Key="PRI" Extra="auto_increment" Comment="" />

<field Field="ar_namespace" Type="int(11)" Null="NO" Key="MUL" Default="0" Extra="" Comment="" />

<field Field="ar_title" Type="varbinary(255)" Null="NO" Key="" Default="" Extra="" Comment="" />

<field Field="ar_text" Type="mediumblob" Null="NO" Key="" Extra="" Comment="" />

<field Field="ar_comment" Type="tinyblob" Null="NO" Key="" Extra="" Comment="" />

<field Field="ar_user" Type="int(10) unsigned" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="ar_user_text" Type="varbinary(255)" Null="NO" Key="MUL" Extra="" Comment="" />

<field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="" Extra="" Comment="" />

<field Field="ar_minor_edit" Type="tinyint(4)" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="ar_flags" Type="tinyblob" Null="NO" Key="" Extra="" Comment="" />

<field Field="ar_rev_id" Type="int(10) unsigned" Null="YES" Key="MUL" Extra="" Comment="" />

<field Field="ar_text_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_deleted" Type="tinyint(3) unsigned" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="ar_len" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_page_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_parent_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_sha1" Type="varbinary(32)" Null="NO" Key="" Default="" Extra="" Comment="" />

<field Field="ar_content_format" Type="varbinary(64)" Null="YES" Key="" Extra="" Comment="" />

<field Field="ar_content_model" Type="varbinary(32)" Null="YES" Key="" Extra="" Comment="" />

<key Table="mw_archive" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="ar_id" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="1" Column_name="ar_namespace" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="2" Column_name="ar_title" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="3" Column_name="ar_timestamp" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="usertext_timestamp" Seq_in_index="1" Column_name="ar_user_text" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="usertext_timestamp" Seq_in_index="2" Column_name="ar_timestamp" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_archive" Non_unique="1" Key_name="ar_revid" Seq_in_index="1" Column_name="ar_rev_id" Collation="A" Cardinality="0" Null="YES" Index_type="BTREE" Comment="" Index_comment="" />

<options Name="mw_archive" Engine="InnoDB" Version="10" Row_format="Compact" Rows="0" Avg_row_length="0" Data_length="16384" Max_data_length="0" Index_length="49152" Data_free="5242880" Auto_increment="1" Create_time="2014-09-13 02:23:19" Collation="binary" Create_options="" Comment="" />

</table_structure>

<table_data name="mw_archive">

</table_data>

<table_structure name="mw_category">

<field Field="cat_id" Type="int(10) unsigned" Null="NO" Key="PRI" Extra="auto_increment" Comment="" />

<field Field="cat_title" Type="varbinary(255)" Null="NO" Key="UNI" Extra="" Comment="" />

<field Field="cat_pages" Type="int(11)" Null="NO" Key="MUL" Default="0" Extra="" Comment="" />

<field Field="cat_subcats" Type="int(11)" Null="NO" Key="" Default="0" Extra="" Comment="" />

<field Field="cat_files" Type="int(11)" Null="NO" Key="" Default="0" Extra="" Comment="" />

<key Table="mw_category" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="cat_id" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_category" Non_unique="0" Key_name="cat_title" Seq_in_index="1" Column_name="cat_title" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<key Table="mw_category" Non_unique="1" Key_name="cat_pages" Seq_in_index="1" Column_name="cat_pages" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />

<options Name="mw_category" Engine="InnoDB" Version="10" Row_format="Compact" Rows="40" Avg_row_length="409" Data_length="16384" Max_data_length="0" Index_length="32768" Data_free="5242880" Auto_increment="41" Create_time="2014-09-13 02:23:19" Collation="binary" Create_options="" Comment="" />

</table_structure>

<table_data name="mw_category">

<row>

<field name="cat_id">1</field>

<field name="cat_title">Debian</field>

<field name="cat_pages">18</field>

<field name="cat_subcats">0</field>

<field name="cat_files">0</field>

importDump.php only accepts XML dumps generated from Special:Export or Manual:dumpBackup.php

Your XML dump seems to be a *database* dump, which is more low-level than MediaWiki's dumps. You should import it directly to the mysql/mariadb database, not with MediaWiki.

thanks @Ciencia Al Poder !

I just checked what script I used, it seems like it was dumpBackup.php indeed

I do have a second set of pure .sql files as well, those are indeed created by mysqldump (and those I am trying not to use due to old version)

php /usr/share/mediawiki/maintenance/dumpBackup.php --full --output=bzip2:wikixml-$(date '+%Y%m%d').tar.bz2

I was searching on Wikipedia when I notice the search autocomplete results on the site was broken. The results come back with completely random results that might not be related to what I am looking for. For example, typing in “Joe B” would list results of Carson Robinson instead of Joe Biden, and other nonsense. I would like to see this fixed asap

Hi Everyone,

I've been trying to set up templates on my wiki but every time I call for them on a page they just appear as a link. For example, I'd make a page called Welcome in the template namespace and write "Welcome to my Wiki!" and then put

Version:1.41 Php:8.2.18 MariaDB:10.6.16 Extensions (I think are important) are templatestyles, templatedata, templatewizard, cargo, lockdown, parserfunctions, scribunto, and visual editor.

When disabling templatestyles, templatedata, templatewizard, parserfunctions, and scribunto. The template function still doesn't work. I don't get any error messages either. I've also tried importing templates just in case I was setting them up wrong but that didn't work either.

Any input is appreciated.

UPDATE: I figured out how to make templates work on my wiki. My localsettings.php file had $wgNonincludableNamespaces = array(); defined to protect certain namespaces. For some reason, this caused all templates to not work. Trying to define $wgNonincludableNamespaces[NS_SPECIAL] = true; instead of using an array still causes templates to not work in the main namespace. Is this a bug in 1.41.0 or am I missing something?

$wgNonincludableNamespaces[NS_SPECIAL] = true; is incorrect syntax. See manual:$wgNonincludableNamespaces for information on how to use this setting.

Please also include the exact configuration settings you used in your post.

Hello, is there a moderation configuration that will block edits to be displayed to the public before the admin or the authorised personels approves after seeng that is worthy.

Thanks

Rgds

Davis Wanyonyi

Owner

Netvibe World

Extension:ApprovedRevs or extension:FlaggedRevisions

I solved it configuring apache2 mod security.

I am facing this issue in a new instalation. When i edit any page and ther is the @ character, the page shows a 403 error.

Example: root@debian:~

If i put a space before @ it works, like root @debian:~

Any secret i don't know?

Making more specific: when my page have root@debian it shows a 403 error. When i change to mark@debian, nathaniel@debian, anything@debian, it works fine.

What's about root@debian? Why it gives me a 403 error?

From web server error.log:

Apache-Error: [file "apache2_util.c"] [line 275] [level 3] [client 189.50.82.144] ModSecurity: Access denied with code 403 (phase 2). Pattern match "(?i:\\\\\\\\b(?:coalesce\\\\\\\\b|root\\\\\\\\@))" at ARGS:text. [file "/etc/apache/modsecurity.d/base_rules/modsecurity_crs_41_sql_injection_attacks.conf"] [line "140"] [id "950908"] [rev "2"] [msg "SQL Injection Attack."]

I can log on to my mediawiki site from all other devices, but when I try to logon from my Pixel 6a, it just keeps asking me to log on. I have even tried changing the password to test it , but still I can log on from the other devices but not the Pixel phone.

I have moved the database and files to a new server and have tried to get Media Wiki working.

I get a blank page with the error pasted below.

MediaWiki internal error.

Original exception: [905b5c01c455a15057df55c8] / 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 'app_13859.mwuf_l10n_cache' doesn't exist

Function: LCStoreDB::get

Query: SELECT lc_value FROM `mwuf_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1

Backtrace:

from /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1236)

#0 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1220): Wikimedia\Rdbms\Database->getQueryException()

#1 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1194): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()

#2 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(679): Wikimedia\Rdbms\Database->reportQueryError()

#3 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1383): Wikimedia\Rdbms\Database->query()

#4 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1334): Wikimedia\Rdbms\Database->select()

#5 /home/user_13859/app_13859/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->selectField()

#6 /home/user_13859/app_13859/includes/libs/rdbms/database/DBConnRef.php(338): Wikimedia\Rdbms\DBConnRef->__call()

#7 /home/user_13859/app_13859/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(726): Wikimedia\Rdbms\DBConnRef->selectField()

#8 /home/user_13859/app_13859/includes/language/LCStoreDB.php(65): Wikimedia\Rdbms\SelectQueryBuilder->fetchField()

#9 /home/user_13859/app_13859/includes/language/LocalisationCache.php(559): LCStoreDB->get()

#10 /home/user_13859/app_13859/includes/language/LocalisationCache.php(606): LocalisationCache->isExpired()

#11 /home/user_13859/app_13859/includes/language/LocalisationCache.php(516): LocalisationCache->initLanguage()

#12 /home/user_13859/app_13859/includes/language/LocalisationCache.php(396): LocalisationCache->loadSubitem()

#13 /home/user_13859/app_13859/includes/language/LocalisationCache.php(412): LocalisationCache->getSubitem()

#14 /home/user_13859/app_13859/includes/language/MessageCache.php(1235): LocalisationCache->getSubitemWithSource()

#15 /home/user_13859/app_13859/includes/language/MessageCache.php(1177): MessageCache->getMessageForLang()

#16 /home/user_13859/app_13859/includes/language/MessageCache.php(1075): MessageCache->getMessageFromFallbackChain()

#17 /home/user_13859/app_13859/includes/language/Message.php(1485): MessageCache->get()

#18 /home/user_13859/app_13859/includes/language/Message.php(972): Message->fetchMessage()

#19 /home/user_13859/app_13859/includes/language/Message.php(1059): Message->format()

#20 /home/user_13859/app_13859/includes/title/MalformedTitleException.php(61): Message->text()

#21 /home/user_13859/app_13859/includes/title/MediaWikiTitleCodec.php(101): MediaWiki\Title\MalformedTitleException->__construct()

#22 /home/user_13859/app_13859/includes/title/MediaWikiTitleCodec.php(411): MediaWiki\Title\MediaWikiTitleCodec::MediaWiki\Title\{closure}()

#23 /home/user_13859/app_13859/includes/title/Title.php(2756): MediaWiki\Title\MediaWikiTitleCodec->splitTitleString()

#24 /home/user_13859/app_13859/includes/title/Title.php(510): MediaWiki\Title\Title->secureAndSplit()

#25 /home/user_13859/app_13859/includes/MediaWiki.php(100): MediaWiki\Title\Title::newFromURL()

#26 /home/user_13859/app_13859/includes/MediaWiki.php(189): MediaWiki->parseTitle()

#27 /home/user_13859/app_13859/includes/MediaWiki.php(908): MediaWiki->getTitle()

#28 /home/user_13859/app_13859/includes/MediaWiki.php(613): MediaWiki->main()

#29 /home/user_13859/app_13859/index.php(50): MediaWiki->run()

#30 /home/user_13859/app_13859/index.php(46): wfIndexMain()

#31 {main}

Exception caught inside exception handler: [905b5c01c455a15057df55c8] / 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 'app_13859.mwuf_page' doesn't exist

Function: MessageCache::loadFromDB(en)-big

Query: SELECT page_title,page_latest FROM `mwuf_page` WHERE page_is_redirect = 0 AND page_namespace = 8 AND (page_title NOT LIKE '%/%' ESCAPE '`' ) AND (page_len > 10000)

Backtrace:

from /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1236)

#0 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1220): Wikimedia\Rdbms\Database->getQueryException()

#1 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1194): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()

#2 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(679): Wikimedia\Rdbms\Database->reportQueryError()

#3 /home/user_13859/app_13859/includes/libs/rdbms/database/Database.php(1383): Wikimedia\Rdbms\Database->query()

#4 /home/user_13859/app_13859/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select()

#5 /home/user_13859/app_13859/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call()

#6 /home/user_13859/app_13859/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(708): Wikimedia\Rdbms\DBConnRef->select()

#7 /home/user_13859/app_13859/includes/language/MessageCache.php(606): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()

#8 /home/user_13859/app_13859/includes/language/MessageCache.php(504): MessageCache->loadFromDB()

#9 /home/user_13859/app_13859/includes/language/MessageCache.php(421): MessageCache->loadFromDBWithMainLock()

#10 /home/user_13859/app_13859/includes/language/MessageCache.php(341): MessageCache->loadUnguarded()

#11 /home/user_13859/app_13859/includes/language/MessageCache.php(1301): MessageCache->load()

#12 /home/user_13859/app_13859/includes/language/MessageCache.php(1206): MessageCache->getMsgFromNamespace()

#13 /home/user_13859/app_13859/includes/language/MessageCache.php(1177): MessageCache->getMessageForLang()

#14 /home/user_13859/app_13859/includes/language/MessageCache.php(1075): MessageCache->getMessageFromFallbackChain()

#15 /home/user_13859/app_13859/includes/language/Message.php(1485): MessageCache->get()

#16 /home/user_13859/app_13859/includes/language/Message.php(972): Message->fetchMessage()

#17 /home/user_13859/app_13859/includes/language/Message.php(1059): Message->format()

#18 /home/user_13859/app_13859/includes/exception/MWExceptionRenderer.php(254): Message->text()

#19 /home/user_13859/app_13859/includes/exception/MWExceptionRenderer.php(191): MWExceptionRenderer::msg()

#20 /home/user_13859/app_13859/includes/exception/MWExceptionRenderer.php(105): MWExceptionRenderer::reportHTML()

#21 /home/user_13859/app_13859/includes/exception/MWExceptionHandler.php(134): MWExceptionRenderer::output()

#22 /home/user_13859/app_13859/includes/exception/MWExceptionHandler.php(251): MWExceptionHandler::report()

#23 /home/user_13859/app_13859/includes/MediaWiki.php(632): MWExceptionHandler::handleException()

#24 /home/user_13859/app_13859/index.php(50): MediaWiki->run()

#25 /home/user_13859/app_13859/index.php(46): wfIndexMain()

#26 {main}

OK, so it turned out that I didnt have the correct databse user asigned, that issuse is resolved.

Hello! Kindly help me customize the URL from 'mydomain.com/main_page' to 'mydomain.com' so that the home page does not redirect to 'main_page'. I would like to create a dashboard similar to Wikipedia on the home page. I have already used the code '$wgArticlePath = "/$1";' which helped customize the URLs, but the home page URL, which is supposed to be 'mydomain.com', is automatically redirecting to 'mydomain.com/main_page'. How can I modify the configuration to achieve the desired setup? Thank you!

See $wgMainPageIsDomainRoot

Hello, i kindly request you to help me protect some of my pages like home page and privacy policy to be only editable by admins only. i used this code

$wgNamespaceProtection[NS_MAIN] = ['sysop'];

$wgGroupPermissions['sysop']['edit'] = false;

in my local setting php and it locked me for editing anything that is already in the site.

this code does not work either

$wgFlaggedRevsProtection = array('sysop' => true);

kindly help.

Rgds

Davis Wanyonyi

You'll want to look at Help:Protecting and unprotecting pages

Thank You!!!!