Did you use the phpMyAdmin tool for export import? I had a similar problem and I solved it when I noticed that phpMyAdmin showed a wrong charset for the database engine (you can set charset for database engine, database and table).
Verify by mysql console, if possible, what is the charset setting.
Hope this help
Giuseppe
Message: 3 Date: Sun, 28 Dec 2008 21:34:16 +0100 From: "Mateusz Sobczak" sobczak.mateusz@gmail.com Subject: [Mediawiki-l] Page links with national characters disappeared after database migration To: mediawiki-l@lists.wikimedia.org Message-ID: ea2080e10812281234g7d0b47adtf857e72ebbb43a3b@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-2
Hello,
I need some help with the following problem (described also here: http://www.mediawiki.org/wiki/Project:Support_desk/Sections/Database).
I am moving a MediaWiki based webpage from one server to another. After exporting the database and importing it to the new server I got the message "1271: Illegal mix of collations for operation ' IN ' (mysql.extremefaith.info)". So I updated MediaWiki to the newest stable version (1.13.3) which caused the change of the $wgDBmysql5 variable value to "true" and that solved the problem.
Yet another one appeared. Although the content of the present pages remained unchanged (all the national characters were present) all the links with national characters became "red" (f.ex. "?nie?nobia?e ?wiat?o") and I can't access the content of those pages. What's more when I add the content manually some pages still remain "red". When I click on this kind of edited-"red" page I can see the content but it's being opened in "edit" tab by default. All the tables have "latin2_general_ci" collation set.
Could you please help me to fix the "red" links with national characters?
(You can see the red links f.ex. here:
http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Teksty_pie... )
server1:
- MediaWiki: 1.10alpha
- PHP: 5.2.6 (ucgi5)
- MySQL: 5.0.66a-log
- URL: http://www.krokpokroku.pl/wiki/index.php?title=Inspiracje
server2:
- MediaWiki: 1.13.3
- PHP: 5.2.6 (cgi-fcgi)
- MySQL: 5.0.67-log
- URL:
http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Inspiracje
Regards,
-- Mateusz Sobczak <><
Hi,
I had these problem when migrating... Here is my solution, if like me you started with mysql4 (then at install/upgrade you say you have mysql4, not 5).
For each field which may contain some "national chars" and is not a blob, I created a field_blob which is the copy of the field.
For example, page_title in wiki_page table, I created a page_title_blob, and a little query : update wiki_table set page_title_blob=page_title.
In case of error during migration, do the reverse query ...set page_title=page_title_blob and it works, at least for me :-)
I don't remember all field which may be concerned, there is one in wiki_text I think...
This increase the database but it saved me once. The first time the host provider migrated from mysql4 to mysql5 and it was a catastrophe! So I corrected everything by hand (reaaallllly long!), added my field, and moved to another host provider accepting mysql4 :-D
Hope this helps
2008/12/29 Giuseppe Briotti g.briotti@gmail.com
Did you use the phpMyAdmin tool for export import? I had a similar problem and I solved it when I noticed that phpMyAdmin showed a wrong charset for the database engine (you can set charset for database engine, database and table).
Verify by mysql console, if possible, what is the charset setting.
Hope this help
Giuseppe
Message: 3 Date: Sun, 28 Dec 2008 21:34:16 +0100 From: "Mateusz Sobczak" sobczak.mateusz@gmail.com Subject: [Mediawiki-l] Page links with national characters disappeared after database migration To: mediawiki-l@lists.wikimedia.org Message-ID: ea2080e10812281234g7d0b47adtf857e72ebbb43a3b@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-2
Hello,
I need some help with the following problem (described also here: http://www.mediawiki.org/wiki/Project:Support_desk/Sections/Database).
I am moving a MediaWiki based webpage from one server to another. After exporting the database and importing it to the new server I got the message "1271: Illegal mix of collations for operation ' IN ' (mysql.extremefaith.info)". So I updated MediaWiki to the newest stable version (1.13.3) which caused the change of the $wgDBmysql5 variable value to "true" and that solved the problem.
Yet another one appeared. Although the content of the present pages remained unchanged (all the national characters were present) all the links with national characters became "red" (f.ex. "?nie?nobia?e ?wiat?o") and I can't access the content of those pages. What's more when I add the content manually some pages still remain "red". When I click on this kind of edited-"red" page I can see the content but it's being opened in "edit" tab by default. All the tables have "latin2_general_ci" collation set.
Could you please help me to fix the "red" links with national characters?
(You can see the red links f.ex. here:
http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Teksty_pie... )
server1:
- MediaWiki: 1.10alpha
- PHP: 5.2.6 (ucgi5)
- MySQL: 5.0.66a-log
- URL: http://www.krokpokroku.pl/wiki/index.php?title=Inspiracje
server2:
- MediaWiki: 1.13.3
- PHP: 5.2.6 (cgi-fcgi)
- MySQL: 5.0.67-log
- URL:
http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Inspiracje
Regards,
-- Mateusz Sobczak <><
--
Giuseppe Briotti g.briotti@gmail.com
"Alme Sol, curru nitido diem qui promis et celas aliusque et idem nasceris, possis nihil urbe Roma visere maius." (Orazio) _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Giuseppe, Sylvain
Unfortunatelly none of your tips worked for me. Still thank you for your solutions.
Happy New Year,
-- Mateusz Sobczak <><
On Mon, Dec 29, 2008 at 4:32 PM, Sylvain Machefert iubito@gmail.com wrote:
Hi,
I had these problem when migrating... Here is my solution, if like me you started with mysql4 (then at install/upgrade you say you have mysql4, not 5).
For each field which may contain some "national chars" and is not a blob, I created a field_blob which is the copy of the field.
For example, page_title in wiki_page table, I created a page_title_blob, and a little query : update wiki_table set page_title_blob=page_title.
In case of error during migration, do the reverse query ...set page_title=page_title_blob and it works, at least for me :-)
I don't remember all field which may be concerned, there is one in wiki_text I think...
This increase the database but it saved me once. The first time the host provider migrated from mysql4 to mysql5 and it was a catastrophe! So I corrected everything by hand (reaaallllly long!), added my field, and moved to another host provider accepting mysql4 :-D
Hope this helps
2008/12/29 Giuseppe Briotti g.briotti@gmail.com
Did you use the phpMyAdmin tool for export import? I had a similar problem and I solved it when I noticed that phpMyAdmin showed a wrong charset for the database engine (you can set charset for database engine, database and table).
Verify by mysql console, if possible, what is the charset setting.
Hope this help
Giuseppe
Message: 3 Date: Sun, 28 Dec 2008 21:34:16 +0100 From: "Mateusz Sobczak" sobczak.mateusz@gmail.com Subject: [Mediawiki-l] Page links with national characters disappeared after database migration To: mediawiki-l@lists.wikimedia.org Message-ID: ea2080e10812281234g7d0b47adtf857e72ebbb43a3b@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-2
Hello,
I need some help with the following problem (described also here: http://www.mediawiki.org/wiki/Project:Support_desk/Sections/Database).
I am moving a MediaWiki based webpage from one server to another. After exporting the database and importing it to the new server I got the message "1271: Illegal mix of collations for operation ' IN ' (mysql.extremefaith.info)". So I updated MediaWiki to the newest stable version (1.13.3) which caused the change of the $wgDBmysql5 variable value to "true" and that solved the problem.
Yet another one appeared. Although the content of the present pages remained unchanged (all the national characters were present) all the links with national characters became "red" (f.ex. "?nie?nobia?e ?wiat?o") and I can't access the content of those pages. What's more when I add the content manually some pages still remain "red". When I click on this kind of edited-"red" page I can see the content but it's being opened in "edit" tab by default. All the tables have "latin2_general_ci" collation set.
Could you please help me to fix the "red" links with national characters?
(You can see the red links f.ex. here:
http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Teksty_pie... )
server1:
- MediaWiki: 1.10alpha
- PHP: 5.2.6 (ucgi5)
- MySQL: 5.0.66a-log
- URL: http://www.krokpokroku.pl/wiki/index.php?title=Inspiracje
server2:
- MediaWiki: 1.13.3
- PHP: 5.2.6 (cgi-fcgi)
- MySQL: 5.0.67-log
- URL:
http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Inspiracje
Regards,
-- Mateusz Sobczak <><
--
Giuseppe Briotti g.briotti@gmail.com
"Alme Sol, curru nitido diem qui promis et celas aliusque et idem nasceris, possis nihil urbe Roma visere maius." (Orazio) _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
-- Sylvain Machefert
Tous aux Balkans ! http://www.tousauxbalkans.net _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org