[Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegal mix of collations

[Brion Vibber]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Eric K wrote:
> Here's what I found. When Mediawiki upgrades, it doesnt seem to care to update the table schemes properly. Here's a sample of what I found:
>  
> Old table row specs, for mw_image (this is after the upgrade has been applied from 1.9.3 to 1.13.0):
> img_size int(8)
> img_width int(5)
> img_height int(5)

"Sizes" for integer fields are purely imaginary and have no actual
effect. We've generally removed them as they just confuse people.

> Usually, Collate was empty for a brand new 1.13.0, while it was
> latin_bin or latin1_swedish_ci for an upgraded version.

Can you provide details of the original schema collation and what MySQL
version and schema mode options were in use in your old *and* your new
LocalSettings.php?

The 1.13 updater should be configuring things properly for your database
(but older updaters *did not* always do this correctly).

- -- brion
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAki0JREACgkQwRnhpk1wk45g2wCfVY0t/W2pAUwXUxiUTDPYEn9p
+HQAnj4jtYeYg72FUmDoA8uyW9ua+zeE
=DZmJ
-----END PGP SIGNATURE-----