6
« on: December 01, 2005, 01:54:40 am »
Hey,
I just tried again to install a MySQL repository for my project. Actual MySQL 4.1.15 including UTF-8 support.
Now I get the error
CREATE TABLE t_objectproblems(
Object_ID int( 11 ) NOT NULL default '0',
Problem varchar( 255 ) NOT NULL ,
ProblemType varchar( 200 ) NOT NULL ,
DateReported date,
`Status` varchar( 50 ) ,
ProblemNotes text,
ReportedBy varchar( 255 ) ,
ResolvedBy varchar( 255 ) ,
DateResolved date,
`Version` varchar( 50 ) ,
ResolverNotes text,
Priority varchar( 100 ) ,
Severity varchar( 50 ) ,
PRIMARY KEY ( Object_ID, ProblemType, Problem ) ,
INDEX ObjectID( Object_ID ) ,
INDEX ObjectRequiresRequirement( Problem )
) TYPE = InnoDB COMMENT = "InnoDB free: 87040 kB"
MySQL error:
#1071 - Specified key was too long; max key length is 1024 bytes
Basically I do understand what this means, but is there any other solution than removing ProblemType, Problem from the PK?
Alex
PS: I'm wondering how you created these tables in first place - may be there is a configuration option that I can't find.