-----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
1. I miss all pages in Help (Справка - in russian)
2. Error on several pages:
«Database::select». MySQL возвратил ошибку «1267: Illegal mix of collations
(cp1251_general_ci,IMPLICIT) and (koi8r_general_ci,COERCIBLE) for operation
'=' (localhost)».
3. 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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org
iEYEARECAAYFAkkLQCsACgkQwRnhpk1wk472swCeLyPzPbTsfnWZ8BqJbQHX4VAj
KzoAoJ5mKelqNJbXDEkrJG3m87qCXvh+
=e7Yv
-----END PGP SIGNATURE-----