Topic on Project:Support desk

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.

You should open debug options for more detailed error messages

$wgShowExceptionDetails = true;
$wgShowDBErrorBacktrace = true;
$wgShowSQLErrors = true;

Here is:

[2cf16b067a21c4921aa451b1] / Wikimedia\Rdbms\DBQueryError from line 1075 of /home/httpd/vhosts/wiki.ektip.ru/httpdocs/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? 
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 (a201591.mysql.mchost.ru)
Backtrace:

#0 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#1 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/libs/rdbms/database/Database.php(1269): Wikimedia\Rdbms\Database->query(string, string)
#2 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/libs/rdbms/database/Database.php(1095): Wikimedia\Rdbms\Database->select(string, string, array, string, array)
#3 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/localisation/LCStoreDB.php(53): Wikimedia\Rdbms\Database->selectField(string, string, array, string)
#4 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/localisation/LocalisationCache.php(414): LCStoreDB->get(string, string)
#5 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/localisation/LocalisationCache.php(460): LocalisationCache->isExpired(string)
#6 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/localisation/LocalisationCache.php(379): LocalisationCache->initLanguage(string)
#7 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/localisation/LocalisationCache.php(294): LocalisationCache->loadSubitem(string, string, string)
#8 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/languages/Language.php(2582): LocalisationCache->getSubitem(string, string, string)
#9 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/MessageCache.php(918): Language->getMessage(string)
#10 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/MessageCache.php(873): MessageCache->getMessageForLang(Language, string, boolean, array)
#11 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/cache/MessageCache.php(814): MessageCache->getMessageFromFallbackChain(Language, string, boolean)
#12 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/Message.php(1275): MessageCache->get(string, boolean, Language)
#13 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/Message.php(842): Message->fetchMessage()
#14 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/Message.php(934): Message->toString(string)
#15 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/title/MalformedTitleException.php(49): Message->text()
#16 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/title/MediaWikiTitleCodec.php(312): MalformedTitleException->__construct(string, string)
#17 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/Title.php(3415): MediaWikiTitleCodec->splitTitleString(string, integer)
#18 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/Title.php(355): Title->secureAndSplit()
#19 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/MediaWiki.php(84): Title::newFromURL(NULL)
#20 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/MediaWiki.php(140): MediaWiki->parseTitle()
#21 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/MediaWiki.php(777): MediaWiki->getTitle()
#22 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/includes/MediaWiki.php(523): MediaWiki->main()
#23 /home/httpd/vhosts/wiki.ektip.ru/httpdocs/index.php(43): MediaWiki->run()
#24 {main}

'

You will need to run Update.php.

The database table l10n_cache is missing n your database. This is the problem.

According to Manual:Database_layout this table should already have been there, when you used MediaWiki 1.21. You might have to add this table manually by looking into the tables.sql file: https://github.com/wikimedia/mediawiki/blob/REL1_29/maintenance/tables.sql#L1533

Update.php (or the web updater by going to mywiki.com/w/mw-config ) 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.

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?

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

In my case, what should i do?

MediaWiki internal error.

Original exception: [a31016cf1565473645eb2172] /index.php Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'my_wiki.l10n_cache' doesn't exist Function: LCStoreDB::get Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1

Backtrace: from /var/www/html/includes/libs/rdbms/database/Database.php(1236)

1. 0 /var/www/html/includes/libs/rdbms/database/Database.php(1220): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
2. 1 /var/www/html/includes/libs/rdbms/database/Database.php(1194): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
3. 2 /var/www/html/includes/libs/rdbms/database/Database.php(679): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
4. 3 /var/www/html/includes/libs/rdbms/database/Database.php(1383): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
5. 4 /var/www/html/includes/libs/rdbms/database/Database.php(1334): Wikimedia\Rdbms\Database->select(array, string, array, string, array, array)
6. 5 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->selectField(array, string, array, string, array, array)
7. 6 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(338): Wikimedia\Rdbms\DBConnRef->__call(string, array)
8. 7 /var/www/html/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(726): Wikimedia\Rdbms\DBConnRef->selectField(array, string, array, string, array, array)
9. 8 /var/www/html/includes/language/LCStoreDB.php(65): Wikimedia\Rdbms\SelectQueryBuilder->fetchField()
10. 9 /var/www/html/includes/language/LocalisationCache.php(559): LCStoreDB->get(string, string)
11. 10 /var/www/html/includes/language/LocalisationCache.php(606): LocalisationCache->isExpired(string)
12. 11 /var/www/html/includes/language/LocalisationCache.php(516): LocalisationCache->initLanguage(string)
13. 12 /var/www/html/includes/language/LocalisationCache.php(396): LocalisationCache->loadSubitem(string, string, string)
14. 13 /var/www/html/includes/language/LocalisationCache.php(412): LocalisationCache->getSubitem(string, string, string)
15. 14 /var/www/html/includes/language/MessageCache.php(1235): LocalisationCache->getSubitemWithSource(string, string, string)
16. 15 /var/www/html/includes/language/MessageCache.php(1177): MessageCache->getMessageForLang(LanguageEn, string, boolean, array)
17. 16 /var/www/html/includes/language/MessageCache.php(1075): MessageCache->getMessageFromFallbackChain(LanguageEn, string, boolean)
18. 17 /var/www/html/includes/language/Message.php(1485): MessageCache->get(string, boolean, LanguageEn)
19. 18 /var/www/html/includes/language/Message.php(972): Message->fetchMessage()
20. 19 /var/www/html/includes/language/Message.php(1059): Message->format(string)
21. 20 /var/www/html/includes/title/MalformedTitleException.php(61): Message->text()
22. 21 /var/www/html/includes/title/MediaWikiTitleCodec.php(101): MediaWiki\Title\MalformedTitleException->__construct(string, string, array)
23. 22 /var/www/html/includes/title/MediaWikiTitleCodec.php(411): MediaWiki\Title\MediaWikiTitleCodec::MediaWiki\Title\{closure}(string, string)
24. 23 /var/www/html/includes/title/Title.php(2756): MediaWiki\Title\MediaWikiTitleCodec->splitTitleString(string, integer)
25. 24 /var/www/html/includes/title/Title.php(510): MediaWiki\Title\Title->secureAndSplit(string)
26. 25 /var/www/html/includes/MediaWiki.php(100): MediaWiki\Title\Title::newFromURL(string)
27. 26 /var/www/html/includes/MediaWiki.php(189): MediaWiki->parseTitle(MediaWiki\Request\WebRequest)
28. 27 /var/www/html/includes/MediaWiki.php(908): MediaWiki->getTitle()
29. 28 /var/www/html/includes/MediaWiki.php(613): MediaWiki->main()
30. 29 /var/www/html/index.php(50): MediaWiki->run()
31. 30 /var/www/html/index.php(46): wfIndexMain()
32. 31 {main}

Exception caught inside exception handler: [a31016cf1565473645eb2172] /index.php Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1146: Table 'my_wiki.page' doesn't exist Function: MessageCache::loadFromDB(en-gb)-big Query: SELECT page_title,page_latest FROM `page` WHERE page_is_redirect = 0 AND page_namespace = 8 AND (page_title NOT LIKE '%/%' ESCAPE '`' ) AND (page_len > 10000)

Backtrace: from /var/www/html/includes/libs/rdbms/database/Database.php(1236)

1. 0 /var/www/html/includes/libs/rdbms/database/Database.php(1220): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
2. 1 /var/www/html/includes/libs/rdbms/database/Database.php(1194): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
3. 2 /var/www/html/includes/libs/rdbms/database/Database.php(679): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
4. 3 /var/www/html/includes/libs/rdbms/database/Database.php(1383): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
5. 4 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
6. 5 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)
7. 6 /var/www/html/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(708): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
8. 7 /var/www/html/includes/language/MessageCache.php(606): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
9. 8 /var/www/html/includes/language/MessageCache.php(504): MessageCache->loadFromDB(string, NULL)
10. 9 /var/www/html/includes/language/MessageCache.php(421): MessageCache->loadFromDBWithMainLock(string, array, NULL)
11. 10 /var/www/html/includes/language/MessageCache.php(341): MessageCache->loadUnguarded(string, NULL)
12. 11 /var/www/html/includes/language/MessageCache.php(1301): MessageCache->load(string)
13. 12 /var/www/html/includes/language/MessageCache.php(1206): MessageCache->getMsgFromNamespace(string, string)
14. 13 /var/www/html/includes/language/MessageCache.php(1177): MessageCache->getMessageForLang(Language, string, boolean, array)
15. 14 /var/www/html/includes/language/MessageCache.php(1075): MessageCache->getMessageFromFallbackChain(Language, string, boolean)
16. 15 /var/www/html/includes/language/Message.php(1485): MessageCache->get(string, boolean, Language)
17. 16 /var/www/html/includes/language/Message.php(972): Message->fetchMessage()
18. 17 /var/www/html/includes/language/Message.php(1059): Message->format(string)
19. 18 /var/www/html/includes/exception/MWExceptionRenderer.php(254): Message->text()
20. 19 /var/www/html/includes/exception/MWExceptionRenderer.php(191): MWExceptionRenderer::msg(string, string)
21. 20 /var/www/html/includes/exception/MWExceptionRenderer.php(105): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)
22. 21 /var/www/html/includes/exception/MWExceptionHandler.php(134): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)
23. 22 /var/www/html/includes/exception/MWExceptionHandler.php(251): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)
24. 23 /var/www/html/includes/MediaWiki.php(632): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError, string)
25. 24 /var/www/html/index.php(50): MediaWiki->run()
26. 25 /var/www/html/index.php(46): wfIndexMain()
27. 26 {main}

Also, run `php update.php` inside /var/www/html/maintenance directory.

Required help...

Please start a new thread. It is unlikely your issue has the same cause as the other one reported here