# Project:Support desk

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

Archives

There are also other places where to ask: IRC, mailing lists, Q&A etc.

## Post a new question

• 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".

3

Thank you for answering my question @Ciencia Al Poder. Sorry for the duplicate topic, but I cant reply to my original one.

It gave me a code and it says to add it to every page that I want it translated. Is there an easier way to wrap that code and have it displayed on all pages? Maybe through common.js?

Yes, you need to insert scripts in MediaWiki:Common.js as explained in Manual:Interface/JavaScript. Note that this page will contain JavaScript code, not HTML code, so don't put <script></script> tags on it, just the contents of the script. In case you have to load a script file, add this to the page:

 $.getScript( "http://url.of/the/script.js" );  So should I just plainly add the contents of this: https://pastebin.com/xCc1y4yz to common.js? I tried doing it by your second suggestion$.getScript( "http://url.of/the/script.js" );, I created a mediawiki:google.js page and added its url there, but it wouldn't load it.

And if the site will load it, where will it display the translation tool?

## Notice: Uncommitted DB writes

4

Hi,

I'm seeing an error when I'm not logged into a wiki

Notice: Uncommitted DB writes (transaction from DatabaseBase::query (JobQueueDB::doGetSiblingQueuesWithJobs)). in C:\inetpub\wwwroot\WIKI\includes\db\Database.php on line 3306

I have recently upgraded from 1.23 to 1.27. This error started appearing after the upgrade.

Product Version
MediaWiki 1.27.2
PHP 5.6.22 (cgi-fcgi)
SQLite 3.8.10.2 with full-text search support
Lua 5.1.4

This error message appears only when I'm logged out of the wiki. out of the wiki.

This is problematic to diagnose, see task T85762.

Apparently there are pending jobs on your wiki, try to run them through runJobs.php to discard the error is being caused by one of them.

Hi,

I haven't taken any further steps yet, but when I was going to edit a page, I was able to get details of another error:

Warning: unlink(C:\inetpub\wwwroot\data/locks/hck6po3i81n2fwsv27nex1hfwp7wt0p.lock): Permission denied in C:\inetpub\wwwroot\WIKI\includes\filebackend\lockmanager\FSLockManager.php on line 219

Notice: DB transaction callbacks still pending (from ). in C:\inetpub\wwwroot\WIKI\includes\db\Database.php on line 3314

Check that your folder C:\inetpub\wwwroot\data has permissions for IIS and PHP to write on it.

Reply to "Notice: Uncommitted DB writes"

## Incorrect date displaying when not logged in

4

Hi, could someone help with a problem with time and dates please?
I have created a number of "On this day" pages, with each one having a title with the format Month space Date, eg, "May 27", "June 1" etc.

I then added the line {{#ifexist:{{#time: F j}} | *[[{{#time: F j}} | On {{#time: F j}} in SVR history]] }} This checks to see if a page with today's date exists. If it does, it creates the link and adds it to a bulleted list, if not, it returns a blank. This worked fine when logged in, but always defaulted to the date of the last page edit when not logged in, presumably because the parser function takes "the time the page was last rendered into HTML."

I changed the line to {{#ifexist:{{CURRENTMONTHNAME}} {{CURRENTDAY}} | *[[{{CURRENTMONTHNAME}} {{CURRENTDAY}} | On {{CURRENTMONTHNAME}} {{CURRENTDAY}} in SVR history]] }} thinking this would force it to read the current date, but it's exactly the same. I've tried ...title=Main_Page&action=purge and that didn't fix it. It works perfectly when logged in, but as soon as I log out, it reverts back to the date of the last page edit.

Is there a way of fixing this please? It's on the front page and aimed at visitors who will probably not be logged in when they see it, so I could do with having it working properly. It's at www.svrwiki.com if you want to take a look.

Graham

You can use purgeList.php in a cron job to be executed once a day for the pages you want to purge. I don't think there's another solution.

Thanks, I looked at purgeList and that seems to rely on using a squid, which we don't. Extension:External Data linked to http://www.currenttimestamp.com/ might be a way of doing it if it was possible for Mediawiki to read the date. Another idea was to create a Bot that automatically updates the page every day at 00:01. All these are beyond my ability at the moment. Are any of them worth persevering with? There are various Mediawiki calendar or similar extensions out there. Do they all use #time: and have this same problem, or is there one that works for users who are not logged in?

purgeList.php also purges the MediaWiki parser cache if you pass the --purge parameter.

Reply to "Incorrect date displaying when not logged in"

## update.php says composer.lock not up to date

5

When I run update.php from the "maintenance" folder I get this response:

"mediawiki/validator: 2.3.1 installed, 2.2.* required.

mediawiki/semantic-media-wiki: 2.5.2 installed, ~2.5 required.

mediawiki/maps: 4.2.1 installed, ~4.1 required.

Error: your composer.lock file is not up to date. Run "composer update" to install never dependencies"

But when I run "composer update" from the wiki's root directory, I get this message: "Nothing to install or update" and I still cannot run update.php. What could be wrong?

 MediaWiki 1.28.2 PHP 7.0.15-0ubuntu0.16.04.4 (apache2handler) MySQL 5.7.18-0ubuntu0.16.04.1

Thanks!

Henrik Thiil Nielsen

And here's my Version-page: https://www.irhb.org/wiki/index.php/Special:Version

[0] should allow you to continue with the update process.

This comment was hidden by MacFan4000 (history)

Beautiful! Thank you very much.

## Contributions not updated after import

11

Hi,

After performing an import, contributions for users have not been updated. For example "Main Page" history shows that user "A" has for example 10 edits, but Special:Contributions shows no edits for that user, and it is a redlink. Any ideas how to fix this?

This is after the user created the account on the newly imported wiki

Maybe the update is queued? Manual:Job queue

Try checking your Wiki's statistics: https://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=statistics

I think there is a maintenance script, which allows you to update the edit count numbers for all users inside the database. Using this script might set the values correctly again.

Thank you for your answers. The update is not queued, as there are no jobs waiting.

I ran the script, initEditCount.php with no success. Any other suggestions would be appreciated.

When you say that Special:Contributions would be a red link, do you then after clicking that link actually see the special page "Contributions"? And if so: Does it say the user would not(!) be registered? Or are you not seeing this page at all?

It is a redlink, and when I click it I see the page but there are no user contributions that show up. As I said previously, the contributions were only "gone" after the users registered on the new wiki.

I just checked includes/specials/SpecialContributions.php and it looks like the Contributions page is getting information on the edits directly from the database (and not from a cache or so). The interesting part is where it calls ContribsPager(). Do the variables contain wrong data at that place? Maybe something went wrong with the import?

Btw. I do not understand why the users have to register again in the new wiki. Have you deleted the user table? Or: Why have they been there in the old installation and are no longer in the new one?

Yes, to my knowledge the user table has not imported (as this is a wiki farm, and user tables are shared).

I'm not quite sure how and where I can check what you are asking.

Oh, so this is an installation with a shared user table. I am no expert in that regard, but I would guess that in this case having no content in the user table might be ok(?). But it seems like somehow the connection to your shared user table got lost or is broken currently.

I have checked the user table for the local wiki, and the registered users do show up normally, though the same as on-wiki, they have no edits.

Reply to "Contributions not updated after import"

## DBQueryError at index.php

2

After I finish installing my wiki, and upload the LocalSettings file, I try to just head to the main index page (or the "create" page), but I get the following error:

Fatal exception of type "DBQueryError"

So I cannot view any page on my wiki. Right now, I have one website with two subfolders containing their own wikis. I set up one wiki a month or so ago, and it works perfectly right now. Today, I'm trying to setup a second wiki in that second subfolder, but I get that error above. Both wikis share the same user, same server, same MySQL process, etc. I'm using version 1.28.2 of mediawiki for both. I've re-downloaded the tar gz file a few times and started from scratch (after removing databses and files on the server), but no luck. I have NOT tried an older version of mediawiki, so... maybe I might need to.

You would need to provide more information for us to be able to see what the error is.

error_reporting( -1 );

ini_set( 'display_errors', 1 );

$wgShowSQLErrors = true;$wgDebugDumpSql = true;

## There’s a problem with this website’s security certificate

8

Hi I have just installed mediaWiki on my computer running Windows 10. For some reason I cannot get rid of this error when I open my wiki: There’s a problem with this website’s security certificate

Thanks

On computer?

Yes, on my 'computer'. In fact on my 'laptop'. This is a new laptop. I have mediawiki on my old laptop, although it is a bit out-of-date 1.15.4! Not sure how to transfer content, but that is for another day! Thanks.

I think you are getting this warning, because new browser versions warn you in case of missing certificates. With the same browser version you would also get this warning, if you used the old wiki installation.

I think there are three options: Create your own, self-signed certificate. This does not cost you anything, but the browser might still complain that the certificate is not signed by a valid authority. The other option would be to buy a certificate - but I don't know if that is possible for localhost at all... Or - third option - maybe the browser can be configured to no longer complain.

For the content there is our manual: Manual:Moving a wiki.

Even better, get a LetsEncrypt certificate, which is free and not self signed. Also the latest versions of Safari/Chrome/Firefox don't give warnings for non ssl sites. It also sounds like you are trying to load via https://.

Thank you all for the replies. Not sure I am capable of following the suggestion re 'certificates'.

Mac, yes, I do appear to be using https:// can I change it, and how? https://localhost/mediawiki/index.php/Main_Page

Cheers

Mac

Many thanks that worked.

## Images and thumbnails not displayed

3

Hi,

I have exported my procedure from Bizagi Modeler 3.1 to Wiki and run with Mediawiki 1.28.

I added those settings below from my LocalSettings.php:

$wgGroupPermissions['*']['upload'] = true;$wgFileExtensions = array('png','gif','jpg','jpeg','doc','xls','mpp','pdf','ppt','tiff','bmp','docx', 'xlsx', 'pptx','ps','odt','ods','odp','odg');

$wgEnableUploads = true;$wgAllowImageTag = true;

I allow all rights for all users on the repository below:

/mediawiki/images

The problem is that no images are displayed on my procedure and the <img> tag html have no attribute "src" .

When I set $wgAllowImageTag = false; I can see that <img> tag html have the attribute src with the image path but the <img> html tag is reconized as a text. Please, someone can help me with settings. I think I forgot to set anything else. Thanks for reply. Regards$wgFileExtensions doesn't affect what kind of file you can add to img tag. The src attribute will be dropped if it's not a valid URL (<nokiki>http://servername/path/file.ext</nokiki>). You can't use UNC URLs nor relative URLs.

This comment was hidden by Ciencia Al Poder (history)
Reply to "Images and thumbnails not displayed"

2

Is it possible to integrate google translate with mediawiki?

If google translate can be integrated with any website, then yes, it should be possible. Refer to the google translate docs.