Laravel Migration Prob Solve:specified key was too long;max key length is 1000 bytes

sometimes when we run php artisan migrate we got Laravel Migration Problem : Syntax error or access violation, 1071 specified key was too long; max key length is 1000 bytes. For solution let’s follow the below steps.

Solutions Steps:

1. Go to YourProjectFolder/app/providers/AppServiceProvider.php directory
2. Add following line before Class
   
   use Illuminate\Support\Facades\Schema;

   1	use Illuminate\Support\Facades\Schema;

   
   
   <?php namespace App\Providers; use Illuminate\Support\ServiceProvider; <strong>use Illuminate\Support\Facades\Schema;</strong> class AppServiceProvider extends ServiceProvider {

   1 2 3 4 5 6 7 8 9

   <?php   namespace App\Providers;   use Illuminate\Support\ServiceProvider; <strong>use Illuminate\Support\Facades\Schema;</strong>   class AppServiceProvider extends ServiceProvider {

3. Add this line inside boot function
   
   Schema::defaultStringLength(191);

   1	Schema::defaultStringLength(191);

   
   I mean like following
   
   public function boot() { <strong>Schema::defaultStringLength(191);</strong> }

   1 2 3 4

   public function boot() {     <strong>Schema::defaultStringLength(191);</strong> }

4. lets go to our database and delete all the tables manually.
5. then again run below line on the terminal.
   
   php artisan migrate

   1	php artisan migrate

   
    

Share with: