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@wikimedia.org wrote:
From: Brion Vibber brion@wikimedia.org Subject: Re: [Mediawiki-l] Upgraded from 1.9.3 to 1.13.0- got error: Illegal mix of collations To: ek79501@yahoo.com, "MediaWiki announcements and site admin list" mediawiki-l@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