Page MenuHomePhabricator

Upgrading from 1.2 to 1.11 fails with MySQL error
Closed, ResolvedPublic

Description

Author: caluml

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


Version: 1.11.x
Severity: normal
OS: Linux

Details

Reference
bz11450

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:00 PM
bzimport set Reference to bz11450.
bzimport added a subscriber: Unknown Object (MLST).

Fixed on trunk in r26116, REL1_11 in r26116.

As a workaround, remove that extra word "binary" from maintenance/archives/patch-objectcache.sql