Author: wikipedia.org-mail

Description:
January 6, 2008

I have done a clean install on my wiki.

I was running version 1.5.8. I deleted all of it.

I installed version 1.6.10.

How do I fix this error?

" failed with error code "Specified key was too long; max key length is 1024 bytes (localhost)"

I appreciate your help. Thanks.

David

The following is the error message received while doing the config setup.

• There are already MediaWiki tables in this database. Checking if updates are needed...

...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 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)".

Version: 1.6.x
Severity: critical
OS: Linux