Manual talk:L10n cache table

done, thanks.

https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/%2B/master/includes/cache/localisation/LCStoreDB.php <- no longer exists please correct or delete if not actual. Thanks. --Christian 🇫🇷 FR ⛹🏽 Paris 2024🗼 (talk) 18:37, 12 August 2024 (UTC)

Fixed

After creating a new wiki, copying the <wiki>.sqlite file, going through the wizard, and copying the new LocalSettings.php file, I get the error in the subject when I open the wiki in the browser.

So it seems the table doesn't get generated on demand? Using MW 1.36.2. The full trace is:

Function: LCStoreDB::get

Query: SELECT lc_value FROM l10n_cache WHERE lc_lang = 'he' AND lc_key = 'deps' LIMIT 1

Backtrace:

from /var/www/html/includes/libs/rdbms/database/Database.php(1719)

#0 /var/www/html/includes/libs/rdbms/database/Database.php(1703): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)

#1 /var/www/html/includes/libs/rdbms/database/Database.php(1678): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#2 /var/www/html/includes/libs/rdbms/database/Database.php(1244): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#3 /var/www/html/includes/libs/rdbms/database/Database.php(1929): Wikimedia\Rdbms\Database->query(string, string, integer)

#4 /var/www/html/includes/libs/rdbms/database/Database.php(1768): Wikimedia\Rdbms\Database->select(string, string, array, string, array, array)

#5 /var/www/html/includes/cache/localisation/LCStoreDB.php(63): Wikimedia\Rdbms\Database->selectField(string, string, array, string)

#6 /var/www/html/includes/cache/localisation/LocalisationCache.php(448): LCStoreDB->get(string, string)

#7 /var/www/html/includes/cache/localisation/LocalisationCache.php(494): LocalisationCache->isExpired(string)

#8 /var/www/html/includes/cache/localisation/LocalisationCache.php(370): LocalisationCache->initLanguage(string)

#9 /var/www/html/includes/cache/localisation/LocalisationCache.php(311): LocalisationCache->loadItem(string, string)

#10 /var/www/html/includes/language/LanguageFallback.php(106): LocalisationCache->getItem(string, string)

#11 /var/www/html/includes/language/LanguageFactory.php(175): MediaWiki\Languages\LanguageFallback->getAll(string)

#12 /var/www/html/includes/language/LanguageFactory.php(121): MediaWiki\Languages\LanguageFactory->newFromCode(string)

#13 /var/www/html/includes/ServiceWiring.php(311): MediaWiki\Languages\LanguageFactory->getLanguage(string)

#14 /var/www/html/vendor/wikimedia/services/src/ServiceContainer.php(447): Wikimedia\Services\ServiceContainer::{closure}(MediaWiki\MediaWikiServices)

#15 /var/www/html/vendor/wikimedia/services/src/ServiceContainer.php(416): Wikimedia\Services\ServiceContainer->createService(string)

#16 /var/www/html/includes/MediaWikiServices.php(264): Wikimedia\Services\ServiceContainer->getService(string)

#17 /var/www/html/includes/MediaWikiServices.php(730): MediaWiki\MediaWikiServices->getService(string)

#18 /var/www/html/includes/Setup.php(751): MediaWiki\MediaWikiServices->getContentLanguage()

#19 /var/www/html/includes/WebStart.php(87): require_once(string)

#20 /var/www/html/index.php(44): require(string)

#21 {main}

Try running Update.php. Hopefully it will create the necessary table.

Otherwise, I'd just advice storing the l10n cache in files instead of the database (see $wgLocalisationCacheConf), specially when you use sqlite as the backend, since sqlite will slow things even more.

I did. It creates an empty file and the same error happens.

Try to create the table manually via SQL in phpmyadmin.