[Mediawiki-l] MySQL (?) error when installing MediaWiki 1.6.3

[Tels]

Moin,

On Thursday 27 April 2006 14:49, Rob Church wrote:
> On 27/04/06, Dave M G <martin at autotelic.com> wrote:
> [snip]
>
> >     * Creating tables... using MySQL 4 table defs...Query "CREATE
> > TABLE `gw_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 1024 bytes (localhost)".
>
> This is a known and quite a common problem for those upgrading from
> 1.5 to 1.6, or those installing 1.6.x under some conditions. Check out
> http://bugzilla.wikimedia.org/show_bug.cgi?id=1322, for instance; and
> possible fixes/workarounds/etc.

Btw, this also happened on my SuSE 9.1 system. Thanx for the pointer!

best wishes,

tels


-- 
 Signed on Thu Apr 27 19:24:26 2006 with key 0x93B84C15.
 Visit my photo gallery at http://bloodgate.com/photos/
 PGP key on http://bloodgate.com/tels.asc or per email.

 Marketing lesson #1: The synergy of the result driven leverage can
 *never* incentivize a paradigm shift. --  Walterk (124748) on 2004-01-16
 at /.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 481 bytes
Desc: not available
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20060427/77a6fe3c/attachment.pgp