I tried to run parserTests on the latest version in Trunk (r53382). However, I get the following error:
A database error has occurred Query: SELECT lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.mw_l10n_cache' doesn't exist (localhost)
Since I can run the tests on 1.16a (r52088), this suggests there is a database schema change contemplated between 1.16a and REL1_16. Is this correct? If so, how do I update my database to conform to the new schema?
On Thu, Jul 16, 2009 at 6:25 PM, dan nessettdnessett@yahoo.com wrote:
I tried to run parserTests on the latest version in Trunk (r53382). However, I get the following error:
A database error has occurred Query: SELECT lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.mw_l10n_cache' doesn't exist (localhost)
Since I can run the tests on 1.16a (r52088), this suggests there is a database schema change contemplated between 1.16a and REL1_16. Is this correct? If so, how do I update my database to conform to the new schema?
You need to run maintenance/update.php every time you upgrade the software. This will apply schema changes, mostly, as well as anything else that happens to be necessary. Running it when you don't need to is harmless, so if you want to be on the safe side you could run it on every svn up.
Thanks. Just so I completely understand, update.php will not affect the use of the underlying database by my personal wiki installation, which uses 1.14 (as opposed to the test wikis I will work on during development), right?
--- On Thu, 7/16/09, Aryeh Gregor Simetrical+wikilist@gmail.com wrote:
From: Aryeh Gregor Simetrical+wikilist@gmail.com Subject: Re: [Wikitech-l] database schema error To: "Wikimedia developers" wikitech-l@lists.wikimedia.org Date: Thursday, July 16, 2009, 5:20 PM On Thu, Jul 16, 2009 at 6:25 PM, dan nessettdnessett@yahoo.com wrote:
I tried to run parserTests on the latest version in
Trunk (r53382). However, I get the following error:
A database error has occurred Query: SELECT lc_value FROM `mw_l10n_cache`
WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1
Function: LCStore_DB::get Error: 1146 Table 'wikidb.mw_l10n_cache' doesn't exist
(localhost)
Since I can run the tests on 1.16a (r52088), this
suggests there is a database schema change contemplated between 1.16a and REL1_16. Is this correct? If so, how do I update my database to conform to the new schema?
You need to run maintenance/update.php every time you upgrade the software. This will apply schema changes, mostly, as well as anything else that happens to be necessary. Running it when you don't need to is harmless, so if you want to be on the safe side you could run it on every svn up.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
On Thu, Jul 16, 2009 at 9:03 PM, dan nessettdnessett@yahoo.com wrote:
Thanks. Just so I completely understand, update.php will not affect the use of the underlying database by my personal wiki installation, which uses 1.14 (as opposed to the test wikis I will work on during development), right?
It will use whatever the database settings are for the wiki you use it on. Whatever wiki you run it on, it will update the database for that wiki to match the version of the files for that wiki, so leaving aside pathological cases like an installation with files from multiple versions, it should always be harmless at worst. (Unless you want to downgrade, which isn't a supported operation.)
wikitech-l@lists.wikimedia.org