MySQL HELP!! 1071 - Specified key was too long; max key length is 1000 bytes

Posted On // Leave a Comment

Hi guys,


I try to move my blesta install. All table imported succesfully but i got this problem:



CREATE TABLE IF NOT EXISTS `permissions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`plugin_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `category_id` (`group_id`),
KEY `plugin_id` (`plugin_id`),
KEY `alias` (`alias`,`action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=198 ;


ERROR:


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


http://ift.tt/1dvHQ0Z

0 comments:

Post a Comment