Jan Papež<honyczek-mailing@email.cz> 12/9/2011 6:12 AM >>> Dne Pá 2. prosince 2011 01:11:34, Matthew Ehle napsal(a):
- Roll back only the most affected wikis (cn, cs, ru, etc.) and restore the database
- Leave all the wikis as they are, and keep trying to fix the page titles
I'm inclined to do step number two, but I want to hear about any other options or opinions from the individual admins before we try to roll things back. If we can somehow get a list together of the garbled characters and the real characters that are associated, I can even script a fix of some type (making option number 3 more viable). If someone wants to take that on for their particular wiki, they can see the affected pages by going to /Special:AllPages and trying to compare.
Hi,
at this moment (in cs.opensuse.org) it looks that majority or all titles are ok, but i noticed that some category titles are broken: http://cs.opensuse.org/index.php?title=Speci%C3%A1ln%C3%AD:Kategorie&lim...
and eg. Navigation toolbar http://cs.opensuse.org/index.php?title=Kategorie:Naviga%C4%8Dn%C3%AD_li%C5%A... thows MediaWiki error.
It looks, that MediaWiki errors are displayed, when page doesn't exist.
It seems that existing pages with diacritic work. Eg. http://cs.opensuse.org/Struktura_soubor%C5%AF_u_opera%C4%8Dn%C3%ADho_syst%C3...
...
Huh, I found some error at Special pages - Category tree (Strom kategorií), when I tried to found Help category tree (Nápověda) http://cs.opensuse.org/index.php?title=Speci%C3%A1ln%C3%AD%3AStrom_kategori%... It said: Database returned error „1267: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (137.65.246.148:3307)“. ...
I think, that Czech wiki can stay at new version, but we have to do something to repair broken links and categories...
It looks like the Czech wiki had another collation issue that the other wikis didn't have. I had to revert a few days back, but it's fixed now. -Matt