Project:Support desk

Jump to navigation Jump to search

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

Hi I'm trying to install wikimedia

8
2A00:23C6:F782:B700:E57C:3C63:7918:EABD (talkcontribs)

This is the problem I'm running into. No clue what to do.


[YHIRZHvPbKyipD3wVS0RSQAAAAI] /mediawiki-1.35.1/mw-config/index.php?page=Install Wikimedia\Rdbms\DBQueryError from line 1699 of /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?


Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' DEFAULT CHARSET=binary' at line 8 (sql104.epizy.com)

Function: Wikimedia\Rdbms\Database::sourceFile( /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/maintenance/tables-generated.sql )

Query: CREATE TABLE `site_identifiers` (

si_type VARBINARY(32) NOT NULL,

si_key VARBINARY(32) NOT NULL,

si_site INT UNSIGNED NOT NULL,

INDEX site_ids_site (si_site),

INDEX site_ids_key (si_key),

PRIMARY KEY(si_type, si_key)

) ENGINE=, DEFAULT CHARSET=binary


Backtrace:

#0 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)

#1 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#2 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#3 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(5075): Wikimedia\Rdbms\Database->query(string, string)

#4 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php(5010): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL)

#5 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/DatabaseInstaller.php(232): Wikimedia\Rdbms\Database->sourceFile(string)

#6 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/DatabaseInstaller.php(256): DatabaseInstaller->stepApplySourceFile(string, string, boolean)

#7 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/Installer.php(1732): DatabaseInstaller->createTables(MysqlInstaller)

#8 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/WebInstallerInstall.php(44): Installer->performInstallation(array, array)

#9 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/includes/installer/WebInstaller.php(269): WebInstallerInstall->execute()

#10 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/mw-config/index.php(82): WebInstaller->execute(array)

#11 /home/vol9_8/epizy.com/epiz_xxxxxxxx/htdocs/mediawiki-1.35.1/mw-config/index.php(40): wfInstallerMain()

#12 {main}

Malyacko (talkcontribs)

In SQL, what is the output of SHOW ENGINES; ?

2A00:23C6:F782:B700:1C82:9225:FF43:8459 (talkcontribs)

Hi. Thanks for the reply. This is the output:

Engine Support Comment Transactions XA Savepoints
PERFORMANCE_SCHEMA YES Performance Schema NO NO NO
CSV YES CSV storage engine NO NO NO
MRG_MYISAM YES Collection of identical MyISAM tables NO NO NO
BLACKHOLE YES /dev/null storage engine (anything you write to it... NO NO NO
MyISAM DEFAULT MyISAM storage engine NO NO NO
FEDERATED NO Federated MySQL storage engine NULL NULL NULL
ARCHIVE YES Archive storage engine NO NO NO
MEMORY YES Hash based, stored in memory, useful for temporary... NO NO NO
InnoDB NO Percona-XtraDB, Supports transactions, row-level l... NULL NULL NULL
Bawolff (talkcontribs)

And in particular, make sure that InnoDB is one of them.

Also, were you prompted during install to choose between innodb/myisam, and if so what did you choose?

Also did you compile mysql/mariadb yourself with unusual compile time options, get it from an unusual source, or otherwise have something unique with your database? You're the second person i have heard of with this issue (mediawiki installer not detecting mysql engine properly), and i dont think anyone figured out what happened last time around.

2A00:23C6:F782:B700:1C82:9225:FF43:8459 (talkcontribs)

Hi. Thanks for the reply. I tried SHOW ENGINES; and it says my database doesn't support innodb but I can't use myisam because the installer didn't prompt me to choose between them. Do you know if there's any way around this or will I have to find a new host where they have innodb?

Bawolff (talkcontribs)

Hmm, i thought it'd be automatically detected. There is definitely a bug in the installer. I guess you could try the commandline install.php


You might want to do that anyways, innodb is much more reliable than myisam

Tanbirzx (talkcontribs)

Your question title is not appropriate. It should be like this, hi i am trying to install MediaWiki.

See- Download

MediaWiki is not compatible with PHP 7.4.0 to 7.4.2 due to an upstream bug. Use PHP 7.4.3 or later instead. See [[task T246594]] for more information. Thank you

Malyacko (talkcontribs)

@Tanbirzx That comment is not helpful. Why do you think this has anything to do with PHP versions? The reporter did not even mention any PHP version. You could ask them for a PHP version, instead of jumping to wrong conclusions.

Reply to "Hi I'm trying to install wikimedia"

Adding external CSS and JS to wiki

2
Jonathan3 (talkcontribs)

I'd like to add Responsive Tables to my wiki. It needs the following to be added:

/* Attach the Table CSS and Javascript */
<link rel="stylesheet" href="responsive-tables.css">
<script src="responsive-tables.js"></script>

I tried to add it using Extension:Widgets but it didn't work for me (maybe because it incorporated it within the body part of the web page rather than in the head?)

I guess I could manually edit the skin, but is there a recommended way of doing this in a way that wouldn't require me to repeat it on an upgrade? Thanks.

Bawolff (talkcontribs)

Use mediawiki:common.js and mediawiki:common.css you'll need to adjust the loading code though to work from within a css / js file instead of html.

Reply to "Adding external CSS and JS to wiki"

Double login mode GoogleLogin and standard mw login

1
Francismule2021 (talkcontribs)

Hello,

i want to use mw as a corporate wiki.

My need is:

  • Registration and social login via google for my domains
  • Registration and classic login for users not belonging to my domain (to be authorized once registered independently.

Now I have configured the GoogleLogin extension and I was able to log in with google.

But I can't create the array of my domains (so that my google users can register and log in).

I manage to keep the classic recording.

Reply to "Double login mode GoogleLogin and standard mw login"
JokerLow (talkcontribs)

Hey, as the title says, I am interested if there's any sort of plugin for wiki pages that'd add internal links to pages automatically if there are any patterns on the same wiki. I am curious if such a plugin or method exists.

Jonathan3 (talkcontribs)
Bawolff (talkcontribs)

UseModWiki?

Jonathan3 (talkcontribs)

What are you trying to achieve? I wrote an extension that looks for alphanumeric patterns (reference numbers, essentially) and for each one spotted, creates an automatic link either to a wiki page (if the pattern appears in its title) or a page on an external website (again, if the pattern appears there). It works well but isn't good enough to show anyone. I'd be happy to discuss it though.

JokerLow (talkcontribs)

Hey, so yeah you got the answer to my question Jonathan3. That extension is the thing I was actually looking for, thank you a lot for your help.

Reply to "Auto internal linking"

Active users: different values?

3
91.125.240.46 (talkcontribs)

I'm getting wildly different values for active users on my Wiki.

  • {{NUMBEROFACTIVEUSERS}} is giving me 11
  • Special:Statistics also shows 11
  • Special:ActiveUsers gives me a much bigger list (over 50), 39 of which have at least 1 edit

The rest of the statistics update so I'm pretty sure the updatespecialpages script is running.

Are some usergroups excluded from this stat? They all show in Active users. After exporting the data it looks like I have 11 users with over 11 edits... everyone below 11 is not showing on Active Users.

Any hints? I'm at a loss. Thanks!

PerfektesChaos (talkcontribs)

There are four levels in this game:

  • {{NUMBEROFACTIVEUSERS}} – number of registered users who edited within recent 30 days, or performed any action, at least one
  • {{NUMBEROFUSERS}} – number of accounts, perhaps without any edit ever
  • Special:ActiveUsers – users who might have registered (or perhaps logged in only) within last 30 days, but did not need to perform any action
  • anonymous users who might have edited

Enjoy.

91.125.240.46 (talkcontribs)

I understand the different levels, but Active Users were showing different amounts. Running initstats.php (been a pain getting access to shell!) has fixed this and now displaying the right number on the Statistics and magic word. Thanks for your reply!

Reply to "Active users: different values?"
Arxon978 (talkcontribs)

Good day for all of you! I am looking for the MediaWiki specialist to help me to support and develop my website. I found it hard to find any. It would be great if there is some pages at your website with a list of MediaWiki specialists, who are looking for customers in different countries.

Malyacko (talkcontribs)
Reply to "MediaWiki in Russia"

I didn't ask for this and I don't want it. It won't let me play my games. How do I get it off???"

3
2603:6010:6E00:10CC:F593:1327:4587:146B (talkcontribs)

I didn't ask for this stuff and I don't want it. It won't let me play my games. How do I remove it????

Malyacko (talkcontribs)

This is a forum for the MediaWiki software. Please read the sidebar first.

Tanbirzx (talkcontribs)

About which stuff are you talking?

Reply to "I didn't ask for this and I don't want it. It won't let me play my games. How do I get it off???""
Onmiy (talkcontribs)

Hello,

is it possible to set up pages, which is only visible to a group of logged in members?


Thanks

Tanbirzx (talkcontribs)

Where do you want to set up or create this kind of pages?

Onmiy (talkcontribs)

If possible without any restrictions. except on the main page

Tanbirzx (talkcontribs)

If this will in a wiki then this action is only done by administrator.

Malyacko (talkcontribs)
Reply to "Invisible Page"
151.210.138.204 (talkcontribs)

I get the following error when executing php update.php from the maintenance folder:

PHP Fatal error:  Uncaught Exception: Unable to open file /skins/MonoBook/skin.json: filemtime(): stat failed for /skins/MonoBook/skin.json in /home/<user>/webapps/<site>/includes/registration/ExtensionRegistry.php:177

Stack trace:

#0 /home/<user>/webapps/<site>/includes/GlobalFunctions.php(88): ExtensionRegistry->queue('/skins/MonoBook...')

#1 /home/<user>/webapps/<site>/LocalSettings.php(137): wfLoadSkin('MonoBook')

#2 /home/<user>/webapps/<site>/includes/Setup.php(143): require_once('/home/mercuryin...')

#3 /home/<user>/webapps/<site>/maintenance/doMaintenance.php(91): require_once('/home/mercuryin...')

#4 /home/<user>/webapps/<site>/maintenance/update.php(253): require_once('/home/mercuryin...')

#5 {main}

  thrown in /home/<user>/webapps/<site>/includes/registration/ExtensionRegistry.php on line 177


Any help appreciated!

Bawolff (talkcontribs)

Are you missing monobook skin?

151.210.138.204 (talkcontribs)

Well... the 1.35 package expands to give a /skins folder with /MonoBook in it and skin.json so I can't see an issue there.

As suggested I have added the skin to the LocalSettings.php file using wfLoadSkin('MonoBook'). Perhaps it's not necessary to declare this if it's a default skin?

Bawolff (talkcontribs)

Huh, the paths look weird there in the error message. What is $wgStyleDirectory set to? Has it been changed from default?

151.210.138.204 (talkcontribs)

(I have replaced the actual user and site with <user> and <site> in the URL's for privacy when posting.)

The location of the skins directory was set thus:

$wgStyleDirectory   = "$IP/skins";

$IP = $_SERVER['DOCUMENT_ROOT'];

...so I have used a more absolute entry for $IP.


Rerunning update.php is successful, however, I have a subsequent error at this point:

Beginning migration of revision.rev_user and revision.rev_user_text to revision_actor_temp.revactor_actor

... rev_id=100

... rev_id=200

... rev_id=300

... rev_id=400

... rev_id=500

... rev_id=600

... rev_id=700

... rev_id=800

... rev_id=900

... rev_id=1000

... rev_id=1100

... rev_id=1200

MediaWiki\Revision\RevisionAccessException from line 1296 of /home/<user>/webapps/<site>/includes/Revision/RevisionStore.php: Main slot of revision not found in database. See T212428.


I can see T212428 refers to a previous bug/revision but I can't find a way through this error.

Any suggestions?

Bawolff (talkcontribs)

If therr was an error in your $IP = $_SERVER['DOCUMENT_ROOT']; line (and $IP was null), it might cause the error you described. I would double check $IP 's value.

151.210.138.204 (talkcontribs)

I'm assuming $IP's value is correct. After giving it a hard URL the update.php script was able to find the /skins directory.

So to confirm - I've commented out the $IP = $_SERVER['DOCUMENT_ROOT']; line and replaced it with:

$IP = "/home/<user>/webapps/<site>";

Bawolff (talkcontribs)

That probably makes sense because the cli has no document root.


T212428 means phab:T212428

151.210.138.204 (talkcontribs)

I understand. I've set $_SERVER['DOCUMENT_ROOT'] manually at the top of includes/Revision/RevisionStore.php:

$_SERVER['DOCUMENT_ROOT'] = "/home/<user>/webapps/<site>";


Running maintenance/update.php again results in what looks like the same error?:

Creating actor entries for all registered users

... 1 - 1

Completed actor creation, added 0 new actor(s)

Beginning migration of revision.rev_user and revision.rev_user_text to revision_actor_temp.revactor_actor

MediaWiki\Revision\RevisionAccessException from line 1299 of /home/mercuryinretrograde/webapps/mercuryinretrograde_org/includes/Revision/RevisionStore.php: Main slot of revision not found in database. See T212428.


Any suggestions?

Is there a better place to set $_SERVER['DOCUMENT_ROOT']?

Reply to "issue with upgrade to 1.35"

problem with displaying images after importing sql dump / "php importDump.php" in new server ( getting tones of pages with broken file links )

4
165.225.206.250 (talkcontribs)

Hi All, From some time Im struggling wit the issue where on on my MediaWiki 1.35 hosted Centos7 with XAMP ( 7.3.27-1 / 7.4.16-0, PHP 7.3.27 , 7.4.16 ,Apache 2.4.46 , MariaDB 10.4.18 ) i was trying to import into my wiki data via mysqldump -ed files from the other of my server also working under Centos 7 and a bit older XAMPP , MediaWiki v. 1.32. and older version of Mariadb 10.3.16 ) After typical pulling sql dump of DB with all tables , I wasnt able log in, nor launch any pages in new server.. Looks like this import totally messed up my wiki. When I was trying to log in, frontend screen error was saying: "Auto-creation of a lcoal account failed. Username entered already in use... " . I did chacke USER table form backend and looked ok to me .

I decided to restore my wikidb from sql backup which I made prior the that import, So I did try another shut and import data previously exported , this time with usage of "php dumpBackup.php --full --quiet > dump.xml" . I did import successfully my new server with "php importDump.php < dumpfile.xml" .Pages looked to be opening correctly and logging was proper. I did copy over all IMAGE folder and untar it. All other server paths and settings looks exactly the same on my both servers. IMAGE folder have all correct permissions. but imported images are not being displayed.

I did use few of the maintenance scripts like: php rebuildImages.php , checkImages.php , rebuildImages.php and all other related with images and metadata. Even so my other imported images are in the same directory, those php maintenance script only can detect just one image file that i recently uploaded and put on a article manually via defaul editor. All imported pages seems to be OK on my new server, so the problem is with pages cannot "see" images embended. Can you advise what esle should I check? what can be casuing problem, is tehre any other maintenace activity i can try? ps I did twice my sql dump import with also with droping the DB


thanks for any hits

165.225.206.250 (talkcontribs)

also when comparing the tables between servers , i see that in page table I have different values for page_id for given page titles than in old server. that is casung that imagelinks table via its field il_from referencing the page table ( page_id) are having mismatch. However dumping and importing page table again from the old server is casuing wiki to not display sites all . rebuildall.php crashes with error when trying to fix it.

Bawolff (talkcontribs)

Did you copy over the image table?

165.225.206.250 (talkcontribs)

yes, the image table was copied to new db. the problem the when compare page table i see different page_id values per page name. that is why imagelinks table provide a valid values. , but when I copy over the page table , it all crashes and new wiki cannot display any page.

Reply to "problem with displaying images after importing sql dump / "php importDump.php" in new server ( getting tones of pages with broken file links )"