Database error

Question

I downloaded and tried to install ST e-commerce today. Got this

Arrrh! Can't install database.
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes, query was: CREATE TABLE `email_triggers` ( `id` int(10) NOT NULL AUTO_INCREMENT, `enabled` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, `trigger_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `observer` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `trigger_name_2` (`trigger_name`,`observer`), UNIQUE KEY `trigger_name_3` (`trigger_name`,`observer`), KEY `trigger_name` (`trigger_name`), KEY `observer` (`observer`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Answer 1

Hello Ugintl,

Thank you  for a question.

There is a problem with your MySQL settings.
If you are using MyISAM database engine this can be a known bug with MySQL related to MyISAM, the UTF8 character set and indexes that you can check here.
https://confluence.atlassian.com/display/FISHKB/MySQL+Database+Migration+fails+with+Specified+key+was+too+long+max+key+length+is+1000+bytes

If you are using INNODB engine, then try to enable "innodb_large_prefix"
Please launch this command from your mysql console.
mysql> set global innodb_large_prefix = ON;

If it doesn't help, feel free to contact us.