Fix the annoying migration error "Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes "
This is an annoying problem but really easy to solve. You just need to set the default length of a string in migration to 191.
Simply open app\Providers\AppServiceProvider.php
add the following to the top:
use Illuminate\Support\Facades\Schema;
and then within the boot function (probably blank) add:
Schema::defaultStringLength(191);
Thanks it!
Comments
0 comment