Last modified: 2010-05-15 15:59:35 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 11450 - Upgrading from 1.2 to 1.11 fails with MySQL error
Upgrading from 1.2 to 1.11 fails with MySQL error
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
All Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2007-09-25 09:43 UTC by Calum
Modified: 2010-05-15 15:59 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Calum 2007-09-25 09:43:07 UTC
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
Comment 1 Brion Vibber 2007-09-25 15:11:09 UTC
Fixed on trunk in r26116, REL1_11 in r26116.

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

Note You need to log in before you can comment on or make changes to this bug.