Open main menu

Project:Support desk

About this board

Welcome to MediaWiki.org's Support desk, where you can ask MediaWiki questions!

There are also other places where to ask :

Before you post

Post a new question

  1. To help us answer your questions, please always indicate which versions you are using (reported by your wiki's Special:Version page):
    • MediaWiki
    • PHP
    • Database
  2. Please include the URL of your wiki unless you absolutely can't. It's often a lot easier for us to identify the source of the problem if we can look for ourselves.
  3. To start a new thread, click "Start a new topic".
Previous page history was archived for backup purposes at Project:Support_desk/old on 2015-07-30.
Other languages: English  العربية čeština Esperanto français 日本語 中文

Forgot to backup a database before an update, now getting errors. Anything I can do?

3
Jordan DeHart (talkcontribs)

Hello!

I've been running a wiki install for about two years now and I haven't backed it up at all in those years. What I "thought" was backing it up was not, and now I'm paying the consequences of my actions. I upgraded from 1.29 to 1.31.1 and I've been getting this error whenever I tried upgrading or downgrading.

Error: 1091 Can't DROP 'ct_rc_id'; check that column/key exists (localhost)


All the solutions I found referenced using backups to fix the problem, which I cannot do. Is there anything else I can do to solve this issue? if not, I've been thinking about exporting all of my pages, making a clean install and importing the .xml file and re-uploading images manually

Edit: Not really a tech guy so I'm a bit out of my element, but if I need to post some more technical information, let me know.

Version: 7.1.14

PHP: 7.1.14

MySQL: 5.6.41-84.1

ICU: 4.2.1

LUA: 5.1.5

Ciencia Al Poder (talkcontribs)

This is apparently the same problem as Topic:Ukol0fkinjvqe5a7.

Since it's trying to run a script, that attempts to do several changes, if one of them fails the entire update fails.

The file it's trying to run is patch-change_tag-indexes.sql.

As a workaround, you can try to edit the patch-change_tag-indexes.sql file and remove the first sentence and execute the upgrade script again. If it fails on the next one, delete it and do that over and over again until the file is empty and the upgrade script continues.

Note that you can't downgrade MediaWiki once you've (started) upgraded the database with the update.php script!

Jordan DeHart (talkcontribs)

Thanks for the reply! Your method worked like a charm, thanks!

I saw that thread beforehand, but even though the error message was the same, our problems were different. I think at least, since I was able to save and create pages just fine.

Thanks again for your help. I appreciate it.

Reply to "Forgot to backup a database before an update, now getting errors. Anything I can do?"

MWException from line 357 - ***/includes/resourceloader/ResourceLoader.php: ResourceLoader module info type error for module '0': expected ResourceLoaderModule or array (got: NULL)

1
96.250.0.88 (talkcontribs)

Hey guys,


I just spent the day trying to upgrade my mediawiki from 1.27 to 1.32, and after a ton of troubleshooting I'm now stuck. I had to upgrade my server to use PHP 7.2, force my ssh to do likewise by calling the binary files because it was stuck using version 4.something, but it seems like the server itself is using the right PHP version, although when I try to load mydomain.com/mw-config/index.php it doesn't seem to have any styling or functionality, almost as if the php isn't working properly, and when I try to load most of the main pages I get this error:


MediaWiki internal error.

Original exception: [XOSbF0rQO3cAANkY4XkAAAAI] /Main_Page MWException from line 357 of /homepages/24/d******/htdocs/mymainwikiwiki/includes/resourceloader/ResourceLoader.php: ResourceLoader module info type error for module '0': expected ResourceLoaderModule or array (got: NULL)

Backtrace:

#0 /homepages/24/d******/htdocs/mymainwikiwiki/includes/resourceloader/ResourceLoader.php(260): ResourceLoader->register(integer)

#1 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3271): ResourceLoader->__construct(GlobalVarConfig, MediaWiki\Logger\LegacyLogger)

#2 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3052): OutputPage->getResourceLoader()

#3 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3096): OutputPage->getRlClientContext()

#4 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3318): OutputPage->getRlClient()

#5 /homepages/24/d******/htdocs/mymainwikiwiki/includes/skins/Skin.php(681): OutputPage->getBottomScripts()

#6 /homepages/24/d******/htdocs/mymainwikiwiki/includes/skins/SkinTemplate.php(469): Skin->bottomScripts()

#7 /homepages/24/d******/htdocs/mymainwikiwiki/includes/skins/SkinTemplate.php(225): SkinTemplate->prepareQuickTemplate()

#8 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(2706): SkinTemplate->outputPage()

#9 /homepages/24/d******/htdocs/mymainwikiwiki/includes/MediaWiki.php(867): OutputPage->output(boolean)

#10 /homepages/24/d******/htdocs/mymainwikiwiki/includes/MediaWiki.php(879): MediaWiki->{closure}()

#11 /homepages/24/d******/htdocs/mymainwikiwiki/includes/MediaWiki.php(517): MediaWiki->main()

#12 /homepages/24/d******/htdocs/mymainwikiwiki/index.php(42): MediaWiki->run()

#13 {main}

Exception caught inside exception handler: [XOSbF0rQO3cAANkY4XkAAAAI] /Main_Page MWException from line 357 of /homepages/24/d******/htdocs/mymainwikiwiki/includes/resourceloader/ResourceLoader.php: ResourceLoader module info type error for module '0': expected ResourceLoaderModule or array (got: NULL)

Backtrace:

#0 /homepages/24/d******/htdocs/mymainwikiwiki/includes/resourceloader/ResourceLoader.php(260): ResourceLoader->register(integer)

#1 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3271): ResourceLoader->__construct(GlobalVarConfig, MediaWiki\Logger\LegacyLogger)

#2 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3052): OutputPage->getResourceLoader()

#3 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3096): OutputPage->getRlClientContext()

#4 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(3318): OutputPage->getRlClient()

#5 /homepages/24/d******/htdocs/mymainwikiwiki/includes/skins/Skin.php(681): OutputPage->getBottomScripts()

#6 /homepages/24/d******/htdocs/mymainwikiwiki/includes/skins/SkinTemplate.php(469): Skin->bottomScripts()

#7 /homepages/24/d******/htdocs/mymainwikiwiki/includes/skins/SkinTemplate.php(225): SkinTemplate->prepareQuickTemplate()

#8 /homepages/24/d******/htdocs/mymainwikiwiki/includes/OutputPage.php(2706): SkinTemplate->outputPage()

#9 /homepages/24/d******/htdocs/mymainwikiwiki/includes/exception/MWException.php(181): OutputPage->output()

#10 /homepages/24/d******/htdocs/mymainwikiwiki/includes/exception/MWException.php(222): MWException->reportHTML()

#11 /homepages/24/d******/htdocs/mymainwikiwiki/includes/exception/MWExceptionHandler.php(96): MWException->report()

#12 /homepages/24/d******/htdocs/mymainwikiwiki/includes/exception/MWExceptionHandler.php(172): MWExceptionHandler::report(MWException)

#13 /homepages/24/d******/htdocs/mymainwikiwiki/includes/MediaWiki.php(544): MWExceptionHandler::handleException(MWException)

#14 /homepages/24/d******/htdocs/mymainwikiwiki/index.php(42): MediaWiki->run()

#15 {main}


I've tried disabling all extensions and skins in my localsettings.php but that doesn't seem to help anything. I'm at a bit of a loss for what to do next- any help would be appreciated!

Reply to "MWException from line 357 - ***/includes/resourceloader/ResourceLoader.php: ResourceLoader module info type error for module '0': expected ResourceLoaderModule or array (got: NULL)"

[RESOLVED] Cannot input UTF-8 characters (Japanese) when editing wiki pages

2
Genesishana (talkcontribs)

I have a fresh installation of MediaWiki 1.24.2 and I have difficulties inputting Japanese characters (and probably UTF-8 characters in general). When I am editing a wiki page using the editor, I start typing some Japanese characters and then click 'Save Page'. But then the characters become "???" after the edited page loads. Attempting to edit the page again shows the same "???" kind of characters.

I initially suspected it had something to do with how my database was configured since some of the character_set variables were set to 'latin1' but I have modified my database's /etc/my.cnf.d/server.cnf file to use utf8 (as shown below).

Default charset of httpd and php are set to utf8 as well.

Just now, I setup the VisualEditor (and parsoid service) and it seems I can input Japanese characters just fine within the VisualEditor and after saving, the wiki page looks fine. When I edit using the WikiEditor, the wiki page has the same garbled text after saving. I've also noticed when using the VisualEditor, I can create a link to a new page whose title consists of Japanese characters but when I proceed to actually create the new page, I get garbled text using the WikiEditor and when trying the VisualEditor, I get a bad title error.

What could be the problem with my MediaWiki's configuration? Any input is greatly appreciated.

Update: I've also realized when using the 'edit source' tab, I can correctly preview utf-8 edits using the 'preview tab' and the 'changes tab' without a problem. The encoding problem seems to occur only after I saved the page. In the VisualEditor case, I can successfully save page and it will reload correctly. However, pages whose titles are utf-8 based behave strangely, for example: I create a link to a new wiki page using utf-8 characters, then I click its red link to create its content. For some reason, utf-8 based content won't save but ASCII characters do. Also, it feels like it made two versions of the page, one with the correct utf-8 title, and then another with a broken title.

Solved: I did a complete re-installation of the LAMP stack on the server, taking extra care that utf-8 is the default charset everywhere during configuration. I also upgraded PHP to 5.6.7 and MariaDB to 10.0.17. Now MediaWiki behaves well with UTF-8 characters in both titles and content of pages.

Environment Specifications

  • MediaWiki 1.24.2
  • PHP 5.4.16 (apache2handler)
  • MariaDB 5.5.42-MariaDB-wsrep
  • CentOS Linux release 7.1.1503 (Core)


mysql> show variables like "collation%";
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
mysql> show variables like "char%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
2401:4900:1908:9404:1034:59E5:BB04:CBE5 (talkcontribs)

How to change the values of variables permanently ?

Reply to "[RESOLVED] Cannot input UTF-8 characters (Japanese) when editing wiki pages"

Fatal exception of type "Error" on preview

4
Matt-at-Penman (talkcontribs)

Hello, we've just migrated the data from an old version of Mediawiki / an unsupported OS platform to MediaWIki 1.32.0 / running on PHP 7.0 on Ubuntu 16.04. The migrate was done by building a new platform, copying the SQL data (and image files) from the old system and making minimum necessary changes to the new plarform's configuration file. The data import worked fine, migration script (php /usr/share/mediawiki/maintenance/update.php) completed without error, wiki 'mostly' works. The only error is as in the subject when attempting to preview a change (or actually, preview itself, you don't need to change anything, just ask for a preview). These fail with message of the form:

[04f796e3b179a4cdf7946122] 2019-05-20 15:11:35: Fatal exception of type "Error"

with a different number in the square brackets and time stamp.

The web server (nginx 1.16.0) records error messages of the form below, one error message for each attempt to preview:

2019/05/20 15:24:06 [error] 18426#18426: *8136 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined property: CKeditorEditPage::$isCssJsSubpage in /usr/share/mediawiki/extensions/WYSIWYG-src/WYSIWYG/CKeditorEditPage.body.php on line 35" while reading response header from upstream, client: [redacted], server: [redacted].com, request: "POST /index.php?title=Category:Sysadmin&action=submit HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "[redacted].com", referrer: "https://[redacted].com/index.php?title=Category:Sysadmin&action=edit"

where I've removed the external address of the site and the server name and replaced then with [redacted] instead.

Saving changes *without* preview works fine, the saved pages are rendered correctly. WIth preview it consistently fails with the error message.

Malyacko (talkcontribs)
Matt-at-Penman (talkcontribs)

Thank you for that, yes, does look like the issue is in WYSIWYG. Below is what is output on the GUI once the debug and stack trace are turned on and I try to preview a page.


[5f734fc7e51814e99dbbd919] /index.php?title=Category:Sysadmin&action=submit Error from line 36 of /usr/share/mediawiki/extensions/WYSIWYG-src/WYSIWYG/CKeditorEditPage.body.php: Call to undefined function wfRunHooks()

Backtrace:

#0 /usr/share/mediawiki/includes/EditPage.php(2749): CKeditorEditPage->getPreviewText()

#1 /usr/share/mediawiki/includes/EditPage.php(702): EditPage->showEditForm()

#2 /usr/share/mediawiki/extensions/WYSIWYG-src/WYSIWYG/CKeditor.body.php(303): EditPage->edit()

#3 /usr/share/mediawiki/includes/Hooks.php(174): CKeditor_MediaWiki->onCustomEditor(CategoryPage, User)

#4 /usr/share/mediawiki/includes/Hooks.php(202): Hooks::callHook(string, array, array, NULL)

#5 /usr/share/mediawiki/includes/actions/EditAction.php(57): Hooks::run(string, array)

#6 /usr/share/mediawiki/includes/actions/SubmitAction.php(38): EditAction->show()

#7 /usr/share/mediawiki/includes/MediaWiki.php(501): SubmitAction->show()

#8 /usr/share/mediawiki/includes/MediaWiki.php(294): MediaWiki->performAction(CategoryPage, Title)

#9 /usr/share/mediawiki/includes/MediaWiki.php(860): MediaWiki->performRequest()

#10 /usr/share/mediawiki/includes/MediaWiki.php(517): MediaWiki->main()

#11 /usr/share/mediawiki/index.php(42): MediaWiki->run()

#12 {main}

Matt-at-Penman (talkcontribs)

Interesting, it looks like wfRunHooks is a deprecated function as of the version this system was built with but is still being called by WYSIWYG... the file identified in the stack trace above at line 36 has

"wfRunHooks( 'EditPageBeforePreviewText', array( &$this, $this->previewOnOpen() ) );

so it appears not to be compatible with the latest MediaWiki version. It's also got at least one other occurrence of wfRunHooks in it.


And testing... it appears that by replacing wfRunHooks at lines 36 and 38 in the referenced file by Hooks::run the issue is resolved... previews work again. Probably would benefit from being fitted into WYSIWYG code...

Reply to "Fatal exception of type "Error" on preview"
2A02:AB04:53F:2F00:5193:810A:1203:59F (talkcontribs)

I have redirected from http to https, and has stopped working url without https://www, discussing and redirecting.

When I enter redirect - https://www.example.com ... it's okay, but when I enter www.example.com or example.com, it writes an error - Invalid title - The requested page title contains invalid characters: "%C3".

This is just the case for side pages (e.g. - discussion, redirect, history ...)

Will anyone advise me? Where is the problem?

My htaccess

RewriteEngine On

RewriteCond %{HTTPS} off

RewriteRule (.*) https://www.example.com%{REQUEST_URI} [L,R=301,QSA]

RewriteRule ^/?wiki(/.*)?$ %{DOCUMENT_ROOT}/index.php [L]

RewriteCond %{DOCUMENT_ROOT}%{REQUEST_URI} !-f

RewriteCond %{DOCUMENT_ROOT}%{REQUEST_URI} !-d

RewriteRule ^/?images/thumb/[0-9a-f]/[0-9a-f][0-9a-f]/([^/]+)/([0-9]+)px-.*$ %{DOCUMENT_ROOT}/thumb.php?f=$1&width=$2 [L,QSA,B]

RewriteCond %{DOCUMENT_ROOT}%{REQUEST_URI} !-f

RewriteCond %{DOCUMENT_ROOT}%{REQUEST_URI} !-d

RewriteRule ^/?images/thumb/archive/[0-9a-f]/[0-9a-f][0-9a-f]/([^/]+)/([0-9]+)px-.*$ %{DOCUMENT_ROOT}/thumb.php?f=$1&width=$2&archived=1 [L,QSA,B]

My LocalSettings:

$wgScriptPath = "";

$wgScriptExtension = ".php";

$wgArticlePath = "/wiki/$1";

$wgUsePathInfo = true;

## The protocol and server name to use in fully-qualified URLs

$wgServer = "https://www.example.com";

## The URL path to static resources (images, scripts, etc.)

$wgResourceBasePath = $wgScriptPath;
星耀晨曦 (talkcontribs)
2A02:AB04:53F:2F00:D9E9:CD68:CF94:C7AD (talkcontribs)

Thank you, but it still does not work, it does it only for special characters (eg, š, č, –...) and only in discussion and redirect. e.g. instead of hyphen (–) I have %25E2%2580%2593 in url. Only when I enter url without https.

Sorry for my english.


Reply to "Invalid title"

how use ttf font in media wiki ?

1
Hamid227 (talkcontribs)

i need a font that is not in google font api but i have ttf file of it. what to do?

Reply to "how use ttf font in media wiki ?"

Showing a complete table of contents (categories and pages)

1
Grmblfx5 (talkcontribs)

Hello,

on my wiki pages, I used the extension "NiceCategoryList2" to get a complete TOC on my starting page, as you can see here:

http://www.psych-med.de/wiki/index.php?title=Hauptseite

Unfortunately, the extension isn't maintained anymore, so I need an alternative after updating.

I tried "categorytree" and "DynamicPageList3" but wasn't able to get the same result (categories as headings, subpages as links).

For "DynamicPageList3" I studied the manual but didn't find a support page or forum to ask.


Can anyone tell me if or how I can get a complete table of contents on a wiki-page?


Thank you!

Reply to "Showing a complete table of contents (categories and pages)"

UploadStashFileException when uploading image in Visual Editor

1
Czech.Fox (talkcontribs)

Hello, after update to MW 1.32.1 (Windows Server 2008 R2, PHP 7.1.14, MariaDB 5.5.5-10.3.14) it is not possible to upload image through interface of Visual Editor. The dialog returns a strange error after click "Upload".


Could not store upload in the stash (UploadStashFileException): "Could not store file "D:\Wiki\Dev/App_Data/temp/chunkedupload_cb59cde85454" at "mwstore://local-backend/local-temp/2/29/20190520131613!chunkedupload_cb59cde85454.".".


However, it is possible to upload file through Special:Upload page.

Any idea ?

Thank you

Reply to "UploadStashFileException when uploading image in Visual Editor"

<div> and <span> tags around headers remove their collapsibility on the mobile skin

5
Jaywye (talkcontribs)

Is there a way around this? An example can be seen here.

I ran into this issue while attempting to create a mobile version of a page with different elements shown on desktop and mobile with the nodesktop and nomobile classes. I wanted to separate different sections with collapsed headers on mobile so that readers could expand whichever section they wanted to read, but found that the headers were not collapsible anymore.

This post was hidden by AhmadF.Cheema (history)
Jaywye (talkcontribs)

Thank you for your reply. Is there a reason why a collapsible mobile heading becomes uncollapsible when surrounded by <div>, <span>, or any other tags/attributes? https://i.imgur.com/vtznslm.png

AhmadF.Cheema (talkcontribs)

Probably a bug.

TheDJ (talkcontribs)

Such things break the section detection. (A header creates an 'implied' section, but if you start wrapping things, the implied sections no longer work and you are left with just the headings).

Reply to "<div> and <span> tags around headers remove their collapsibility on the mobile skin"
2001:4C4E:2504:9400:45DA:8D6C:784D:17D1 (talkcontribs)

Dear Wikipedia support, some years ago I was a Wikipedia editor of the Hungarian edition. I remember my user name, but changed email address several times, and I also do not remember my password.

How can I recover my user name?

TheDJ (talkcontribs)

Not in that case. Best is to create a new account.

Reply to "Forgotten email and password"