The Wayback Machine - https://web.archive.org/web/20160617033649/https://www.mediawiki.org/wiki/Project:Support_desk

Project:Support desk

Jump to: navigation, 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, 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
184.166.208.99 (talkcontribs)

I'm trying to read a wiki page and every time I load the page, a certain ad for "buzz60" pops up in the corner of my screen. It takes up well over a quarter of my screen and scrolls with the page, effectively making it impossible to read the page. I took a screenshot of the ad:

http://image.prntscr.com/image/735f2efcd8ca4b719936e3fb0ba9374d.png

There are barely eight lines of readable text below it. The ad has no visible X or close button, and when it gets to the end of the video it just repeats.

I don't really know what else to do besides post here. I just want to read my article.

Reply to "I can't remove this ad"
Simon Shortman (talkcontribs)

Tried multiple times to follow SQL server install instructions, have created the schema by hand and it works for same credentials so don't know why this is failing! Also would be great to add to existing DB given one can specific schema/prefix.

Setting up database...

A database query error has occurred. This may indicate a bug in the software.

  • Query: CREATE SCHEMA [Wiki]
  • Function: MssqlInstaller::setupDatabase
  • Error: 15247 [SQLSTATE 42000][Error Code 15247][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]User does not have permission to perform this action. [SQLSTATE 42000][Error Code 2759][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]CREATE SCHEMA failed due to previous errors.

Backtrace:

#0 D:\home\site\wwwroot\includes\db\Database.php(1076): DatabaseBase->reportQueryError('[SQLSTATE 42000...', 15247, 'CREATE SCHEMA [...', 'MssqlInstaller:...', false) #1 D:\home\site\wwwroot\includes\installer\MssqlInstaller.php(508): DatabaseBase->query('CREATE SCHEMA [...', 'MssqlInstaller:...') #2 [internal function]: MssqlInstaller->setupDatabase(Object(MssqlInstaller)) #3 D:\home\site\wwwroot\includes\installer\Installer.php(1592): call_user_func(Array, Object(MssqlInstaller)) #4 D:\home\site\wwwroot\includes\installer\WebInstallerPage.php(1419): Installer->performInstallation(Array, Array) #5 D:\home\site\wwwroot\includes\installer\WebInstaller.php(280): WebInstallerInstall->execute() #6 D:\home\site\wwwroot\mw-config\index.php(77): WebInstaller->execute(Array) #7 D:\home\site\wwwroot\mw-config\index.php(36): wfInstallerMain() #8 {main}

I'm actually installing against AzureSQL but this should look exactly like any SQL Server.

87.123.10.44 (talkcontribs)

Instead of trying to solve the permission problem, I want to tell you this: While MediaWiki in fact should work with MSSQL, its MSSQL support is way less mature than the MySQL support. So if you are setting up a new database system now anyway, I recommend using MySQL (or MariaDB if you like). MediaWiki will run with less trouble and - should you have questions - it will be way easier to get support from the MediaWiki community as basically everyone uses MySQL (or MariaDB), while nearly no one uses MSSQL.

Ciencia Al Poder (talkcontribs)

See also task T113831

87.123.1.191 (talkcontribs)

As you can see in the task, Skizzerz, who implemented MSSQL support, is talking, but I have not seen a single patch. So at least currently this seems to me like he has no definite plans to make it working in versions other than 1.23. Based on the reading in this phabricator task, I tend to change my "MSSQL should work" to a "MSSQL might work, partly maybe only by accident and you absolutely cannot expect it to continue working in current and even less in future versions".

And to make this very clear: There has not been a single patch up to now, but even if there would be patches to make MediaWiki work better with MSSQL, there are absolutely no plans to make 1.26 compatible as well. I strongly discourage using MediaWiki 1.26 with MSSQL.

Simon Shortman (talkcontribs)

Thanks for insights. I had planned to use MySQL. The Installer though gave the option for MSSQL so I thought I'd give it a go. Perhaps the installer should present options based on version/db-engine compatibility and not provide unsupported install options - that confuse novices ?

I guess one could regress to 1.23, for now (it's for experimental use anyway) and look for future supported compatibility when it arrives. Based on the experiment we can redeploy as MySQL. Once assumes any setup and data can be migrated from MSSQL to MySQL as the schemas are logically similar?

Ciencia Al Poder (talkcontribs)

If you plan to use MediaWiki once MediaWiki 1.23 will be no longer supported (May 2017), don't use MSSQL.

Support for MSSQL in LTS version is for supporting those that created their wiki while it was supported, to provide at least an LTS version instead of running an old and insecure wiki.

Simon Shortman (talkcontribs)

1.23.14 did not work anyway...still errors out trying to create tables in the wrong DB (Master), so will revert to MySQL

Thanks All!

Reply to "1.26.3 installation - SQL Server"

Wiki favicon not working on specific wiki pages.

1
Kanecow (talkcontribs)

I have the favicon.icon both on the root directory and I've also forced it through

$wgFavicon = "$wgScriptPath/favicon.ico";

I'm having this issue on a single page that I'm aware right now.

Reply to "Wiki favicon not working on specific wiki pages."
Kanecow (talkcontribs)

I've enabled php and sql errors and this is what Im getting.

Database error

A database query error has occurred. This may indicate a bug in the software.

  • Query: SELECT /*! STRAIGHT_JOIN */ page_namespace,page_title,page_id FROM `mw_pagelinks`,`mw_page` WHERE pl_namespace = '2' AND pl_title = 'PAGE_SOURCE' AND (page_id=pl_from) ORDER BY pl_from LIMIT 100
  • Function: BacklinkCache::queryLinks
  • Error: 2006 MySQL server has gone away (localhost)

This is the error im getting when moving pages. It happens so far in all pages I've tested. Could someone help me with it?

Ciencia Al Poder (talkcontribs)

http://dev.mysql.com/doc/refman/5.7/en/gone-away.html has information about this error, which seems a problem in mysql configuration. If saving/moving a page takes too long (30 seconds or more), it could be a timeout, caused by mysql server very busy or similar. If it happens almost instantly, it could be a serious bug of mysql server which killed the thread executing your query.

About the wrong IP, you must set $wgSquidServers

Kanecow (talkcontribs)

Regarding the Move issue, it's instantaneous, and it didn't use to happen, it started happening out of nothing. So I dont think ive changed anything in the mysql configuration.

Kanecow (talkcontribs)

bump?

Kanecow (talkcontribs)

bump?

Reply to "db query error when moving pages"

Wrong temp. on website, but customclientraw.txt is OK

1
Stonefox1958 (talkcontribs)

On my website show the wrong temperature, but I look in the file "customclientraw.txt" then it is the right temperature.

Why read "Steel Gauges" not the right values and displays them?

My site path : http://www.steenmikkelsen.dk/vejr/steelgauges/gauges-ss-basic.htm

path to "customclientrawlocal.txt" : http://www.steenmikkelsen.dk/vejr/webfiles/customclientraw.txt

Reply to "Wrong temp. on website, but customclientraw.txt is OK"
Mlpearc (talkcontribs)

I have a question about the image directory at public_html/w/images. I was recently downloading some backups and I noticed while backing up the image directory there are hundreds of files in there that were never uploaded to my project. I'm assuming if you transclude an image from an outside website like Commons, the files are cached somehow in that directory, my question is, can I go through the files and delete the one's I don't recognize or one's that were not uploaded, maybe there's a script that deletes file without file pages. ~~~~

87.123.10.44 (talkcontribs)

Since you are speaking about Commons: There is the variable $wgUseInstantCommons, which - if set to true makes MediaWiki create such files on your local disk.

For files, which have been uploaded in your local wiki, if you use default settings, you can remove thumbnail files and there should be no breakage. If these files are requested again in the future (e.g. by a wiki page, where the image is linked in the according size), MediaWiki will recreate them (which will cost some CPU time, but that is all).

I honestly don't know, if you can do the same with files, which are there because they have been downloaded from Commons. Note however that starting with MediaWiki 1.27, $wgUseInstantCommons will no longer create copies on your local server, but it will instead hotlink the files on Commons. Iguess that then, with MediaWiki 1.27, you can remove those files.

Mlpearc (talkcontribs)

Thank you for your reply, I guess it would be best to wait for 1.27 ~~~~

Reply to "Cleaning out the image directory"

A database query error has occurred. This may indicate a bug in the software.

2
Milesj831 (talkcontribs)

Hi,

just imported an old SQL backup and now getting this error.

having the following error:

  • Query: SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1
  • Function: WikiPage::pageData
  • Error: 1054 Unknown column 'page_links_updated' in 'field list' (localhost)
87.123.20.42 (talkcontribs)

The column page_links_updated has been added in MediaWiki 1.23. If your database dump has been created with an older version of MediaWiki, what you got is one of the problems you will have.

Since you are now using a newer version of MediaWiki, what you have to do basically is to do a complete upgrade. One of the steps you are missing is: You have to run update.php in order to update the database!

Reply to "A database query error has occurred. This may indicate a bug in the software."

After Update from 1.26.3 to 1.27.0 user cannot create a new account as before

4
Pingopilot (talkcontribs)

The new user sees after clicking on "create new user account", "you have to login first"

,....

I did not change my localsettings.php:

error_reporting(-1);

ini_set('display_errors', 1);

<?php

# This file was automatically generated by the MediaWiki 1.23.13

# installer. If you make manual changes, please keep track in case you

# need to recreate them later.

#

# See includes/DefaultSettings.php for all configurable settings

# and their default values, but don't forget to make changes in _this_

# file, not there.

#

# Further documentation for configuration settings may be found at:

# https://www.mediawiki.org/wiki/Manual:Configuration_settings

# Protect against web entry

if ( !defined( 'MEDIAWIKI' ) ) {

exit;

}

## Uncomment this to disable output compression

# $wgDisableOutputCompression = true;

$wgSitename = "Luithlen Wiki";

$wgMetaNamespace = "Luithlen_Wiki";

## The URL base path to the directory containing the wiki;

## defaults for all runtime URL paths are based off of this.

## For more information on customizing the URLs

## (like /w/index.php/Page_title to /wiki/Page_title) please see:

## https://www.mediawiki.org/wiki/Manual:Short_URL

$wgScriptPath = "/MediaWiki";

$wgScriptExtension = ".php";

## The protocol and server name to use in fully-qualified URLs

$wgServer = "https://xyz.org";

## The relative URL path to the skins directory

$wgStylePath = "$wgScriptPath/skins";

## The relative URL path to the logo. Make sure you change this from the default,

## or else you'll overwrite your logo when you upgrade!

$wgLogo = "{$wgScriptPath}/LuithlenEltern.jpg";

## UPO means: this is also a user preference option

$wgEnableEmail = true;

$wgEnableUserEmail = true; # UPO

$wgEmergencyContact = "xyz@gmx.de";

$wgPasswordSender = "xyz@gmx.de";

$wgEnotifUserTalk = true; # UPO

$wgEnotifWatchlist = false; # UPO

$wgEmailAuthentication = true;

## Database settings

$wgDBtype = "mysql";

$wgDBserver = "localhost";

$wgDBname = "Luithlen_Wiki";

$wgDBuser = "Ingo";

$wgDBpassword = "xyz";

# MySQL specific settings

$wgDBprefix = "";

# MySQL table options to use during installation or update

$wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=utf8";

# Experimental charset support for MySQL 5.0.

$wgDBmysql5 = false;

## Shared memory settings

$wgMainCacheType = CACHE_NONE;

$wgMemCachedServers = array();

## To enable image uploads, make sure the 'images' directory

## is writable, then set this to true:

$wgEnableUploads = true;

#$wgUseImageMagick = true;

#$wgImageMagickConvertCommand = "/usr/bin/convert";

# InstantCommons allows wiki to use images from http://commons.wikimedia.org

$wgUseInstantCommons = false;

## If you use ImageMagick (or any other shell command) on a

## Linux server, this will need to be set to the name of an

## available UTF-8 locale

$wgShellLocale = "en_US.utf8";

## If you want to use image uploads under safe mode,

## create the directories images/archive, images/thumb and

## images/temp, and make them all writable. Then uncomment

## this, if it's not already uncommented:

#$wgHashedUploadDirectory = false;

## Set $wgCacheDirectory to a writable directory on the web server

## to make your wiki go slightly faster. The directory should not

## be publically accessible from the web.

#$wgCacheDirectory = "$IP/cache";

# Site language code, should be one of the list in ./languages/Names.php

$wgLanguageCode = "de";

$wgSecretKey = "xyz";

# Site upgrade key. Must be set to a string (default provided) to turn on the

# web installer while LocalSettings.php is in place

$wgUpgradeKey = "xyz";

## Default skin: you can change the default skin. Use the internal symbolic

## names, ie 'cologneblue', 'monobook', 'vector':

$wgDefaultSkin = "vector";

## For attaching licensing metadata to pages, and displaying an

## appropriate copyright notice / icon. GNU Free Documentation

## License and Creative Commons licenses are supported so far.

$wgRightsPage = ""; # Set to the title of a wiki page that describes your license/copyright

$wgRightsUrl = "";

$wgRightsText = "";

$wgRightsIcon = "";

# Path to the GNU diff3 utility. Used for conflict resolution.

$wgDiff3 = "";

# The following permissions were set based on your choice in the installer

$wgGroupPermissions['*']['createaccount'] = true;

$wgGroupPermissions['*']['edit'] = false;

$wgGroupPermissions['*']['read'] = false;

## $wgGroupPermissions['sysop']['createaccount'] = true;

$wgGroupPermissions['user' ]['edit'] = true;

$wgGroupPermissions['user' ]['read'] = true;

$wgWhitelistRead = array ("Spezial:Userlogin");

# Enabled Extensions. Most extensions are enabled by including the base extension file here

# but check specific extension documentation for more details

# The following extensions were automatically enabled:

wfLoadSkin( 'Vector' );

wfLoadSkin( 'MonoBook' );

wfLoadSkin( 'Modern' );

wfLoadSkin( 'CologneBlue' );

wfLoadExtension( 'Cite' );

## wfLoadExtension( 'ConfirmAccount' );

## wfLoadExtension( 'ConfirmEdit' );

wfLoadExtension( 'ImageMap' );

wfLoadExtension( 'InputBox' );

## wfLoadExtension( 'Interwiki' );

## wfLoadExtension( 'PdfHandler' );

## wfLoadExtension( 'Renameuser' );

## wfLoadExtension( 'TitleBlacklist' );

##require_once "$IP/extensions/ConfirmAccount/ConfirmAccount.php";

require_once "$IP/extensions/ConfirmEdit/ConfirmEdit.php";

require_once "$IP/extensions/Interwiki/Interwiki.php";

require_once "$IP/extensions/PdfHandler/PdfHandler.php";

require_once "$IP/extensions/Renameuser/Renameuser.php";

require_once "$IP/extensions/TitleBlacklist/TitleBlacklist.php";

#require_once "$IP/extensions/UniversalLanguageSelector/UniversalLanguageSelector.php";

wfLoadExtension( 'Babel' );

wfLoadExtension( 'cldr' );

wfLoadExtension( 'CleanChanges' );

$wgCCTrailerFilter = true;

$wgCCUserFilter = false;

$wgDefaultUserOptions['usenewrc'] = 1;

wfLoadExtension( 'LocalisationUpdate' );

$wgLocalisationUpdateDirectory = "$IP/cache";

require_once "$IP/extensions/Translate/Translate.php";

$wgGroupPermissions['user']['translate'] = true;

$wgGroupPermissions['user']['translate-messagereview'] = true;

$wgGroupPermissions['user']['translate-groupreview'] = true;

$wgGroupPermissions['user']['translate-import'] = true;

$wgGroupPermissions['sysop']['pagetranslation'] = true;

$wgGroupPermissions['sysop']['translate-manage'] = true;

$wgTranslateDocumentationLanguageCode = 'qqq';

$wgExtraLanguageNames['qqq'] = 'Message documentation'; # No linguistic content. Used for documenting messages

wfLoadExtension( 'UniversalLanguageSelector' );

$wgShowExceptionDetails = true;

# End of automatically generated settings.

# Add more configuration options below.

87.123.46.29 (talkcontribs)

MediaWiki 1.27.0 has not yet been released. What you are running is a beta or a release candidate version. Using such versions in production is not recommended.

Your error message soounds like the user is not allowed to view the create account page. Since your wiki has reading restrictions for anonymous users, you should update the value of $wgWhitelistRead to allow people to access the create account page.

Pingopilot (talkcontribs)

Please how can I update this value? Thanks

87.123.20.42 (talkcontribs)

You can change it in LocalSetings.php. You already have it in that file! E.g. changing it to

$wgWhitelistRead = array ("Spezial:Userlogin", "MediaWiki:Common.css");

would allow anonymous users to also access the MediaWiki:Common.css wiki page in your wiki...

Reply to "After Update from 1.26.3 to 1.27.0 user cannot create a new account as before"
TraaBBIT (talkcontribs)

Hello.

I installed Extension:QuestyCaptcha and added code to LocalSettings.php:

require_once( "$IP/extensions/ConfirmEdit/ConfirmEdit.php" ); require_once( "$IP/extensions/ConfirmEdit/QuestyCaptcha.php"); $wgCaptchaClass = 'QuestyCaptcha'; $arr = array (	"A question?" => "An answer!",	"What is this wiki's name?" => "$wgSitename",	'Please write the magic secret, "passion", here:' => 'passion',	'Type the code word, 567, here:' => '567',	'Which animal? <img src="http://www.mysite.com/dog.jpg" alt="" title="" />' => 'dog', ); foreach ( $arr as $key => $value ) {	$wgCaptchaQuestions[] = array( 'question' => $key, 'answer' => $value ); }

But there is still no CAPTHA on my registration page:

http://westeros.com.pl/index.php?title=Specjalna:Zaloguj&type=signup&returnto=Strona+g%C5%82%C3%B3wna

87.123.54.5 (talkcontribs)

You need $wgCaptchaTriggers['create'] = true; in LocalSettings.php.

See Extension:ConfirmEdit for details!

TraaBBIT (talkcontribs)

I added $wgCaptchaTriggers['create'] = true; to LocalSettings.php and still nothing.

TraaBBIT (talkcontribs)

I added to my LocallSettings.php this code:

$wgCaptchaTriggers['createaccount'] = true;

but on registration page I get:

Warning: class_parents(): object or string expected in /home/budrysl2/domains/westeros.com.pl/public_html/extensions/ConfirmEdit/includes/CaptchaStore.php on line 45 Warning: in_array() expects parameter 2 to be array, boolean given in /home/budrysl2/domains/westeros.com.pl/public_html/extensions/ConfirmEdit/includes/CaptchaStore.php on line 45 Exception encountered, of type "Exception"

TraaBBIT (talkcontribs)

Nobody?

87.123.1.191 (talkcontribs)

This error is happening, because class_parents( $wgCaptchaStorageClass ) is not an array. The code however expects it to be one. Interstingly there is an else block, which should catch exceptions with regards to wrong values here, but in this case, it does not kick in.

$wgCaptchaStorageClass is not documented at Extension:ConfirmEdit. From reading the code, the correct value for $wgCaptchaStorageClass is

$wgCaptchaStorageClass = 'CaptchaSessionStore';

I don't know, if you have that value set already or if you in your case maybe need a diferent one, but that is as far as I could get.

TraaBBIT (talkcontribs)

Thank You.

Now I'm updating MW to 1.26. Then I will work on that captcha

Reply to "Still no CAPTCHA"

Language Extension Bundle is not working with 1.27.0

6
Pingopilot (talkcontribs)

I installed it as described (MediaWiki Language Extension Bundle#extensions in subdirectory) and get following errors (I did not try it 1.26.3):

after running the update.php (I tried it 3 times, same error):

MediaWiki 1.27.0-rc.0 Updater

Your composer.lock file is up to date with current dependencies!

[8a520918622b2ebe920dda28] [no req] MWException from line 612 of /volume1/web/MediaWiki/includes/db/Database.php: DatabaseBase::factory no viable database extension found for type 'mysql'

Backtrace:

#0 /volume1/web/MediaWiki/includes/db/loadbalancer/LoadBalancer.php(828): DatabaseBase::factory(string, array)

#1 /volume1/web/MediaWiki/includes/db/loadbalancer/LoadBalancer.php(681): LoadBalancer->reallyOpenConnection(array, boolean)

#2 /volume1/web/MediaWiki/includes/db/loadbalancer/LoadBalancer.php(561): LoadBalancer->openConnection(integer, boolean)

#3 /volume1/web/MediaWiki/includes/GlobalFunctions.php(3155): LoadBalancer->getConnection(integer, array, boolean)

#4 /volume1/web/MediaWiki/maintenance/Maintenance.php(1156): wfGetDB(integer, array, boolean)

#5 /volume1/web/MediaWiki/maintenance/update.php(152): Maintenance->getDB(integer)

#6 /volume1/web/MediaWiki/maintenance/doMaintenance.php(103): UpdateMediaWiki->execute()

#7 /volume1/web/MediaWiki/maintenance/update.php(224): require_once(string)

#8 {main}

when I then try to load my Wiki-Pages, I get following errors:

error_reporting(-1); ini_set('display_errors', 1); MediaWiki internal error.

Original exception: [c7f6fa4cea2419dd7eea0cd9] /MediaWiki/index.php?title=Spezial%3ABenutzer&username=&group=&creationSort=1&limit=50 DBQueryError from line 934 of /volume1/web/MediaWiki/includes/db/Database.php: A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script

Query: SELECT rt_page FROM `revtag`,`page` WHERE (rt_page = page_id) AND (rt_revision = page_latest) AND rt_type IN ('tp:mark','tp:tag') GROUP BY rt_page 

Function: TranslatablePage::getTranslatablePages

Error: 1146 Table 'Luithlen_Wiki.revtag' doesn't exist (localhost)

Backtrace:

#0 /volume1/web/MediaWiki/includes/db/Database.php(901): DatabaseBase->reportQueryError(string, integer, string, string, boolean)

#1 /volume1/web/MediaWiki/includes/db/Database.php(1234): DatabaseBase->query(string, string)

#2 /volume1/web/MediaWiki/extensions/Translate/tag/TranslatablePage.php(867): DatabaseBase->select(array, string, array, string, array)

#3 /volume1/web/MediaWiki/extensions/Translate/tag/TranslatablePage.php(845): TranslatablePage::getTranslatablePages()

#4 /volume1/web/MediaWiki/extensions/Translate/tag/PageTranslationHooks.php(832): TranslatablePage::isSourcePage(Title)

#5 [internal function]: PageTranslationHooks::replaceSubtitle(string, SkinVector, OutputPage)

#6 /volume1/web/MediaWiki/includes/Hooks.php(195): call_user_func_array(string, array)

#7 /volume1/web/MediaWiki/includes/skins/Skin.php(658): Hooks::run(string, array)

#8 /volume1/web/MediaWiki/includes/skins/SkinTemplate.php(312): Skin->subPageSubtitle()

#9 /volume1/web/MediaWiki/includes/skins/SkinTemplate.php(246): SkinTemplate->prepareQuickTemplate(OutputPage)

#10 /volume1/web/MediaWiki/includes/OutputPage.php(2324): SkinTemplate->outputPage()

#11 /volume1/web/MediaWiki/includes/MediaWiki.php(753): OutputPage->output()

#12 /volume1/web/MediaWiki/includes/MediaWiki.php(519): MediaWiki->main()

#13 /volume1/web/MediaWiki/index.php(43): MediaWiki->run()

#14 {main}

Exception caught inside exception handler: [c7f6fa4cea2419dd7eea0cd9] /MediaWiki/index.php?title=Spezial%3ABenutzer&username=&group=&creationSort=1&limit=50 DBQueryError from line 934 of /volume1/web/MediaWiki/includes/db/Database.php: A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script

Query: SELECT rt_page FROM `revtag`,`page` WHERE (rt_page = page_id) AND (rt_revision = page_latest) AND rt_type IN ('tp:mark','tp:tag') GROUP BY rt_page 

Function: TranslatablePage::getTranslatablePages

Error: 1146 Table 'Luithlen_Wiki.revtag' doesn't exist (localhost)

Backtrace:

#0 /volume1/web/MediaWiki/includes/db/Database.php(901): DatabaseBase->reportQueryError(string, integer, string, string, boolean)

#1 /volume1/web/MediaWiki/includes/db/Database.php(1234): DatabaseBase->query(string, string)

#2 /volume1/web/MediaWiki/extensions/Translate/tag/TranslatablePage.php(867): DatabaseBase->select(array, string, array, string, array)

#3 /volume1/web/MediaWiki/extensions/Translate/tag/TranslatablePage.php(845): TranslatablePage::getTranslatablePages()

#4 /volume1/web/MediaWiki/extensions/Translate/tag/PageTranslationHooks.php(832): TranslatablePage::isSourcePage(Title)

#5 [internal function]: PageTranslationHooks::replaceSubtitle(string, SkinVector, OutputPage)

#6 /volume1/web/MediaWiki/includes/Hooks.php(195): call_user_func_array(string, array)

#7 /volume1/web/MediaWiki/includes/skins/Skin.php(658): Hooks::run(string, array)

#8 /volume1/web/MediaWiki/includes/skins/SkinTemplate.php(312): Skin->subPageSubtitle()

#9 /volume1/web/MediaWiki/includes/skins/SkinTemplate.php(246): SkinTemplate->prepareQuickTemplate(OutputPage)

#10 /volume1/web/MediaWiki/includes/OutputPage.php(2324): SkinTemplate->outputPage()

#11 /volume1/web/MediaWiki/includes/exception/MWException.php(204): OutputPage->output()

#12 /volume1/web/MediaWiki/includes/exception/MWException.php(244): MWException->reportHTML()

#13 /volume1/web/MediaWiki/includes/exception/MWExceptionHandler.php(69): MWException->report()

#14 /volume1/web/MediaWiki/includes/exception/MWExceptionHandler.php(180): MWExceptionHandler::report(DBQueryError)

#15 /volume1/web/MediaWiki/includes/MediaWiki.php(528): MWExceptionHandler::handleException(DBQueryError)

#16 /volume1/web/MediaWiki/index.php(43): MediaWiki->run()

#17 {main}

my Loacalsettings.php:

error_reporting(-1);

ini_set('display_errors', 1);

<?php

# This file was automatically generated by the MediaWiki 1.23.13

# installer. If you make manual changes, please keep track in case you

# need to recreate them later.

#

# See includes/DefaultSettings.php for all configurable settings

# and their default values, but don't forget to make changes in _this_

# file, not there.

#

# Further documentation for configuration settings may be found at:

# https://www.mediawiki.org/wiki/Manual:Configuration_settings

# Protect against web entry

if ( !defined( 'MEDIAWIKI' ) ) {

exit;

}

## Uncomment this to disable output compression

# $wgDisableOutputCompression = true;

$wgSitename = "Luithlen Wiki";

$wgMetaNamespace = "Luithlen_Wiki";

## The URL base path to the directory containing the wiki;

## defaults for all runtime URL paths are based off of this.

## For more information on customizing the URLs

## (like /w/index.php/Page_title to /wiki/Page_title) please see:

## https://www.mediawiki.org/wiki/Manual:Short_URL

$wgScriptPath = "/MediaWiki";

$wgScriptExtension = ".php";

## The protocol and server name to use in fully-qualified URLs

$wgServer = "https://xyz.org";

## The relative URL path to the skins directory

$wgStylePath = "$wgScriptPath/skins";

## The relative URL path to the logo. Make sure you change this from the default,

## or else you'll overwrite your logo when you upgrade!

$wgLogo = "{$wgScriptPath}/LuithlenEltern.jpg";

## UPO means: this is also a user preference option

$wgEnableEmail = true;

$wgEnableUserEmail = true; # UPO

$wgEmergencyContact = "xyz@gmx.de";

$wgPasswordSender = "xyz@gmx.de";

$wgEnotifUserTalk = true; # UPO

$wgEnotifWatchlist = false; # UPO

$wgEmailAuthentication = true;

## Database settings

$wgDBtype = "mysql";

$wgDBserver = "localhost";

$wgDBname = "Luithlen_Wiki";

$wgDBuser = "Ingo";

$wgDBpassword = "xyz";

# MySQL specific settings

$wgDBprefix = "";

# MySQL table options to use during installation or update

$wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=utf8";

# Experimental charset support for MySQL 5.0.

$wgDBmysql5 = false;

## Shared memory settings

$wgMainCacheType = CACHE_NONE;

$wgMemCachedServers = array();

## To enable image uploads, make sure the 'images' directory

## is writable, then set this to true:

$wgEnableUploads = true;

#$wgUseImageMagick = true;

#$wgImageMagickConvertCommand = "/usr/bin/convert";

# InstantCommons allows wiki to use images from http://commons.wikimedia.org

$wgUseInstantCommons = false;

## If you use ImageMagick (or any other shell command) on a

## Linux server, this will need to be set to the name of an

## available UTF-8 locale

$wgShellLocale = "en_US.utf8";

## If you want to use image uploads under safe mode,

## create the directories images/archive, images/thumb and

## images/temp, and make them all writable. Then uncomment

## this, if it's not already uncommented:

#$wgHashedUploadDirectory = false;

## Set $wgCacheDirectory to a writable directory on the web server

## to make your wiki go slightly faster. The directory should not

## be publically accessible from the web.

#$wgCacheDirectory = "$IP/cache";

# Site language code, should be one of the list in ./languages/Names.php

$wgLanguageCode = "de";

$wgSecretKey = "xyz";

# Site upgrade key. Must be set to a string (default provided) to turn on the

# web installer while LocalSettings.php is in place

$wgUpgradeKey = "xyz";

## Default skin: you can change the default skin. Use the internal symbolic

## names, ie 'cologneblue', 'monobook', 'vector':

$wgDefaultSkin = "vector";

## For attaching licensing metadata to pages, and displaying an

## appropriate copyright notice / icon. GNU Free Documentation

## License and Creative Commons licenses are supported so far.

$wgRightsPage = ""; # Set to the title of a wiki page that describes your license/copyright

$wgRightsUrl = "";

$wgRightsText = "";

$wgRightsIcon = "";

# Path to the GNU diff3 utility. Used for conflict resolution.

$wgDiff3 = "";

# The following permissions were set based on your choice in the installer

$wgGroupPermissions['*']['createaccount'] = true;

$wgGroupPermissions['*']['edit'] = false;

$wgGroupPermissions['*']['read'] = false;

## $wgGroupPermissions['sysop']['createaccount'] = true;

$wgGroupPermissions['user' ]['edit'] = true;

$wgGroupPermissions['user' ]['read'] = true;

$wgWhitelistRead = array ("Spezial:Userlogin");

# Enabled Extensions. Most extensions are enabled by including the base extension file here

# but check specific extension documentation for more details

# The following extensions were automatically enabled:

wfLoadSkin( 'Vector' );

wfLoadSkin( 'MonoBook' );

wfLoadSkin( 'Modern' );

wfLoadSkin( 'CologneBlue' );

wfLoadExtension( 'Cite' );

## wfLoadExtension( 'ConfirmAccount' );

## wfLoadExtension( 'ConfirmEdit' );

wfLoadExtension( 'ImageMap' );

wfLoadExtension( 'InputBox' );

## wfLoadExtension( 'Interwiki' );

## wfLoadExtension( 'PdfHandler' );

## wfLoadExtension( 'Renameuser' );

## wfLoadExtension( 'TitleBlacklist' );

##require_once "$IP/extensions/ConfirmAccount/ConfirmAccount.php";

require_once "$IP/extensions/ConfirmEdit/ConfirmEdit.php";

require_once "$IP/extensions/Interwiki/Interwiki.php";

require_once "$IP/extensions/PdfHandler/PdfHandler.php";

require_once "$IP/extensions/Renameuser/Renameuser.php";

require_once "$IP/extensions/TitleBlacklist/TitleBlacklist.php";

#require_once "$IP/extensions/UniversalLanguageSelector/UniversalLanguageSelector.php";

wfLoadExtension( 'Babel' );

wfLoadExtension( 'cldr' );

wfLoadExtension( 'CleanChanges' );

$wgCCTrailerFilter = true;

$wgCCUserFilter = false;

$wgDefaultUserOptions['usenewrc'] = 1;

wfLoadExtension( 'LocalisationUpdate' );

$wgLocalisationUpdateDirectory = "$IP/cache";

require_once "$IP/extensions/Translate/Translate.php";

$wgGroupPermissions['user']['translate'] = true;

$wgGroupPermissions['user']['translate-messagereview'] = true;

$wgGroupPermissions['user']['translate-groupreview'] = true;

$wgGroupPermissions['user']['translate-import'] = true;

$wgGroupPermissions['sysop']['pagetranslation'] = true;

$wgGroupPermissions['sysop']['translate-manage'] = true;

$wgTranslateDocumentationLanguageCode = 'qqq';

$wgExtraLanguageNames['qqq'] = 'Message documentation'; # No linguistic content. Used for documenting messages

wfLoadExtension( 'UniversalLanguageSelector' );

$wgShowExceptionDetails = true;

# End of automatically generated settings.

# Add more configuration options below.

Thanks for help!

87.123.46.29 (talkcontribs)

The error "DatabaseBase::factory no viable database extension found for type 'mysql'" happens, because you have selected MySQL as database, but obviously MySQL is not available in your environment. This happens when PHP does not feature MySQL support. Make sure to activate MySQL support in PHP; I guess it is installing a PHP module (e.g. called "php5-mysql") and restarting the server or compiling PHP again with the module.

87.123.46.29 (talkcontribs)

Accessing your webserver with a browser and with a shell are two different things. When you access your webserver with a browser, you can see one PHP version, while on the shell you see another one.

Ciencia Al Poder (talkcontribs)

Not necessarily a different php version, but a different php.ini configuration file. Your server has probably 2 php.ini files, one for webserver and other for command line, and the command line one may not have the mysql extension enabled on it.

Pingopilot (talkcontribs)

MySQL support should be available, because it's working for my Wiki and my TNG Server.

What makes it difficult: all is running on a Synology NAS Server with following packages installed:

MariaDB

MediaWiki

PHP 5.6

phpMyAdmin

How can I adjust the command line php.ini file? Where to find this file?

Other Workaround: That means I have to launch update.php via the direct http://...adress? (just add the directory,...)

Ciencia Al Poder (talkcontribs)

Use php --ini from the command line to see where php,ini is located.

Reply to "Language Extension Bundle is not working with 1.27.0"

Navigation menu

Personal tools

Variants

Views

More

In other languages

Morty Proxy This is a proxified and sanitized view of the page, visit original site.