[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 OverlordQ overlo...@gmail.com changed: What|Removed |Added Component|Templates |Database Summary|Warning: Parameter 1 to |Database update for |ExtParserFunctions::ifObj() |l10n_cache fails on non-EN |expected to be a reference, |installs |value given in | |/opt/local/apache2/htdocs/w/| |extensions/ParserFunctions/P| |arserFunctions.php on line | |122 | --- Comment #30 from OverlordQ overlo...@gmail.com 2009-12-06 14:49:24 UTC --- Please open new bugs for different issues and not change old unrelated bugs. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #29 from Søren Løvborg k...@kwi.dk 2009-07-22 19:49:10 UTC --- I can confirm that other extensions may also cause this problem. :-) (In my case, it was DynamicPageList. One of the forks, anyway. The names of those are confusing enough that I'm no longer quite sure which one we're running...) Since it's not immediately clear from the above discussion, I'd like to add: *The generic work-around for this problem is to disable all extensions while running update.php.* -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 Tim Starling tstarl...@wikimedia.org changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution||FIXED --- Comment #28 from Tim Starling tstarl...@wikimedia.org 2009-07-22 04:10:18 UTC --- It looks like the ProofreadPage bug was fixed by r53040. Reclosing. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 ThomasV thoma...@gmx.de changed: What|Removed |Added CC||thoma...@gmx.de --- Comment #25 from ThomasV thoma...@gmx.de 2009-07-07 15:51:19 UTC --- I have the same problem after updating at revision r52836 update.php fails with the following message : A database error has occurred Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost) it works if I create the table manually -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #22 from Martin Seidel jode...@gmx.de 2009-07-04 12:26:21 UTC --- my four steps to become a irrespondable wiki: 1. svn up 3. wiki not respondable, error: Database error A database error has occurred Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'de' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost) 2. $wgLanguageCode = en (suggested above, config is normaly de, but result is the same as with en) 4. php maintenance/update.php, error: A database error has occurred Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost) Only svn up --revision 52502 will fix these -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447
--- Comment #23 from jida...@jidanni.org 2009-07-04 22:51:48 UTC ---
(In reply to comment #22)
Everything's working fine for me now at revision level
$ GET
'http://radioscanningtw.jidanni.org/api.php?action=expandtemplatestext={{CURRENTVERSION}}format=yaml'
---
expandtemplates:
*: 1.16alpha(r52770)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #24 from Tim Starling tstarl...@wikimedia.org 2009-07-05 03:40:01 UTC --- (In reply to comment #19) As noted in bug 19491, for me at least, I only ran into the error when running update.php for the very first time. Subsequent runs of update.php, even after manually dropping table l10n_cache, succeeded. That's expected. You can recover your error by dropping l10n_cache, and also doing: DELETE FROM updatelog WHERE ul_key='populate category'; The wiki has to have at least one category to trigger the error, and it needs to use a language code with its own class to avoid the error from Language::factory() reported by Jidanni. It's fixed by r52730. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 Tim Starling tstarl...@wikimedia.org changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #15 from Tim Starling tstarl...@wikimedia.org 2009-07-03 06:57:05 UTC --- Fixed in r52730. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 Roan Kattouw roan.katt...@gmail.com changed: What|Removed |Added CC||jler...@gmail.com --- Comment #16 from Roan Kattouw roan.katt...@gmail.com 2009-07-03 09:33:59 UTC --- *** Bug 19491 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 Martin Seidel jode...@gmx.de changed: What|Removed |Added CC||jode...@gmx.de Status|RESOLVED|REOPENED Resolution|FIXED | --- Comment #17 from Martin Seidel jode...@gmx.de 2009-07-03 18:09:20 UTC --- seems not to be fixed: svn update -- succeeded (rev. 52749) A database error has occurred Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost) svn update --revision 52730 -- succeeded Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost) svn update --revision 52502 -- succeeded php maintenance/update.php MediaWiki 1.16alpha Updater [some output] Deleting old default messages (this may take a long time!)...Done Checking site_stats row...ok. Purging caches...done. Done. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #18 from OverlordQ overlo...@gmail.com 2009-07-03 19:23:08 UTC --- Works for me. Tried with both en, en_gb, and zh_tw language codes. MediaWiki 1.16alpha Updater Going to run database updates for wikidb Depending on the size of your database this may take a while! Abort with control-c in the next five seconds... 0 snip ... table user_properties already exists ... table log_search already exists Creating table l10n_cache ... obsolete table archive2 does not exist -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #19 from Joshua C. Lerner jler...@gmail.com 2009-07-03 19:27:57 UTC --- As noted in bug 19491, for me at least, I only ran into the error when running update.php for the very first time. Subsequent runs of update.php, even after manually dropping table l10n_cache, succeeded. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447
--- Comment #20 from OverlordQ overlo...@gmail.com 2009-07-03 19:50:01 UTC
---
I'd assume the updaters get ran in the order specified in the config, if this
assumption is wrong, the follow is false:
do_populate_parent_id get's called in the 1.13 section, but l10n isnt' created
until the 1.16 section.
These updaters dont seem to be defined for PG so I simulated by deleting the
l10n table, not run update.php but run populateCategory.php first. The
backtrace is similar as when running update.php:
==
A database error has occurred
Query: SELECT lc_value FROM l10n_cache WHERE lc_lang = 'en' AND lc_key =
'deps' LIMIT 1
Function: LCStore_DB::get
Error: 1 ERROR: relation l10n_cache does not exist
Backtrace:
#0 /var/www/mysite.com/wiki/includes/db/Database.php(502):
DatabasePostgres-reportQueryError('ERROR: relatio...', 1, 'SELECT
lc_valu...', 'LCStore_DB::get', false)
#1 /var/www/mysite.com/wiki/includes/db/Database.php(838):
DatabaseBase-query('SELECT lc_valu...', 'LCStore_DB::get')
#2 /var/www/mysite.com/wiki/includes/db/Database.php(918):
DatabaseBase-select('l10n_cache', Array, Array, 'LCStore_DB::get', Array,
Array)
#3 /var/www/mysite.com/wiki/includes/LocalisationCache.php(725):
DatabaseBase-selectRow('l10n_cache', Array, Array, 'LCStore_DB::get')
#4 /var/www/mysite.com/wiki/includes/LocalisationCache.php(299):
LCStore_DB-get('en', 'deps')
#5 /var/www/mysite.com/wiki/includes/LocalisationCache.php(324):
LocalisationCache-isExpired('en')
#6 /var/www/mysite.com/wiki/includes/LocalisationCache.php(242):
LocalisationCache-initLanguage('en')
#7 /var/www/mysite.com/wiki/includes/LocalisationCache.php(205):
LocalisationCache-loadItem('en', 'namespaceNames')
#8 /var/www/mysite.com/wiki/languages/Language.php(241):
LocalisationCache-getItem('en', 'namespaceNames')
#9 /var/www/mysite.com/wiki/languages/Language.php(289):
Language-getNamespaces()
#10 [internal function]: Language-getNsText(14)
#11 /var/www/mysite.com/wiki/includes/StubObject.php(58):
call_user_func_array(Array, Array)
#12 /var/www/mysite.com/wiki/includes/StubObject.php(117):
StubObject-_call('getNsText', Array)
#13 [internal function]: StubContLang-__call('getNsText', Array)
#14 /var/www/mysite.com/wiki/includes/Title.php(470):
StubContLang-getNsText(14)
#15 /var/www/mysite.com/wiki/includes/Title.php(277): Title::makeName(14,
'Main_Pages', '')
#16 /var/www/mysite.com/wiki/includes/Category.php(88):
Title::makeTitleSafe(14, 'Main_Pages')
#17 /var/www/mysite.com/wiki/maintenance/populateCategory.inc(57):
Category::newFromName('Main_Pages')
#18 /var/www/mysite.com/wiki/maintenance/populateCategory.php(53):
populateCategory('', 10, 0, 1)
#19 {main}
===
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #21 from Tim Starling tstarl...@wikimedia.org 2009-07-04 00:10:37 UTC --- (In reply to comment #17) seems not to be fixed: svn update -- succeeded (rev. 52749) A database error has occurred Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost) svn update --revision 52730 -- succeeded Query: SELECT lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.l10n_cache' doesn't exist (localhost) svn update --revision 52502 -- succeeded Are you saying you get an error from the wiki after you do an svn update, but before you run maintenance/update.php? php maintenance/update.php MediaWiki 1.16alpha Updater [some output] Deleting old default messages (this may take a long time!)...Done Checking site_stats row...ok. Purging caches...done. Done. This is the output you would expect when the bug is fixed, maintenance/update.php does not get this far when it fails. (In reply to comment #20) I'd assume the updaters get ran in the order specified in the config, if this assumption is wrong, the follow is false: do_populate_parent_id get's called in the 1.13 section, but l10n isnt' created until the 1.16 section. These updaters dont seem to be defined for PG so I simulated by deleting the l10n table, not run update.php but run populateCategory.php first. The backtrace is similar as when running update.php: That does not simulate anything. Only maintenance/update.php and config/index.php will work before the l10n_cache table is created. The rest of the maintenance scripts and the wiki itself will fail. That is not a bug. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 jida...@jidanni.org changed: What|Removed |Added Priority|Normal |Highest --- Comment #12 from jida...@jidanni.org 2009-07-02 10:26:50 UTC --- Anybody with $wgLanguageCode!='en' who does $ svn update will find their wiki now *can no longer respond to requests (HTTP 500) *can no longer run update.php they only thing they can do is look in the svn manual for how to restore their wiki to some previous safer revision level, if possible. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #13 from Andrew Garrett agarr...@wikimedia.org 2009-07-02 10:30:55 UTC --- (In reply to comment #12) Anybody with $wgLanguageCode!='en' who does $ svn update will find their wiki now *can no longer respond to requests (HTTP 500) *can no longer run update.php they only thing they can do is look in the svn manual for how to restore their wiki to some previous safer revision level, if possible. Or use the workaround specified above: Set $wgLanguageCode to 'en', run update.php, and change it back again. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 --- Comment #14 from jida...@jidanni.org 2009-07-02 11:04:05 UTC --- svn manual for how to restore $ svn update --revision 52502 #the one before r52503 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 Roan Kattouw roan.katt...@gmail.com changed: What|Removed |Added Depends on|19428 | -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 Roan Kattouw roan.katt...@gmail.com changed: What|Removed |Added CC||roan.katt...@gmail.com AssignedTo|wikibugs- |tstarl...@wikimedia.org |l...@lists.wikimedia.org | Status|REOPENED|NEW --- Comment #10 from Roan Kattouw roan.katt...@gmail.com 2009-07-01 14:13:06 UTC --- The core problem here seems to be that before update.php gets to creating the l10n_cache table, it calls Title::newFromText(), which indirectly causes the localization to be loaded from cache. Looks like a tricky problem to solve; a potential fix would be for update.php to disable l10ncache rightaway, if l10ncache allows this and if the offending newFromText() call doesn't happen before that (judging from its argument, I don't think the latter is an issue). Assigning to Tim, who introduced l10ncache. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447
--- Comment #11 from Chad H. innocentkil...@gmail.com 2009-07-01 14:15:55
UTC ---
(In reply to comment #8)
temporarily set your $wgLanguageCode
Sounds risky.
By the way, for the English case where the new table was successfully added,
$ mysqldump --no-data mwabj|perl -nwle '$h{$_}++ for
/CHARSET=\w+/g;END{print $h{$_}\t$_ for keys %h}'
41 CHARSET=binary
2 CHARSET=utf8
1 CHARSET=latin1
Guess which new table is latin1 :-( . Please ensure new table creation
follows the same rules the other tables were created with.
That should be fixed with r52618
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 jida...@jidanni.org changed: What|Removed |Added Depends on||19428 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19447] Database update for l10n_cache fails on non-EN installs
https://bugzilla.wikimedia.org/show_bug.cgi?id=19447 ^demon innocentkil...@gmail.com changed: What|Removed |Added CC||innocentkil...@gmail.com Summary|Table '...l10n_cache' |Database update for |doesn't exist |l10n_cache fails on non-EN ||installs --- Comment #9 from ^demon innocentkil...@gmail.com 2009-06-30 23:45:43 UTC --- Tweak summary. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
