-----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