Topic on Project:Support desk

Howdy-

It appears that at least as of MW 17, there is a problem with running it on top of MySQL 5.5.

According to MySQL:

The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

The "update.php" script in MW 17 (at least) still attempts to use TYPE, and thus fails when attempting to perform an update of an older wiki install.

I haven't found anything that would imply that this is fixed in newer versions of MW, and if MySQL has been warning of this change since 4.0, there doesn't seem to be much of an excuse on MW's side :-)

A culprit appears to be upgrade1.5_php, although the primary problem appears that the update.php script will not sanity-check the db version against the value of $wgDBTableOptions specified in LocalSettings.php.

Pretty stinky...

What version were you upgrading from?