Geniegate MYSQL problem

Databases
1

hello.

im installing geniegate program to my server and im geting error

#1071 - Specified key was too long; max key length is 1000 bytes

i tried installing it the normal way, setup.php but i quess its outdated or my system settings are wrong or something

i try to make this table and it shows up that error

			CREATE TABLE cfg_vwpath (
				vid	MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
				ap	varchar(127),
				vn	varchar(255),
				classname	varchar(255),
				classfile	varchar(255),
				KEY(vid,ap,vn)
			)

#1071 - Specified key was too long; max key length is 1000 bytes

2

I’ve had this problem too, and have asked the developers of geniegate how to fix this. I got the following answer:

The problem is with mysql, not so much GenieGate, some installations
of mysql have a limitation on index length. (really makes it difficult
to design stuff to run when every host out there is different)

This would probably do it (through a mysql control panel
of some sort):

CREATE TABLE cfg_vwpath (
       vid    MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
       ap    varchar(127),
       vn    varchar(255),
       classname varchar(127),
       classfile varchar(127),
       KEY(vid,ap,vn)
)

I know this is an old thread, but they asked me if I could post this here since there was many people asking the same thing.

3

ok i i got it working, changed vn varchar (255) to (200)