[Building Sakai] ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

[Patrick Coleman]

I'm trying to import a mysqldump into a sakai database. I done this many time
with dump but now I'm gett the error

ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

It's when it is running the statement.

 create table `entity_properties` (
    -> `id` bigint(20) NOT NULL auto_increment,
    -> `entityRef` varchar(255) NOT NULL,
    -> `entityPrefix` varchar(255) NOT NULL,
    -> `propertyName` varchar(255) NOT NULL,
    -> `propertyValue` text NOT NULL,
    -> PRIMARY KEY  (`id`),
    -> KEY `entityRef` (`entityRef`,`entityPrefix`,`propertyName`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Any ideas why this has started to happen. I can't think of what I may have
changed on a new server.

Thanks.

Pat.


-- 
View this message in context: http://old.nabble.com/ERROR-1071-%2842000%29%3A-Specified-key-was-too-long--max-key-length-is-1000-bytes-tp28562770p28562770.html
Sent from the Sakai - Development mailing list archive at Nabble.com.