Laravel : Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

Photo by Markus Spiske on Unsplash

Tambahkan pada boot

class AppServiceProvider extends ServiceProvider
{
    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }

    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        Schema::defaultStringLength(191);
    }
}

Or

Inside config/database.php, replace this line for mysql

Copy

'engine' => null',

to

'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',