Hi

If I try and install this module, I get the following error:

user warning: Specified key was too long; max key length is 767 bytes query: CREATE TABLE advanced_mail_reroute_rules ( `mailkey` VARCHAR(256) NOT NULL, `reroute_rule` TINYINT NOT NULL, `email` TEXT NOT NULL, PRIMARY KEY (mailkey), INDEX mailkey (mailkey) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\httpdocs\includes\database.inc on line 550.

I am using Drupal 6.16, MySQL 5.1 & PHP 5.2.5

Thank you

Comments

Shadlington’s picture

Shadlington commented

I have the exact same problem!

mrogers’s picture

mrogers commented

Having this issue as well -- any ideas?

rupyjl’s picture

rupyjl commented

I took the 'create' statement above and ran it as a SQL query in phpMyAdmin. It worked fine and the module now works well.

CREATE TABLE advanced_mail_reroute_rules
(`mailkey` VARCHAR( 255 ) NOT NULL ,
`reroute_rule` TINYINT NOT NULL ,
`email` TEXT NOT NULL ,
PRIMARY KEY ( mailkey ) ,
INDEX mailkey( mailkey ))

Anonymous’s picture

Anonymous (not verified) commented

Thanks for that. I've updated the schema for 6.x.