PHP

1071 Specified key was too long; max key length is 1000 bytes

// /app/Providers/AppserviceProvider.php

use IlluminateSupportFacadesSchema;

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

specified key was too long max key length is 767 bytes

# AppServiceProvider.php

use IlluminateSupportFacadesSchema;

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

Specified key was too long; max key length is 1000 bytes

In appProvidersAppServiceProvider.php File

// Add 
use IlluminateSupportFacadesSchema;

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

violation: 1071 Specified key was too long; max key length is 1000 bytes

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

Copy Code
'engine' => null',
with

Copy Code
'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',
Instead of setting a limit on your string lenght.

Specified key was too long; max key length is 767 bytes

I had this error and I changed my tables column length smaller for the indexed foreign key columns so I changed it like this:

VARCHAR(1024)
To:

VARCHAR(512)
And run the query again.