php - Lumen 5.6 Migrate Error Specified key was too long max key length is 767 bytes

Solution:

you just need one more step

go to app.php on bootstrap folder and uncomomment or modif this line

// $app->register(App\Providers\AppServiceProvider::class);
Copy code

to this code

$app->register(App\Providers\AppServiceProvider::class);
Copy code

have a good day

Solution:

You need couple of things to do. I also faced this issue and fixed it by following these two steps

1. Go to app.php in bootstrap directory and uncomment or modify this line.

   // $app->register(App\Providers\AppServiceProvider::class);
   Copy code

2. Now you need to defineboot()function inAppServiceProviderfile

       public function boot()
       {
          Schema::defaultStringLength(191);
       }
   Copy code

Then you are good to go!

Solution:

Go to config in filedatabase.php then edit

'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
Copy code

to

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
Copy code

Solution:

use Illuminate\Support\Facades\Schema; //AppServiceProvider.php

public function boot(){
Schema::defaultStringLength(191);
}

//rollback your migration or delete all table from database then migrate again.
Copy code

Solution:

1. in bootstrap/app.php un-comment this line:

$app->register(App\Providers\AppServiceProvider::class);
Copy code

2. in app/AppServiceProvider.php add below public function toAppServiceProvider class:

public function boot()
  {
    Schema::defaultStringLength(191);
  }
Copy code

Solution:

Known to work in Laravel/Lumen 7.x:

I've tried the un-commenting ofAppServiceProvider::class and other solutions mentioned above, but the following worked for me.

If you look in/vendor/laravel/lumen-framework/config/database.php forcharset andcollation, the code checks your.env file and resorts toutf8mb4 andutf8mb4_unicode_ci, respectively.

If your database' charset is set toutf8 and collation toutf8_unicode_ci, simply add the following to your.env file:

# .env
...
DB_CHARSET=utf8
DB_COLLATION=utf8_unicode_ci
...
Copy code