Key too long error:
2015-04-13 11:00:29 26692 [ERROR] Slave SQL: Error 'Specified key was too long; max key length is 767 bytes' [COLOR=#00008B]on query. [COLOR=#00008B]Default [COLOR=#00008B]database: 'dataBaseName'. Query: 'alter table UserGroup add constraint UK_f6x7vpmw83jptft2toy0wsfk6 unique (groupName)', Error_code: 1071
[COLOR=#00008B]CREATE [COLOR=#00008B]TABLE UserGroup
( id
bigint(20) [COLOR=#00008B]NOT [COLOR=#00008B]NULL AUTO_INCREMENT, groupName
varchar(255) CHARACTER [COLOR=#00008B]SET utf8mb4 [COLOR=#00008B]COLLATE utf8mb4_unicode_ci [COLOR=#00008B]NOT [COLOR=#00008B]NULL, groupType
int(11) [COLOR=#00008B]NOT [COLOR=#00008B]NULL, clientAccountSettings_id
bigint(20) [COLOR=#00008B]DEFAULT [COLOR=#00008B]NULL, timestamp4support
timestamp [COLOR=#00008B]NOT [COLOR=#00008B]NULL [COLOR=#00008B]DEFAULT [COLOR=#00008B]CURRENT_TIMESTAMP [COLOR=#00008B]ON [COLOR=#00008B]UPDATE [COLOR=#00008B]CURRENT_TIMESTAMP, [COLOR=#00008B]PRIMARY [COLOR=#00008B]KEY (id
), [COLOR=#00008B]UNIQUE [COLOR=#00008B]KEY groupName
(groupName
(191)), [COLOR=#00008B]KEY FK8A5BE1545E3F3DC
(clientAccountSettings_id
), [COLOR=#00008B]CONSTRAINT FK8A5BE1545E3F3DC
[COLOR=#00008B]FOREIGN [COLOR=#00008B]KEY (clientAccountSettings_id
) [COLOR=#00008B]REFERENCES ClientAccountSettings
(id
) ) ENGINE=InnoDB AUTO_INCREMENT=10 [COLOR=#00008B]DEFAULT CHARSET=utf8 [COLOR=#00008B]COLLATE=utf8_unicode_ci;
2015-04-13 10:56:25 26692 [ERROR] Slave SQL: Error ‘BLOB/TEXT column ‘name’ used in key specification without a key length’ [COLOR=#00008B]on query. [COLOR=#00008B]Default [COLOR=#00008B]database: ‘dataBaseName’. Query: ‘alter table ISP add constraint UK_tfe1hfqbgydnfe2siovm1i80k unique (name)’, Error_code: 1170
Table structure:
[COLOR=#00008B]CREATE [COLOR=#00008B]TABLE ISP
( id
bigint(20) [COLOR=#00008B]NOT [COLOR=#00008B]NULL AUTO_INCREMENT, name
longtext CHARACTER [COLOR=#00008B]SET utf8mb4 [COLOR=#00008B]COLLATE utf8mb4_unicode_ci, abuseEmail
longtext CHARACTER [COLOR=#00008B]SET utf8mb4 [COLOR=#00008B]COLLATE utf8mb4_unicode_ci, timestamp4support
timestamp [COLOR=#00008B]NOT [COLOR=#00008B]NULL [COLOR=#00008B]DEFAULT [COLOR=#00008B]CURRENT_TIMESTAMP [COLOR=#00008B]ON [COLOR=#00008B]UPDATE [COLOR=#00008B]CURRENT_TIMESTAMP, [COLOR=#00008B]PRIMARY [COLOR=#00008B]KEY (id
), [COLOR=#00008B]UNIQUE [COLOR=#00008B]KEY name
(name
(191)) ) ENGINE=InnoDB AUTO_INCREMENT=465 [COLOR=#00008B]DEFAULT CHARSET=utf8 [COLOR=#00008B]COLLATE=utf8_unicode_ci;