https://bugzilla.wikimedia.org/show_bug.cgi?id=30120
Andy Nguyen <a...@panix.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |a...@panix.com
--- Comment #16 from Andy Nguyen <a...@panix.com> 2011-09-08 03:30:04 UTC ---
(In reply to comment #10)
> I have just upgraded to 1.17.0 and am experiencing this, too. I am using MySQL
> 5.5.15
>[...]
> I then executed the patch SQL directly (maintenance/archive/patch-iwlinks.sql)
>[...]
> So, I executed the patch-msg_resource.sql script directly
>[...]
> So I ran patch-module_deps.sql and it created a new table.
If you use a prefix for your DB table names, before executing those three .sql
files, you will need to edit them and make the following changes:
1. Change all "/*_*/" to your DB table name prefix. In my case, my table
names are mkvgtiwiki_XXX, so I changed the "/*_*/" to "mkvgtiwiki_".
2. Change all "/*i*/" to "<table name>_". For example, in patch-iwlinks.sql,
change "/*i*/" to "iwlinks_".
Here are the diffs of one of those scripts of mine:
diff -w patch-msg_resource.sql.orig patch-msg_resource.sql
2c2
< CREATE TABLE /*_*/msg_resource (
---
> CREATE TABLE mkvgtiwiki_msg_resource (
12c12
< CREATE UNIQUE INDEX /*i*/mr_resource_lang ON /*_*/msg_resource(mr_resource,
mr_lang);
---
> CREATE UNIQUE INDEX msg_resource_mr_resource_lang ON
> mkvgtiwiki_msg_resource(mr_resource, mr_lang);
15c15
< CREATE TABLE /*_*/msg_resource_links (
---
> CREATE TABLE mkvgtiwiki_msg_resource_links (
20c20
< CREATE UNIQUE INDEX /*i*/mrl_message_resource ON /*_*/msg_resource_links
(mrl_message, mrl_resource);
---
> CREATE UNIQUE INDEX msg_resource_mrl_message_resource ON
> mkvgtiwiki_msg_resource_links (mrl_message, mrl_resource);
Finally, edit maintenance/archives/patch-categorylinks-better-collation.sql and
change "/*$wgDBprefix*/" to your DB table name prefix:
diff -w patch-categorylinks-better-collation.sql.orig
patch-categorylinks-better-collation.sql
11c11
< ALTER TABLE /*$wgDBprefix*/categorylinks
---
> ALTER TABLE mkvgtiwiki_categorylinks
19c19
< INSERT IGNORE INTO /*$wgDBprefix*/updatelog (ul_key) VALUES
('cl_fields_update');
---
> INSERT IGNORE INTO mkvgtiwiki_updatelog (ul_key) VALUES ('cl_fields_update');
--
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
