# Mysql 5.6 not supported 767 error

**URL:** <https://community.dreamfactory.com/t/mysql-5-6-not-supported-767-error/4294>\
**Category:** Feature Requests, Bugs, Issues\
**Created:** [February 17, 2018, 6:59am UTC](https://community.dreamfactory.com/t/mysql-5-6-not-supported-767-error/4294 "2018-02-17T06:59:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lastlink](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/lastlink/32/1127_2.png) [@lastlink](https://community.dreamfactory.com/u/lastlink)\
**Post date:** [February 17, 2018, 6:59am UTC](https://community.dreamfactory.com/t/mysql-5-6-not-supported-767-error/4294/1 "2018-02-17T06:59:15Z")

</div>

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](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.

---

<div class="post-metadata">

**Author:** ![Erik\_Jacobsen](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/erik_jacobsen/32/1132_2.png) [@Erik\_Jacobsen](https://community.dreamfactory.com/u/Erik_Jacobsen)\
**Post date:** [May 10, 2018, 8:01pm UTC](https://community.dreamfactory.com/t/mysql-5-6-not-supported-767-error/4294/2 "2018-05-10T20:01:34Z")

</div>

> [@lastlink](#):
>
> Specified key was too long; max key length is 767 bytes.

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

> **[Laravel 5.5 - 1071 specified key was too long max key length is 767 bytes -...](https://hdtuto.com/article/laravel-55-1071-specified-key-was-too-long-max-key-length-is-767-bytes)**
>
> 1071 specified key was too long max key length is 767 bytes in laravel, syntax error or access violation 1071 specified key was too long laravel, Laravel 5.5: Specified key was too long, Laravel migration error unique key is too long