Voyager: 1071 Specified key was too long - Tried everything

Created on 22 Apr 2018 · 4Comments · Source: the-control-group/voyager

Laravel Version: 5.6.*
Voyager Version: latest
PHP Version: 7.2.4
Database Driver & Version: mysql 5.7.21

Description:

I have created a database with the collation utf8mb4_unicode_ci
I added this code to the AppServiceProvider

use Illuminate\Support\Facades\Schema;
    public function boot()
    {
        Schema::defaultStringLength(191);
    }

and still can't install voyager and get the same message

Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table translations add unique translations_table_name_column_name_foreign_key_locale_unique(table_name, column_name, foreign_key, locale))

Source

wisamx

Most helpful comment

I found the solution at this:
https://github.com/the-control-group/voyager/issues/901#issuecomment-291470960
it's about specifying the database engin.
'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',
but why it is not clear at the documentation!

Thanks @emptynick

wisamx on 22 Apr 2018

❤3 👍2

All 4 comments

See https://github.com/the-control-group/voyager/issues/1840

emptynick on 22 Apr 2018

Thanks @emptynick

wisamx on 22 Apr 2018

❤3 👍2

Because it's a database level issue, not necessarily a Voyager issue. Also, we just haven't put it there yet. Readme.io allows you to suggest changes, so feel free to do so

fletch3555 on 22 Apr 2018

❤1

This issue has been automatically locked since there has not been any recent activity after it was closed. If you have further questions please ask in our Slack group.