Project:Support desk

Jump to navigation Jump to search

About this board

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

There are also other places where to askCommunication: IRCCommunication#Chat, mailing listsMailing lists, Wikimedia Developer Support, Q&A, mwusers (unofficial forum) 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".

Math extension cause a fatal exception of type "Wikimedia\Rdbms\DBQueryError"

7
Gdwikimeca (talkcontribs)

Hello,

I have install the math extension but when i try to add a <math> balise in a page, i have this screen :

___________________________________________________________________________

MediaWiki internal error.

Original exception: [W-I969TjGCIAAAU3aBUAAAAe] 2018-11-19 04:37:00: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Exception caught inside exception handler.

Set $wgShowExceptionDetails = true; and $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php to show detailed debugging information.

___________________________________________________________________________

When i try to add $wgShowExceptionDetails = true and $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php, i have a blank page at the same place.

What ca i do ?

URL of my wiki : www.wikimeca.org/wikimeca_1_31/

Here is my installation specifications :

2 Logiciels installés

Produit Version
MediaWiki 1.31.1
PHP 7.2.11 (cgi-fcgi)
MySQL 5.5.60-0+deb7u1-log
ICU 52.1

3 URL des points d'entrée

Point d'entrée URL
Chemin d’article /wikimeca_1_31/index.php?title=$1
Chemin de script /wikimeca_1_31
index.php /wikimeca_1_31/index.php
api.php /wikimeca_1_31/api.php
load.php /wikimeca_1_31/load.php

Habillages installés

Habillage Version Licence Description Auteurs
Monobook GPL-2.0-or-later L’habillage classique de MediaWiki depuis 2004, nommé d’après la photo en noir et blanc d’un livre dans l’arrière-plan de la page Gabriel Wicke et autres
Timeless 0.8.1 GPL-2.0-or-later Un habillage intemporel conçu d’après le prototype Winter par Brandon Harris, et divers styles de la Fondation Wikimédia Isarra Yos
Vector GPL-2.0-or-later Version moderne de MonoBook avec un aspect rajeuni et beaucoup d’améliorations ergonomiques Trevor Parscal, Roan Kattouw et autres

Extensions installées

Greffons de l'analyseur syntaxique
Extension Version Licence Description Auteurs
Math 3.0.0 (a1263db)17 avril 2018 à 00:54 GPL-2.0-or-later Restitue les formules mathématiques entre les balises <math> ... </math> Tomasz Wegrzanowski, Brion Vibber, Moritz Schubotz et Derk-Jan Hartman
星耀晨曦 (talkcontribs)

Add

$wgShowExceptionDetails = true;
$wgShowDBErrorBacktrace = true;

You missing ; at the line end.

Gdwikimeca (talkcontribs)

Thanks but i don't think so. Here is the end of my localsettings.php file :

# Add more configuration options below.

$wgShowExceptionDetails = true;

$wgShowDBErrorBacktrace = true;

$wgShowSQLErrors = true;

And i style have a blank page...

星耀晨曦 (talkcontribs)

May also add

error_reporting( -1 );
ini_set( 'display_errors', 1 );
Ciencia Al Poder (talkcontribs)

If you see a blank page, adding the above won't work. You introduced a syntax error somehow when you edited the LocalSettings.php file. Try commenting-out all modified lines to find what's the problem, or look at the webserver error logs.

Gdwikimeca (talkcontribs)

Thanks for this posts.

My LocalSettings.php file is almost the original one generated during installation. I just add the lines below.

I try to creat a errorlog file by adding :

$wgDebugLogFile = "$wgScriptPath/errorlog.txt";

but the file is empty.

I add the lines :

error_reporting( -1 );
ini_set( 'display_errors', 1 );

too, but nothing new.

星耀晨曦 (talkcontribs)

You can check the web server error log.

Reply to "Math extension cause a fatal exception of type "Wikimedia\Rdbms\DBQueryError""

Cannot access the database: Server sent charset unknown to the client. Please, report to the developers (localhost)

5
86.17.13.109 (talkcontribs)

Im trying to install 1.31.0 on MySQL 8.0.12 and im receiving the error 'Cannot access the database: Server sent charset unknown to the client. Please, report to the developers (localhost)' when running through the Wiki Installation, can anyone help?

86.17.13.109 (talkcontribs)

I assume this error indicates it is actually connecting to the database? and that the issue is something else?

86.17.13.109 (talkcontribs)

I believe I have fixed this error by adding:

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

into my.ini (im running windows)

But now I get error: The server requested authentication method unknown to the client (localhost)

IkonAlex (talkcontribs)

Hey, I have the same error (The server requested authentication method unknown), could you resolve the issue?

Ciencia Al Poder (talkcontribs)

You can try googling "The server requested authentication method unknown", it gives some information about the error and how to fix that.

Reply to "Cannot access the database: Server sent charset unknown to the client. Please, report to the developers (localhost)"

Make mobile website forward to the regular website in case of non-mobile access

3
2A02:ED0:3371:DC00:69B6:D321:A32C:5016 (talkcontribs)

For instance, make he.m.wikipedia.com/somthing automatically forward to he.wikipedia.com/somthing in case I access from my desktop.

Malyacko (talkcontribs)
2A02:ED0:3371:DC00:69B6:D321:A32C:5016 (talkcontribs)

The regular wikipedia looks better on a desktop then the mobile site.

And you can see the browser and the system in the user-agent I send in each page request.

Reply to "Make mobile website forward to the regular website in case of non-mobile access"
The-Psychid (talkcontribs)

I'm still customizing my wiki by modifying its CSS page. While I was experimenting it, I saw that I've found a way to make the "More" displayed in the font I want to customize with, and in uppercase. I actually want to see if I want to apply that for the other tabs in the navigational section, but I'm having trouble with it, even as I'm using Ctrl+Shift+C in Chrome. What would be the proper CSS code to resolve this?

Here is the image that will hopefully back up my inquiry:

AhmadF.Cheema (talkcontribs)

Using the select tool, select the tab that you want to change. Under the "Styles" tab, on the top there would be "element.style" brackets. In these, you can include whatever CSS you want to apply on the selected element. Include "font-family: FONT_NAME;" here.

The-Psychid (talkcontribs)

Alright, but can I ask what the "select tool" is, and what it looks like when using MediaWiki?

AhmadF.Cheema (talkcontribs)

In Chrome, press Ctrl+Shift+C; this will open up the select tool. I mentioned this previously in one of your previous topics.

Reply to "Font for Wiki Tabs"
Captgoodhope (talkcontribs)

Hello there

Is there a way to highlight the search hits in the matching documents? The search terms are bold faced in the search results page, but I'd like to see the terms highlighted or bold faced when the documents are opened. DokuWiki does this by default. I tried enabling $wgAdvancedSearchHighlighting but don't see any difference at all with that setting.

Thank you

AhmadF.Cheema (talkcontribs)

You can use CSS to make the desired customisations. In your MediaWiki:Common.css page, use something like the following:

/* Search result headings */
div.mw-search-result-heading {
	background-color: #ffeb3b85;
}
/* Search result content */
div.searchresult {
	background-color: #8bc34a63;
}
Captgoodhope (talkcontribs)
AhmadF.Cheema (talkcontribs)

Someone asked about such functionality three years ago too. Don't think this is natively possible, will probably require some JavaScript.

$wgAdvancedSearchHighlighting appears to be broken. Although it does appear to have some effect on the amount of wikitext shown in the results but nothing relevant to highlighting.

Reply to "Highlight search hits"
142.157.25.184 (talkcontribs)

I installed HeadScript and see it in extensions. (I downloaded and added the line require_once "$IP/extensions/HeadScript/HeadScript.php";)

When I try to add any script like it is advised in the manual

$wgHeadScriptCode = <<<'START_END_MARKER'

<script></script>
START_END_MARKER;

It immediately kills the whole site. "The page cannot be displayed" occurs everywhere. This doesn't depend on script, whatever I put between <script></script> have the same effect.

Please, advise how to fix that.

Malyacko (talkcontribs)

Please tell us if there is any further information in your webserver's error log why the page cannot be displayed, and which MediaWiki version this is about.

Seb35 (talkcontribs)

There must not be any space before the last START_END_MARKER; Can you check that?

PS: I added bold around this important instruction in Extension:HeadScript#Configuration.

Reply to "HeadScript kills the site"

What is the best way to have mobile friendly site?

4
Zeynel1 (talkcontribs)
Malyacko (talkcontribs)

If "it did not work" you could explain why it did not work.

Zeynel1 (talkcontribs)

Yes, sorry. I was trying to install Math extension before this and I had the same error. I could not get the error tracing work. But finally running the update script fixed the issue. I was wondering if there was another way of having a mobile site. This sentence confused me (from Extension:MobileFrontend):

The TemplateStyles extension can be used to style content so that it renders nicely on mobile and desktop. MobileFrontend will not magically fix this for you!

Can this be done with TemplateStyles?

AhmadF.Cheema (talkcontribs)

The Extension:MobileFrontend (or specifically the skins which are used for mobile) will take care of most of the general MediaWiki website elements (navbar, sidebar, logo etc.); however, specific customised templates that the Wiki users create are not automatically corrected by the extension. These templates might need their own CSS rules to make them render the desired way on mobile. Extension:TemplateStyles is the convenient way to define specific CSS rules separately for each template.

Reply to "What is the best way to have mobile friendly site?"

modifiedby field not working since update

2
31.205.234.176 (talkcontribs)

I previously created a dpl to help me with my maintenance jobs on a wiki. Some time ago we got an update to the last version and it caused all dpl's that used the modifiedby field to throw up this error.

The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.

The reason may be an internal error of DPL or an error which you made,

especially when using DPL options like titleregexp.

Query text is:

SELECT DISTINCT `wdd_page`.page_namespace AS page_namespace,`wdd_page`.page_title AS page_title,`wdd_page`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp, rev_id FROM `wdd_revision` AS rev, `wdd_revision` AS change_rev, `wdd_page` INNER JOIN `wdd_categorylinks` AS cl0 ON `wdd_page`.page_id=cl0.cl_from AND (cl0.cl_to='5e') INNER JOIN `wdd_categorylinks` AS cl1 ON `wdd_page`.page_id=cl1.cl_from AND (cl1.cl_to='User') LEFT OUTER JOIN `wdd_categorylinks` AS cl2 ON `wdd_page`.page_id=cl2.cl_from AND cl2.cl_to='Meta' WHERE 1=1 AND cl2.cl_to IS NULL AND `wdd_page`.page_namespace NOT IN ('1') AND `wdd_page`.page_is_redirect=0 AND `wdd_page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `wdd_revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) AND = change_rev.rev_user_text AND change_rev.rev_page = page_id AND `wdd_page`.page_id=rev.rev_page AND rev.rev_timestamp < 20181117160000 ORDER BY rev_timestamp DESC, rev_id DESC

Error message is:

Column 'rev_user' in field list is ambiguous (127.0.0.1)

When the following is inputted:

{{#dpl:|allrevisionsbefore=201811171700|ordermethod=lastedit|order=descending|distinct=true|category=User|notnamespace=Talk|notcategory=Meta|modifiedby=ConcealedLight|noresultsheader=|mode=userformat|format=,\n* %DATE% %PAGE%}}

Any suggestions?

88.130.53.40 (talkcontribs)
Reply to "modifiedby field not working since update"

MediaWiki 1.32.0-RC0 fails with MSSQL

2
132.170.216.182 (talkcontribs)

Windows 2008 R2 IIS 7.5

MS-SQL 2012

MediaWiki 1.32.0-RC0 (11-09-2018)

I had tried 1.31.1 but from reading found it doesn't support MS-SQL at all because of issues with it and it was being fixed in 1.32.0 release. Looking in GIT I saw most of those issues resolved. When I first try to install there's an error on table creation, it looks like a comma was left out of the tables.sql file.

maintenance\mssql\tables.sql line 1044

rc_patrolled tinyint NOT NULL CONSTRAINT DF_rc_patrolled DEFAULT 0

I added the comma to the end in that file and started the entire process over after deleting and remaking a blank DB. After fixing that though it installs the DB and moves on but errors after that.

Install

Setting up database... done

Creating tables... done

Creating database user... done

Populating default interwiki table... done

Initializing statistics... done

Generating secret keys... done

Prevent running unneeded updates... done

Creating administrator user account... done

Creating main page with default content... failed

Information

Could not create a new page. It already exists.

Malyacko (talkcontribs)
Reply to "MediaWiki 1.32.0-RC0 fails with MSSQL"

What is the best way to have mobile friendly site?

1
Summary by Malyacko

Duplicate posting

Zeynel1 (talkcontribs)