mediawiki upgrade to 1.6.3
It’s been a long time that wiki.newzilla.org didn’t upgraded to lastest mediawiki version.
While I upgrade from 1.5.5 to 1.6.3, I encounter the problem:
』 failed with error code 『Specified key was too long; max key length is 1024 bytes (localhost)』.
This is a known bug, as we can see in bug 2907, so I modified maintenance/archives/patch-job.sql, added the following lines:
DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci
after the 『) TYPE=xxxxDB』 line.
solved 
五月 17th, 2006 at 6:55 上午
Hi,
on my system, the max key size is 500. I applied your patch (with mediawiki 1.6.5), and than set both job_title and job_cmd to 215 instead of 255. The update script worked like that, but I have no idea if I broke the database now…
CU Lars.
五月 19th, 2006 at 8:13 上午
Well, I don’t think you broke DB, or say, even you really broken database, we can’t tell in few mins
十二月 29th, 2006 at 1:24 下午
If you are working on a Unix like system, you can untar the new MediaWiki package at some place, copy your old LocalSettings.php file into this directory and set a symbolic link to the directory.