MySQL Operational Error 1071 when running paster setup-db production.ini
I am receiving the following error when trying to run the database setup for Kallithea:
(Operational Error) (1071, 'Specified key was too long: max key length is 767 bytes') 'CREATE INDEX notification_type_idx ON notifications (type)' ()
Looking at the schema, it would appear that the type field of the notifications table is a VARCHAR(256) - which, with UTF-8, puts that at 768 bytes with 3 bytes per character - 1 byte over the Inno-DB limitation.
Is it assumed that innodb_large_prefix is true?