Wikimedia Bugzilla is closed!

I am trying to upgrade from an old version to the latest.

The command line php update.php quits with Can't use command-line utils with in-place install yet, sorry.

Trying to upgrade over the web using config/index.php fails with the following error:

* There are already MediaWiki tables in this database. Checking if updates are needed...
 
...hitcounter table already exists.
...querycache table already exists.
Creating objectcache table...Query "CREATE TABLE `objectcache` (
 keyname varbinary(255) binary not null default '',
 value mediumblob,
 exptime datetime,
 unique key (keyname),
 key (exptime)
 ) TYPE=InnoDB
" failed with error code "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'binary not null default '',
 value mediumblob,
 exptime datetime,
 unique key (k' at line 2 (localhost)".


mysql-5.0.44, php-5.2.2, and mediawiki-1.11.0