Moin,
On Thursday 27 April 2006 14:49, Rob Church wrote:
On 27/04/06, Dave M G martin@autotelic.com wrote: [snip]
* Creating tables... using MySQL 4 table defs...Query "CREATETABLE `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