Just tried to install this module and received the following error at the top of the module screen:

user warning: Specified key was too long; max key length is 767 bytes query: CREATE TABLE simplenews_statistics_path_paths ( `mail` VARCHAR(300) NOT NULL, `path_id` VARCHAR(32) NOT NULL, `url` VARCHAR(500) NOT NULL, `nid` INT NOT NULL, UNIQUE KEY mail (mail, path_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Webroot\Drupal6\includes\database.inc on line 517.

Found a similar sounding kind of issue http://drupal.org/node/347527 and a couple of MySQL bug report pages but I am unsure as the best way to fix the issue. Could someone advise please?

I am running 6.13, MySQL 5.1.31. Simplenews 6.x-1.0-rc6

Many thanks

Adam

Comments

j0nathan’s picture

j0nathan commented

Hi,
Encountered something related:

mysql> ALTER TABLE simplenews_statistics_path_paths TYPE='InnoDB';
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

This may be because you try to install the module using InnoDB table instead of MyISAM. But it would be better if the module respects InnoDB's constraints.

j0nathan’s picture

j0nathan commented

In our case, we wanted to change from MyISAM to InnoDB after the module was installed. So we did this to bypass the issue:

mysql> ALTER TABLE simplenews_statistics_path_paths MODIFY mail varchar(255);

and...

mysql> ALTER TABLE simplenews_statistics_path_paths TYPE='InnoDB';