Topic on Project:Support desk

Fatal exception of type Wikimedia\Rdbms\DBQueryError after update upto 1.29.2

Ektip (talkcontribs)

Update mediawiki from 1.21 to 1.29.2 using web-interface.

Now i have error - [05575cfedebae9daa0d54bb3] 2017-11-18 21:45:24: Fatal exception of type Wikimedia\Rdbms\DBQueryError

Please advice.

星耀晨曦 (talkcontribs)

You should open debug options for more detailed error messages

$wgShowExceptionDetails = true;
$wgShowDBErrorBacktrace = true;
$wgShowSQLErrors = true;
Ektip (talkcontribs)

Here is:

[2cf16b067a21c4921aa451b1] / Wikimedia\Rdbms\DBQueryError from line 1075 of /home/httpd/vhosts/ A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 
Function: LCStoreDB::get
Error: 1146 Table 'a201591_wikiek.l10n_cache' doesn't exist (

#0 /home/httpd/vhosts/ Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#1 /home/httpd/vhosts/ Wikimedia\Rdbms\Database->query(string, string)
#2 /home/httpd/vhosts/ Wikimedia\Rdbms\Database->select(string, string, array, string, array)
#3 /home/httpd/vhosts/ Wikimedia\Rdbms\Database->selectField(string, string, array, string)
#4 /home/httpd/vhosts/ LCStoreDB->get(string, string)
#5 /home/httpd/vhosts/ LocalisationCache->isExpired(string)
#6 /home/httpd/vhosts/ LocalisationCache->initLanguage(string)
#7 /home/httpd/vhosts/ LocalisationCache->loadSubitem(string, string, string)
#8 /home/httpd/vhosts/ LocalisationCache->getSubitem(string, string, string)
#9 /home/httpd/vhosts/ Language->getMessage(string)
#10 /home/httpd/vhosts/ MessageCache->getMessageForLang(Language, string, boolean, array)
#11 /home/httpd/vhosts/ MessageCache->getMessageFromFallbackChain(Language, string, boolean)
#12 /home/httpd/vhosts/ MessageCache->get(string, boolean, Language)
#13 /home/httpd/vhosts/ Message->fetchMessage()
#14 /home/httpd/vhosts/ Message->toString(string)
#15 /home/httpd/vhosts/ Message->text()
#16 /home/httpd/vhosts/ MalformedTitleException->__construct(string, string)
#17 /home/httpd/vhosts/ MediaWikiTitleCodec->splitTitleString(string, integer)
#18 /home/httpd/vhosts/ Title->secureAndSplit()
#19 /home/httpd/vhosts/ Title::newFromURL(NULL)
#20 /home/httpd/vhosts/ MediaWiki->parseTitle()
#21 /home/httpd/vhosts/ MediaWiki->getTitle()
#22 /home/httpd/vhosts/ MediaWiki->main()
#23 /home/httpd/vhosts/ MediaWiki->run()
#24 {main}
Ektip (talkcontribs)


AhmadF.Cheema (talkcontribs)
2003:CC:ABE4:6400:19F2:D209:921:4DC9 (talkcontribs)
Bawolff (talkcontribs)

Update.php (or the web updater by going to ) will add the table for you, so there is no need to add it manually.

However, this table has been included since MediaWiki 1.16, so unless you are upgrading from pre-1.16, this means that random tables are disappearing from your db. That generally is very bad and you should figure out how that happened.

Jörgi123 (talkcontribs)

But isn't update.php using the different patch files, which always contain only a small chunk of the complete table structure? Does it really also add tables, which should already have been there?

Bawolff (talkcontribs)

It adds tables that should be there provided they were introduced after MediaWiki 1.5 (The update script doesn't know if the table is "missing" or if you are just upgrading from a really really old version of MediaWiki).

So it will work for l10n_cache table. It wouldn't work for say the querycache table