[Mediawiki-l] SQL error..

Thomas, Arjun Arjun.Thomas at ps.net
Sun Apr 15 08:22:16 UTC 2007


hi all,

I'm trying to install the new version of mediawiki ( 1.9.3 ) on my host. However i get the following error message.

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,
 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 (h41mysql1.secureserver.net)".

any idea why this is??

thanks, 
AJ


More information about the MediaWiki-l mailing list