-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Bovo wrote:
I upgrade wiki.irkutsk to 1.12 version but after this: I make updating process as in rules. I run the update.php maintenance script
- MediaWiki version: 1.12.1
- PHP version: 5.2.6 (apache2handler)
- MySQL version: 4.1.22-log
- URL: http://wiki.irkutsk.ru
I miss all pages in Help (Справка - in russian)
Error on several pages:
«Database::select». MySQL возвратил ошибку «1267: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (koi8r_general_ci,COERCIBLE) for operation '=' (localhost)».
- When I try to create a new page (create a link, turn it on and edit new
page) - it is not recorded, and an error «Database::select». MySQL возвратил ошибку «1267: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (koi8r_general_ci,COERCIBLE) for operation '=' (localhost)». What's wrong? Help!!!!
Sounds like your original installation was created on an old MediaWiki with the old default "charset-agnostic" mode ("backwards-compatible UTF-8" setting on the installer), with MySQL configured to have one server charset... then when you did the upgrade, it was configured to a different default server charset, and new tables/fields got created with the different charset and now it's terribly confused.
The best solution, ultimately, is a fresh installation with the database configured for the binary schema -- this will be consistent and isn't dependent on the whims of the MySQL server's configuration.
Unfortunately we don't have an automatic script right now to normalize your data. You can probably pull some sort of export/import to fix it, but the bad news is basically from using MySQL 4.1 and the crappy old defaults.
- -- brion