Mysql 5.6 not supported 767 error


#1

I get this error on user, system_custom, & cors_config tables.

Specified key was too long; max key length is 767 bytes.
Is mysql 5.6 not officially supported anymore?
Ref: https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

After some experimentation I’ve determined it to be the email length of 255. It seems when using a unique constraint and character set of utf8mb4 which is 4 bytes each that you hit the max of 767. So 767/4=191 which works as length for email.

In the other tables they are name & path which need a length of 191.


#2

In DreamFactory, you can use this fix, as it is a Laravel issue with the way it interacts with older MySQL databases.