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 <[email protected]> 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 <[email protected]> > > > 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" <[email protected]> > > > Subject: [Mediawiki-l] Page links with national characters disappeared > > > after database migration > > > To: [email protected] > > > Message-ID: > > > <[email protected]> > > > 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 > > [email protected] > > > > "Alme Sol, curru nitido diem qui > > promis et celas aliusque et idem > > nasceris, possis nihil urbe Roma > > visere maius." > > (Orazio) > > _______________________________________________ > > MediaWiki-l mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > > -- > Sylvain Machefert > > Tous aux Balkans ! > http://www.tousauxbalkans.net > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
