[Mediawiki-l] Unable to upgrade from v1.5.7 to v1.6.5

[Jakob B. Grimstveit]

I am trying to upgrade from v1.5.7 to v1.6.5, but it fails, and I'm unable to
find the solution myself.

I have tried this with earlier versions of MediaWiki v1.6.x as well,
but it has never worked. Perhaps you can tell me what is wrong here?

> /opt/php/bin/php update.php
MediaWiki 1.6.5 Updater

Going to run database updates for stardocdb
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds...0
...hitcounter table already exists.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...logging table already exists.
...validate table already exists.
...user_newtalk table already exists.
...transcache table already exists.
...trackbacks table already exists.
...externallinks table already exists.
Creating job table...Query "CREATE TABLE `stardoc_job` (
job_id int(9) unsigned NOT NULL auto_increment,
job_cmd varchar(255) NOT NULL default '',
job_namespace int NOT NULL,
job_title varchar(255) binary NOT NULL,
job_params blob NOT NULL default '',
PRIMARY KEY job_id (job_id),
KEY (job_cmd, job_namespace, job_title)
) TYPE=InnoDB
" failed with error code "Specified key was too long. Max key length
is 500 (localhost)".

$ mysql --version
mysql  Ver 12.22 Distrib 4.0.18, for suse-linux (i686)

$ /opt/php/bin/php -v
PHP 5.1.2 (cli) (built: Feb 21 2006 21:39:07)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

$ cat /etc/issue | grep Kernel
Welcome to SUSE LINUX Enterprise Server 9 (i586) - Kernel \r (\l).

$ uname -a
Linux bgnl1-2 2.6.5-7.252-smp #1 SMP Tue Feb 14 11:11:04 UTC 2006 i686
i686 i386 GNU/Linux

Any clue what this might imply? Have read quite a few posts about this
being related to MySQL and it's handling of UTF8, but I don't see how
I can resolve this.

Tried both v1.6.2, v1.6.3 and v1.6.5, same problem occured.

How can I fix this so MediaWiki accepts the database? I have Googled a
lot about this, but have not found the definitive answer yet, so now
I'm turning to you.

I would love to upgrade to the v1.6 series, is this not possible in my
situation?

Thanks in advance for any help on this!


-- 
Jakob Breivik Grimstveit - http://www.grimstveit.no/jakob - +47 48298152