Project:Support desk

Jump to: navigation, search

About this board

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

There are also other places where to askCommunication: IRCCommunication#Chat, mailing listsMailing lists, Q&A etc.

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".
By clicking "Add topic", you agree to our Terms of Use and agree to irrevocably release your text under the CC BY-SA 3.0 License and GFDL
Bty0808 (talkcontribs)

Users inserted into groups created by extensions, lose the privilege after logging in. Any idea of ​​what might be happening? MW1.27.

Reply to "User groups resetting after relogin"

Controlling how blank values are displayed in a template

SFLord (talkcontribs)

Mediawiki Version: 1.31.0-wmf.4 (477691b)

PHP: any


A template is used in the Kabiye wiki called Ɛyaa sɔsaa which is the Kabiye Famous Persons' template. The address of the template is and the wiki address is

The signature of a famous person should only be shown if such (a signature) exists. At present, a contributor can enter a file name for a signature, but if this value is left blank, the message [[File:|190px]] is displayed which is unsatisfactory... This is the final value that is entered.

All text on the wiki is in the Kabiye language, with the exception of some French and English words, so for example the title of the Ɛyaa sɔsaa template is Modèle:Ɛyaa sɔsaa - a mixture of French & Kabiye. The Wiki went live - (came out of the incubator) about 2 months ago.

We would value any help as to how to change the template so as to only display a signature if one has been supplied. My best guess would be that some conditional statement needs to be included in the [[File: statement and have searched the existing help entries - but with no joy...

Any suggestions would be greatly valued.

I am using a Windows 7 PC and Google Chrome Version 61.0.3163.100 to update the Kabiye wikipedia.

Reply to "Controlling how blank values are displayed in a template"
Alex cmx (talkcontribs)

How can i configure the database to escape this error: 1267 Illegal mix of collations: utf8 vs cp1251?

I wanted to use cirillic symbols on the wiki.

So, when i create internal link beginnig with the letter "И" or 'и', error raises =>

[ec79bc2b15920b64df7b2aeb] /index.php?title=%D0%A1%D1%81%D1%8B%D0%BB%D0%BA%D0%B8&action=submit Wikimedia\Rdbms\DBQueryError from line 1075 of /home/htasu/ A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?  

Query: SELECT page_id,page_len,page_is_redirect,page_latest,page_content_model,page_namespace,page_title FROM `page` WHERE (page_namespace = '0' AND page_title = 'Интернет') 

Function: LinkHolderArray::replaceInternal

Error: 1267 Illegal mix of collations (utf8_bin,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '=' (htasu.mysql)


#0 /home/htasu/ Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#1 /home/htasu/ Wikimedia\Rdbms\Database->query(string, string)

#2 /home/htasu/ Wikimedia\Rdbms\Database->select(string, array, string, string)

#3 /home/htasu/ LinkHolderArray->replaceInternal(string)

#4 /home/htasu/ LinkHolderArray->replace(string)

#5 /home/htasu/ Parser->replaceLinkHolders(string)

#6 /home/htasu/ Parser->internalParseHalfParsed(string, boolean, boolean)

#7 /home/htasu/ Parser->parse(string, Title, ParserOptions, boolean, boolean, NULL)

#8 /home/htasu/ WikitextContent->fillParserOutput(Title, NULL, ParserOptions, boolean, ParserOutput)

#9 /home/htasu/ AbstractContent->getParserOutput(Title, NULL, ParserOptions)

#10 /home/htasu/ WikiPage->prepareContentForEdit(WikitextContent)

#11 /home/htasu/ SpamBlacklistHooks::filterMergedContent(RequestContext, WikitextContent, Status, string, User, boolean)

#12 /home/htasu/ Hooks::run(string, array)

#13 /home/htasu/ EditPage->runPostMergeFilters(WikitextContent, Status, User)

#14 /home/htasu/ EditPage->internalAttemptSave(NULL, boolean)

#15 /home/htasu/ EditPage->attemptSave(NULL)

#16 /home/htasu/ EditPage->edit()

#17 /home/htasu/ EditAction->show()

#18 /home/htasu/ SubmitAction->show()

#19 /home/htasu/ MediaWiki->performAction(Article, Title)

#20 /home/htasu/ MediaWiki->performRequest()

#21 /home/htasu/ MediaWiki->main()

#22 /home/htasu/ MediaWiki->run()

#23 {main}
MarkAHershberger (talkcontribs)

Could you give the results of "show create table page" from your database? It would also help to know your MediaWiki version, MySQL version and PHP version.

Alex cmx (talkcontribs)

php version is 5.6.6

mediawiki is 1.29.1

mySQL is mysqlnd 5.0.11

MarkAHershberger (talkcontribs)

Is this a fresh install or did you upgrade from another version? It looks like your MySQL is pretty old and should be upgraded, too.

Alex cmx (talkcontribs)

it's fresh install. I've just started experimenting in web, so i don't understand many things...

MarkAHershberger (talkcontribs)

Is this on shared hosting? Do you have access to phpMyAdmin or something similar?

Alex cmx (talkcontribs)

sorry, mysql version is 5.7.17, and yes i have access to phpMyAdmin

This comment was hidden by 2003:CC:ABCA:4500:14DA:EB6A:80B5:3D6E (history)
2003:CC:ABCA:4500:6C82:D7A8:4772:450D (talkcontribs)

Which tables and columns are using cp1251 as a collation? I think these tables and columns are problematic.

Is there only the new MediaWiki installation inside that database? Or is there also something else in it and you may be using both systems together? If it is only this new wiki, I would empty the database, then make sure the collation for new tables is utf8_general_ci and then let MediaWiki install its things into the database again.

However, I am still unsure, for why the tables had not been created with fitting collations right away. I think the installer should offer utf8 and binary only, not cp1251. utf8 and binary both are ok, but a mix with cp1251 should not be there.

Patricio josé (talkcontribs)

Não sei

Reply to "Configure"
Korg (talkcontribs)


Is there a way to translate a page on the fly? I know there is the Translate extension, but what I'm looking for is a solution without having to set each translatable page manually. The text to translate would be words and short phrases, not prose.

I have in mind the selectors that can be found at the top of the pages on zhwiki, hiwiki and hywiki. What is the name of these extensions/features?

Thank you in advance.

Malyacko (talkcontribs)

Do you mean Extension:ContentTranslation ?

Korg (talkcontribs)

Can the ContentTranslation extension be used to translate and directly display translated text of content pages, without any particular intervention?

I will try to be more explicit. Suppose there is the heading "References" in thousands of pages. If the user changes the display language via the Universal Language Selector, e.g. in Hungarian, the heading would be automatically translated as "Források".

There is a solution with the {{int:x}} magic word, but I would be interested in a simpler approach.

Ciencia Al Poder (talkcontribs)

The selectors at the top of such pages are because those are language variants, not different languages, and MediaWiki can perform the translation internally. See Writing systems#LanguageConverter

Korg (talkcontribs)

Thank you for the link!

Korg (talkcontribs)

Sorry, the topic is not resolved. Perhaps I have not been clear enough.

I would like to find a way to automatically translate words and short phrases in content pages.

Currently it can be done with the help of templates, the {{int:}} magic word, or a call to Wikidata, but somehow it could be cumbersome if there are thousands of pages involved, and not really easy for new users.

Perhaps this request is beyond the scope of the Support desk, and I should open a request elsewhere?

AhmadF.Cheema (talkcontribs)

Maybe you can try bulk find and replace?

For example, find all instances of "short phrase" on the Wiki and simultaneously replace all of them with something like "{{int:short phrase}}".

Korg (talkcontribs)

Thanks for the suggestion! But I think I would avoid the use of the {{int:}} magic word.

As new pages would be created, this magic word would have to be automatically added (Ok, this could be done by a bot).

Also, it seems that this magic word was intended for interface messages, so only administrators could create or update such messages (but perhaps it could be used with messages outside the MediaWiki namespace?).

Reply to "Translation on the fly?"
Aschroet (talkcontribs)

Hi, when receiving mails from MW (e. g. when a watched page has been changed) i get only plain text mails. On installations of MW at WP, Commons, or here those mails contain clickable links. Is there an easy way to enable this feature or do i need to adapt the code for that? How is that done on WP or Commons?

Reply to "HTML emails from mediawiki"
Klaus1337 (talkcontribs)

Hello guys,

I want our IT to setup a wiki but they need to know if the mediawiki software is compatible to the existing infrastructure.

Since we could not answer every point throught by reading the tech manuals and FAQ I hope you can help me.

Is MediaWiki compatible to:

Microsoft SQL Server 2014, englisch, Databases in High Availibility Groups, no seperate instance, authentification at database level with domain accounts.

Thank you in advance!

Malyacko (talkcontribs)

See Manual:Microsoft SQL Server; Manual:Language; no idea what "High Availability Groups" are; no separate instance of what?; there is authentication for example with ActiveDirectory and with SAML-based authentication, see for example PluggableAuth.

Ciencia Al Poder (talkcontribs)

SQL Server support on MediaWiki is very poor, I suggest you to use mysql instead

Reply to "SQL-Server Compatibility"
Liz.li70 (talkcontribs)

we are using wikipedia API (GeoData) now, but we can not search by category, do we support to search by category ? if we can, can you send me an example?

Liz.li70 (talkcontribs)

what we are doing is getting article from wiki, but we want to get article that belong to a specific category, can anyone help on this?

This comment was hidden by Liz.li70 (history)
Reply to "search in wikipedia"

Search box spins and then returns "No match was found"

Txantimedia (talkcontribs)

Suddenly my search box stopped working. Previously, it would return previews of all matches. Now, no matter what you type, it displays a spinning wheel and then returns "No match was found"

Thinking I would fix the problem, I went to the trouble of installing the Extension:SphinxSearch, which requires also installing and configuring Sphinx. The search now returns all sorts of stuff, but I still get the No match was found and spinning wheel, making it appear that the search isn't working.

What do I look for to resolve this problem? I'm not seeing any errors in the console.


OS: FreeBSD 10.3

MediaWiki 1.29.1, PHP 7.1.10, MySQL 5.6.37

MarkAHershberger (talkcontribs)

I tried searching for "vietnam" on your site and saw the spinning wheel as you mention. If you want to try and figure this out you will probably need to use the debug log. I'm afraid I don't have any ready answers, though.

Txantimedia (talkcontribs)

The Wikibase extension was causing it. I've disabled it for now, while I figure out why.

Reply to "Search box spins and then returns "No match was found""

Is there a way to display global variables from wikitext?

Marc Kupper (talkcontribs)

I wanted to update some documentation on Wikipedia and as part of that wanted to include the $wgEchoMaxMentionsCount value. I suspect I could get it from a user defined JavaScript function but want the value to be available to everyone looking at the article. Is there something I can put in standard wikitext to display the global variable's value?

For example, the value is hardcoded on wikipedia:Wikipedia:Notifications#Spamming as "50". I'd rather replace that with something that shows the $wgEchoMaxMentionsCount variable's value as it may not be set to 50 on all sites. shows where this variable gets set and used.

MarkAHershberger (talkcontribs)

There is no way to display an arbitrary variable such as this in standard wiki text.

Reply to "Is there a way to display global variables from wikitext?"

Create user group that can read articles, and post to all user talk pages, but nothing else?

Banaticus (talkcontribs)

I'd like to create a "noob" user group that can read articles, post to all user talk pages, but can't post anywhere else or edit any articles. Is that possible?

Edit: Manual:$wgNamespaceProtection does what I'm looking for.

Reply to "Create user group that can read articles, and post to all user talk pages, but nothing else?"