Voyager: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

[shahidkarimi]

• Laravel Version: 5.4
• Voyager Version: Latest
• PHP Version: 5.6.x
• Database Driver & Version:
  MySQL 5.7.11
  

  Description:

Event I put the following code in service provider root() function.

Schema::defaultStringLength(191);

Steps To Reproduce:

[AdrianKuriata]

Do you using homestead?

[supernova13892]

I can vouch, I am getting the error even after adding the lines:
Schema::defaultStringLength(191);

and use Illuminate\Support\Facades\Schema;

in app\Providers\AppServiceProvider.php

PHP Version: 5.6.19(from WAMP package)
Laravel Version: 5.4
Voyager: ^0.11.12
MySQL Version: 5.7.11(from WAMP package)

[AdrianKuriata]

This solution is for i dont remember exacly but for error 768 bytes? Maybe try set defaultString on 200 or more, i don't have idea...

[supernova13892]

Was reading a discussion on Laracasts

A user suggested to change the 'engine' => null', to 'engine' => 'InnoDB ROW_FORMAT=DYNAMIC', in config/database.php

I tried it and nothing else and it worked fine. Maybe others can give it a shot?

[Tommixoft]

@supernova13892 IT FUCKING WORKS! thanks. laravel team created post how to fix it based on idea that laravel uses InoDB, while it uses MyISAM hence the fix doesnt work, and when we change to INNODB it works.

[rmazarei]

@supernova13892 solution worked for me too.

[handiwijoyo]

When you import sql file to older mysql version without run the migrations, you need to change utf8mb4 to utf8 and utf8mb4_unicode_ci to utf8_unicode_ci

[Lord-Gown]

its alive!! thanks for that solution to change the database.php file

[github-actions[bot]]

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.