[Mediawiki-l] Page links with national characters disappeared after database migration

[Giuseppe Briotti]

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 at gmail.com>
> Subject: [Mediawiki-l] Page links with national characters disappeared
>        after   database migration
> To: mediawiki-l at lists.wikimedia.org
> Message-ID:
>        <ea2080e10812281234g7d0b47adtf857e72ebbb43a3b at 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%C5%9Bni
)
>
> 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 at gmail.com

"Alme Sol, curru nitido diem qui
promis et celas aliusque et idem
nasceris, possis nihil urbe Roma
visere maius."
(Orazio)