Hi Brion,
I apologize, I've done the upgrade already, but I will take notes in the next upgrade,
follow your directions and will let you know here if I see any differences then.
thanks
Eric
--- On Tue, 8/26/08, Brion Vibber <brion(a)wikimedia.org> wrote:
From: Brion Vibber <brion(a)wikimedia.org>
Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegal mix of
collations
To: ek79501(a)yahoo.com, "MediaWiki announcements and site admin list"
<mediawiki-l(a)lists.wikimedia.org>
Date: Tuesday, August 26, 2008, 10:45 AM
-----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-----