Project:Support desk

About this board

Welcome to the MediaWiki Support desk, where you can ask MediaWiki questions!

(Read this message in a different language)

See also

Other places to ask for help:

Before you post

Post a new question

  1. To help us answer your questions, please indicate which versions you are using, as found on your wiki's Special:Version page:
    • MediaWiki version
    • PHP version
    • Database type and version
  2. 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.
  3. To start a new thread, click "Start a new topic".

Fatal exception of type Wikimedia\Rdbms\DBQueryError

9
137.204.93.178 (talkcontribs)

Hello Team,

I have this error. Can you provide some help, please?

Deprecated: Caller from MessageCache::loadFromDB(en)-big ignored an error originally raised from MessageCache::loadFromDB(en)-small: [1146] Table 'mediawiki.revision_actor_temp' doesn't exist (localhost:/run/mysqld/mysqld10.sock) in /volume1/web/mediawiki/includes/debug/MWDebug.php on line 430

[afa6ff44ce65373ca76b2c7f] 2021-05-26 12:22:35: Fatal exception of type Wikimedia\Rdbms\DBQueryError

Malyacko (talkcontribs)

See Manual:How to debug; please provide steps to reproduce, what happened before, which MediaWiki version, etc - please see the sidebar.

Jonathan3 (talkcontribs)

Isn't the actor thing something new in a recent MW version?

Maybe you need to run update.php to get those rows/tables?

Maybe you've an old MW version and are trying to run a new extension?

137.204.93.178 (talkcontribs)

Thanks for the answers.

I already included into LocalSettings.php some of the lines suggested in Manual:How to debug;

$wgShowExceptionDetals = true;

$wgDebugToolbar = true;

$wgShowDebug = true;

$wgDevelopmentWarnings = true;

$wgDebugComments = true;

$wgDebugDumpSql = true;

The result is what you see in my first message.

I also tried to run update.php but the result is "Error 403: there is an error while processing this request".


I have the following setup:

- mediawiki 1.35.1

- php 7.4

- MariaDB 10.3.24

The "computer" is a NAS with Synology operating system (a sort of Linux distribution, I suppose).


Thanks in advance for any help.

137.204.93.178 (talkcontribs)

I forget to mention that the problem arises after an update of several installed packages on my NAS.

Bawolff (talkcontribs)

you probably need to run update.php

137.204.93.178 (talkcontribs)

I also to run update.php from the browser but the result is "Error 403: there is an error while processing this request".

The Synology NAS does not have any internal browser, so how can I run update.php? Mayme I am missing something.

137.204.93.178 (talkcontribs)

UP! There is someone that can provide any help, please?

Malyacko (talkcontribs)

If you get a 403 error then there is a problem with the server, not MediaWiki. Check your server logs for the exact error.

Reply to "Fatal exception of type Wikimedia\Rdbms\DBQueryError"
2001:1C03:5725:B300:7017:BE81:A086:F157 (talkcontribs)

Dear Support Desk,

While working in a project, we got the error when opening said project that went as follows: Failed to start session in HCP Cloud.

How can we solve this to get back to work?

Malyacko (talkcontribs)

Welcome to the support desk for the MediaWiki (!) software. How is this related to the MediaWiki software?

Reply to "Error message"
88.109.79.246 (talkcontribs)

Please could you help? I'm trying to run the example script in locuszoom (as denoted on the manual: https://genome.sph.umich.edu/wiki/LocusZoom_Standalone) however get the following error message.


(base) clovegrove@gechco:/data/clovegrove/locuszoom/examples$ ./run_example.py

Running: /data/clovegrove/locuszoom/bin/locuszoom --metal Kathiresan_2009_HDL.txt --refgene FADS1

Traceback (most recent call last):

  File "/data/clovegrove/locuszoom/bin/locuszoom", line 26, in <module>

    from m2zfast import main

  File "/data/clovegrove/locuszoom/bin/../src/m2zfast.py", line 126

    exec "self.%s = v" % str(k)

        ^

SyntaxError: invalid syntax


Thank you!

Malyacko (talkcontribs)

Welcome to the support desk for the MediaWiki (!) software. We cannot help with potentially incorrect content on random third-party website. You may want to ask on that wiki instead.

Reply to "locuszoom"

Short URL Redirects to index.php

11
136.158.7.154 (talkcontribs)

Hi.

I am currently implementing the short url into my wiki. It works, however it does not redirect to the wiki url but the index.php file.

Everything is copied from the short url configs.

Thanks in advance.

Ciencia Al Poder (talkcontribs)
136.158.7.154 (talkcontribs)

I did copy everything.

Ciencia Al Poder (talkcontribs)
136.158.7.154 (talkcontribs)

It’s not really helping since I already told you that I copied everything.

Ciencia Al Poder (talkcontribs)

The information you provide is not helpful either to figure out what's wrong.

You can start by sharing your configuration, link to your site, etc

2404:3C00:255D:3100:0:0:0:2 (talkcontribs)

Hi,

Same user as before. Coping it led to a 404 error.

2404:3C00:255D:3100:0:0:0:2 (talkcontribs)

Here is the code:

# Enable the rewrite engine
RewriteEngine On

# Short URL for wiki pages
RewriteRule ^/?wiki(/.*)?$ %{DOCUMENT_ROOT}/w/index.php [L]

# Redirect / to Main Page
RewriteRule ^/*$ %{DOCUMENT_ROOT}/w/index.php [L]

LocalSettings.php:

$wgScriptPath = "/w";     
$wgArticlePath = "/wiki/$1";
Ciencia Al Poder (talkcontribs)

If you manually type an index.php URL, it won't redirect to a /wiki/ URL.

The configuration purpose is:

  • The wiki will generate /wiki/ URLs on normal view links (not edit, diff, history links). This is the LocalSettings.php configuration.
  • Your webserver will recognize /wiki/ URLs and translate them into /w/index.php URLs (without a redirect, browser will stay at /wiki/). This is what the apache configuration does.

Does it work for you as I explained?

136.158.7.154 (talkcontribs)

I have done it to an article link, it still leads to a 404 error.

Ciencia Al Poder (talkcontribs)

Basically, it looks like your rewrite rules are not applied, or %{DOCUMENT_ROOT} points to the wrong location.

Try changing %{DOCUMENT_ROOT}/w/index.php to the full path of index.php (in the filesystem).ç

Also, set up some debugging to see how the rewrite is being done (or if it's being applied at all): https://stackoverflow.com/a/9632952/7268905

Reply to "Short URL Redirects to index.php"

ShortURL problems: 404 (used Redwerks)

10
2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

Hello,

I've been trying to set up a Short URL for my MediaWiki install. I am using the latest version of everything that is available to me; I am doing this on a private debian server so i have root access, etc. The Redwerks configuration generator has given me the following code:


RewriteEngine On

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

RewriteRule ^/?$ %{DOCUMENT_ROOT}/w/index.php [L]

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

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

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

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

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

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


as well as


$wgScriptPath = "/w";

$wgScriptExtension = ".php";

$wgArticlePath = "/wiki/$1";


and


$wgEnableUploads  = true;

$wgGenerateThumbnailOnParse = false;


As you can see, i am performing a fairly standard version of this process with my wiki installed at /w/ and intending to use /wiki/Page_name styled links. The root of my web server is /var/www/html. The RewriteRule stuff has been put in 000-default.conf inside /etc/apache2/sites-available.

All of this config should be correct as far as I know.


I then went into my apache2.conf and changed AllowOverride on all three blocks I could find there. I started out by only changing it for the third one (/var/www) but that did not work. Unfortunately, having all three changed to AllowOverride All did not fix my problem. (screenshot: http://g2f.nl/07vvtxd.png)


With all of the above, if all of the troubleshooting threads I have read are to be believed, it should work. However, it does not. I am completely stumped here, and could use some third party input. It would be much appreciated!

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

I should clarify: As the thread title suggestions, what specifically isn't working is the fact that, when i visit the wiki using short URLs, I am getting 404 Not Found errors. I can however still visit the wiki using standard long-form index.php/Page_name type URLs.

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

I have also tried using the .htaccess method, but that also did not work for me and resulted in the same 404 situation.

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

I should also mention I have tried this with $wgUsePathInfo present as well and that did not change anything.

Ciencia Al Poder (talkcontribs)

This is strange. Rules look good to me. Did you restart the Apache service?

Note that all files in /etc/apache2/sites-available may bot be enabled. Look for /etc/apache2/sites-enabled

Be sure you put them in the relevant <Location> or <VirtualHost> section (one that's actually being used for the wiki, all of them if you have separate sections for http and https)

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

I did indeed restart the service several times during this process, so that's definitely not the problem. As I tried the .htaccess method as well as the root method, and tried changing different configurations by ticking different boxes on the Redwerks generator, i each time restarted apache before checking.

In my sites-enabled, there are only symlinks to the files in sites-available, including 000-default which I edited. If I use a2ensite, i get the message that 000-default is already enabled.

In that file, there was already an existing rewriterule to redirect all requests to https. I placed the rewriterules generated by Redwerks in that same location, removing the "RewriteEngine on" as that line was already there from my prior rewrite rule.

(This was all located right above </VirtualHost> closing tag.)

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

The thing is, I don't have a separate VirtualHost for https, so there's only really one file for me to edit here. The fact that the htaccess method ALSO doesn't work, leads me to believe something is going wrong on the "AllowOverride" side of things.


In the guide, I noticed this:

"If the path to your script directory is aliased by the webserver via an Alias directive, as it is in Debian among others, the RewriteRule will work as long as you add the PT flag (ie: change [L] to [PT,L]) to Pass Through the request to the next handler - mod_alias, which will correctly redirect the request, as per Stack Overflow"


I have not yet tried this. This might be what's going wrong. Will report back.

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

Unfortunately, the above trick also didn't do it. Still getting a 404.

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

I also tried the Alias method as outlined in the guide, to no avail.

2A02:A44B:DA4B:1:B0FE:484E:7A2F:350C (talkcontribs)

Never mind!!

I've been a bit of an idiot. I did not realize that 000-default-le-ssl was in fact my https VirtualHost.


Adding the rules to that file as well fixed the problem.

Thank you so much for pointing this out to me, or I would likely never have thought of checking that file.

This problem has been fixed now!

Need to Install PDF Renderer Service which would support to embed the images.

20
Apatha11 (talkcontribs)

HI Support Desk,

Following are the installed software product version(s) those are being used in our RHEL7 server environment.

Installed software

Product Version
MediaWiki 1.35.1
PHP 7.4.15 (apache2handler)
MySQL 8
OS LINUX

We are looking for PDF Renderer Service which would support to embed the images in a Wiki page to a downloaded PDF file.

I have installed this Proton, but it did not work properly. As it's not well explained that how to integrate proton.

I followed this, https://m.mediawiki.org/wiki/ServiceTemplateNode/GettingStarted

it did not work successfully.

Error: {"status":500,"type":"internal_error","title":"ReferenceError","detail":"preq is not defined","method":"GET","uri":"/wikipoc.xyz.com/v1/png/Square_funny"}

URL: http://10.73.21.15:8080/wikipoc.xyz.com/v1/png/Square_funny


Kindly suggest how we can use this in our wiki 1.35.1.

Osnard (talkcontribs)
Apatha11 (talkcontribs)

Is this extension convert html to pdf with Image?

Osnard (talkcontribs)

Those extensions will export a wikipage into PDF.

Mpdf: Not sure, but I guess so. UEModulePDF: Yes.

Apatha11 (talkcontribs)

So UEModulePDF extension can download pdf with image?? Also there is no details for Extension:UEModulePDF on page that how to configure it.


Is this compatible with PHP 7.4?

I have tried MPDF and its downgliding pdf but not giving full path of image, can you please suggest where we can enable full path for image?


When I set as html not pdf so i saw the image url is not full (/wiki135/images/5/57/enterprise-wiki.jpg).


Can you please suggest from where its pickup up URL?

Malyacko (talkcontribs)
Osnard (talkcontribs)

Yes, UEModulePDF is compatible with PHP 7.4 and it will embed images in the PDF. Be aware that you will need to set up a Java Webserver as PDF renderer as well. See https://en.wiki.bluespice.com/wiki/Setup:Installation_Guide/Webservices/PDF-Export

You will probably need to set up the following extensions for UEModulePDF

Be aware that only LTS branches REL1_31 and REL1_35 are supported.

BlueSpice is also available as a MediaWiki distribution that bundels lots of extensions for the business usecase.

I am a little suprised that MPDF shouldn't be able to embed images. Are you sure you have set it up properly?

Apatha11 (talkcontribs)

Yes I have set it up properly as given in MPDF documentation. (Extension:Mpdf)


The path is not coming full in HTML. (/wiki135/images/5/57/enterprise-wiki.jpg).

From where I can change it, or it should be pick this automatically. Path should be like  :

https://localhost/wiki135/images/5/57/enterprise-wiki.jpg not /wiki135/images/5/57/enterprise-wiki.jpg

Error: Error parsing image file - image type not recognised, and not supported by GD imagecreate


Steps I have done:

  1. wget https://extdist.wmflabs.org/dist/extensions/Mpdf-REL1_35-94bd27c.tar.gz

2. tar -xzf Mpdf-REL1_35-94bd27c.tar.gz -C /data/www/html/wiki135/extensions

3. cd data/www/html/wiki135

#php maintenance/update.php

4. added("extensions/Mpdf/composer.json") in wiki135/composer.local.json-sample


{

"extra": {

"merge-plugin": {

"include": [

"extensions/Mpdf/composer.json"] } } }


5. in mpdf dir

#composer update --no-dev

6.added in LocalSettings.php

require_once( "$IP/extensions/Mpdf/vendor/autoload.php");

wfLoadExtension( 'Mpdf' );

$wgMpdfSimpleOutput=true;

7.Given 777 to all 3 dir (/data/www/html/wiki135/extensions/Mpdf/vendor/mpdf/mpdf)

/ttfontdata/

/tmp/

/graph_cache/


http://localhost/wiki135/index.php/Main_Page?title=Main_Page&action=mpdf

Osnard (talkcontribs)

Have you set `$wgServer` or `$wgCanonicalServer` in you wikis configuration?

Have you set `$wgMpdfSimpleOutput = false`?

Apatha11 (talkcontribs)

When I set $wgMpdfSimpleOutput = true , its giving me PDF without image, but when I set it false its giving error:

/data/www/html/wiki135/extensions/Mpdf/vendor/mpdf/mpdf/classes/otl.php: Can't open file /data/www/html/wiki135/extensions/Mpdf/vendor/mpdf/mpdf/ttfontdata/dejavusanscondensed.GSUBGPOStables.dat


I cant see this file dejavusanscondensed.GSUBGPOStables.dat in /ttfontdata

I have already given 777 to Dir /Mpdf/vendor/mpdf/mpdf/ttfontdata/


$wgServer , Yes we have set our server name in Localsettings.php

Apatha11 (talkcontribs)

Please help me to fix this.

Osnard (talkcontribs)
Apatha11 (talkcontribs)

Hi As I can see there are many posts are pending, no one replied even. Could you please suggest to me something else, I need to fix this ASAP.

Kindly check my steps what I have done, if you think that something I missed please let me know.

Osnard (talkcontribs)

You may want to evaluate BlueSpice. It is available as Docker image. So you don't need to set up the PDF-Export manually.

Apatha11 (talkcontribs)

How to use BlueSpice, As there is no proper documentation that how to implement this in our application.

Osnard (talkcontribs)
Apatha11 (talkcontribs)

Is BlueSpice work as an extension like Mpdf or its separate CMS like a wiki. The new implementation will take time and I need to fix it by this week only. Kindly suggest working extension with PHP 7.4, if possible provide proper documentation for PDF export with BlueSpice.

One more thing, We are using LDAP+SSO login in our application Can you confirm that is MPDF compatible with these Protocol services.

Apatha11 (talkcontribs)

Hello Team,

Can you please confirm the above information?

Osnard (talkcontribs)

AFAIK MPdf is not affected in any way by the choice of the authentication method.

BlueSpice is a "distriution" of MediaWiki. You can think of it as an extension bundle, tailored to business needs. It has extensions for PDF export and LDAP/SSO.

Apatha11 (talkcontribs)

But it's affecting our project, with LDAP+SSO it's not working and it's throwing us an unauthorized error in the image function. ( function _imageTypeFromString(&$data) )

$data is printing unauthorized error.

We have set 777 permission to the image folder.

We are already configured MPDF, if possible please provide any resource who can resolve this issue, In the above post, I have mentioned all steps that I have done in MPDF.


The same code is working fine where we are not using LDAP+SSO. Are you sure that MPDF works with the server which is secured with a password?

Reply to "Need to Install PDF Renderer Service which would support to embed the images."
EGCasas (talkcontribs)

Hi everyone,


I have a wiki site that I can edit. I can create pages and edit them just fine, but I need to build the whole site in english and spanish. Is it possible to do this without installing the translation extension? I don't have access to the server, just the frontend functionality for editing the site. Is it possible to create a link in the left sidebar to spanish and english versions of the site; is there an easier way to do this?

I'm very new to MediaWiki and any help is appreciated.


Thanks!

MarioSuperstar77 (talkcontribs)
Reply to "Translating Content"

Changing homepage name to site name per $wgSitename value

7
2001:44C8:44C8:6B18:B0B9:2D7D:C2AA:6000 (talkcontribs)

MediaWiki 1.35.2 in Hebrew.

I desire that the <h1> heading of my website's homepage would be the site name as the $wgSitename value, instead the current, default-created, generic heading עמוד ראשי (which I would translate to English as "main page").

I want to achieve that:

  • Without creating any 301 redirect
  • Without installing any addon extension

Is it possible from the core somehow, perhaps by utilizing SITENAME magic word?

Bawolff (talkcontribs)

The page named MediaWiki:Mainpage controls the "name" of the main page. Edit that page.

2001:44C8:44C8:6B18:484F:35FB:CD28:A71C (talkcontribs)

Hello @Bawolff

I think I don't have such a page; from a search on all webpages with מדיה-ויקי: (MediaWiki:) namespace, I got:

  • מדיה ויקי:Cite references link many
  • מדיה ויקי:Cite references link one
  • מדיה ויקי:Common.css
  • מדיה ויקי:Common.js
  • מדיה ויקי:Emailsubject
  • מדיה ויקי:Sidebar
  • מדיה ויקי:Sitenotice

Furthermore, navigating to example.com/MediaWiki:Mainpage brings not found 404.


What should a user do in such a case?

Jonathan3 (talkcontribs)
2001:44C8:44C8:6B18:484F:35FB:CD28:A71C (talkcontribs)

@Jonathan3

In the FAQ there is the section:

How do I change the Main Page title?

Simply click on the "Move" tab, and move the page to the desired page title.

Usually you also want to change which page is the configured as "main page".

This brings me back to the MediaWiki:Mainpage I mentioned above.

2001:44C8:44C8:6B18:484F:35FB:CD28:A71C (talkcontribs)

@Jonathan3 to further clarify my point: After "moving the main page to another name" the logo links to a deleted webpage

Again, I humbly remind that I don't want to use redirects.

2001:44C8:44C8:6B18:484F:35FB:CD28:A71C (talkcontribs)

Okay,

What I did and might have solved this, was to go to Special pages --->>> System Messages and there to search for "mainpage" (without quote marks) and to edit:

  • מדיה ויקי:Mainpage
  • מדיה ויקי:Mainpage-description
  • מדיה ויקי:Mainpage-nstab

I have edited the system message for each one of them to {{SITENAME}} and saved now the logo image points to my "new" homepage with the new name;

I think that the only thing left for me to do is to also edit the sidebar menu link to point to it as well, because it's currently hard-wired to point to the "old" homepage.

Reply to "Changing homepage name to site name per $wgSitename value"

Is it possible to clear a user's watchlist as an Admin user?

7
71.192.251.183 (talkcontribs)

When we have users that leave our organization we disable them in mediawiki, however, if they had pages in their watchlist that get edited, mediawiki still tries to send them an email. This email bounces due to their email account no longer existing. What is the best way to manage watchlist for 'gone' accounts?

PerfektesChaos (talkcontribs)

An “Admin user” has no access to private things, and I am not aware of any configuration that permits wiki users to interact here.

However, there is the site sysop with database access. They can act as master next to god and at least delete records and field contents from involved databases.

71.192.251.183 (talkcontribs)

How would this work exactly? We are hoping to not have to manually interact with the underlying database.

Jonathan3 (talkcontribs)
71.192.251.183 (talkcontribs)

We don't know the user's credentials.

Jonathan3 (talkcontribs)
71.192.251.183 (talkcontribs)

Thank you. Yes, we can do that, but were hoping for a simpler process. 'Blocking' a user should prevent email from sending to that account and ideally clear their watchlist as well, or at least have the option to.

Reply to "Is it possible to clear a user's watchlist as an Admin user?"

Cargo query export to Excel or CSV gives error This page isn’t working

6
Pharmankur (talkcontribs)

Hi,

I am trying to install Mediawiki for our internal Documentation in organisation.

Product Version
MediaWiki 1.35.2
PHP 8.0.7 (apache2handler)
MariaDB 10.1.48-MariaDB-0ubuntu0.18.04.1
ICU 65.1
Lua 5.1.5

When I am setting a cargo query to output as table, it works fine. But when I set it to export results to CSV or Excel file then on clicking file download link, it shows a blank page saying --


This page isn’t working

XXX.XX.XXX.XX is currently unable to handle this request.

HTTP ERROR 500


I am sure our server is working fine, so there is no problem with it.

I also did NOT find any special settings instructions in Cargo to enable export in CSV or Excel. So I am clueless what is wrong or where to find out.

Please help !

Osnard (talkcontribs)

Hi! Are there any logs available? PHP error log for example? Please have a look at Manual:How_to_debug to learn about getting logs.

Jonathan3 (talkcontribs)

You'd definitely get an answer on the Cargo talk page.

Pharmankur (talkcontribs)

@Osnard

Hi, Php error reporting is already enabled by


<?php

error_reporting( -1 );

ini_set( 'display_errors', 1 );


@Jonathan3

Somehow I did not find any help available on setting up excel or csv export !

Osnard (talkcontribs)

An Error 500 must leave traces in the logs. Without them the error can not be fixed.

Jonathan3 (talkcontribs)

What's your Cargo query?

Reply to "Cargo query export to Excel or CSV gives error This page isn’t working"