[rt-users] Is this problem depending on my mysql-version?

[Klaus Hoffmann]

Hi list,

during the installation of rt2 I get the following error: 

/usr/bin/perl   tools/initdb 'mysql' '/usr' 'localhost' 'rt' 'rt2'
insert
Now populating database schema.
Enter the mysql password for rt:
Creating database schema.
DBD::mysql::st execute failed: Specified key was too long. Max key
length is 256 at tools/initdb line 160, <SCHEMA> chunk 258.
Problem with statement:
 CREATE TABLE KeywordSelects (
  id INTEGER NOT NULL  AUTO_INCREMENT,
  Name varchar(255) NULL  ,
  Keyword integer NOT NULL  ,
  Single integer NULL  ,
  Depth integer NOT NULL DEFAULT 0 ,
  ObjectType varchar(32) NOT NULL  ,
  ObjectField varchar(32) NOT NULL  ,
  ObjectValue varchar(255) NOT NULL  ,
  Disabled int2 NOT NULL DEFAULT 0 ,
  PRIMARY KEY (id),
  INDEX (Keyword),
  INDEX (ObjectType, ObjectField, ObjectValue)
)
 
Specified key was too long. Max key length is 256 at tools/initdb line
162, <SCHEMA> chunk 258.
make: *** [initdb.rtuser] Error 255

Unfortunately I´m using mysql-server version: 3.22.32 and I can´t
upgrade now.

Does this problem depend on the version, or there another thing to do?

Thanks for your help in advance.

Regards 
Klaus
-- 
Klaus Hoffmann			EMail:  klaus.hoffmann at s3-med.de
HOFFMANN Consulting		Tel.: 	+49-7161-989464
Unternehmensberatungs GmbH	Fax:	+49-7161-989466
Zeisigweg 1			Mobil: 	+49-170-2033183
D-73054 Eislingen		Mobilfx:+49-170-132033230