/PHP/Laravel/ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel

ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel

use Illuminate\Support\Facades\Schema;

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

Source: laravel-news.com

PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8

// Update your /app/Providers/AppServiceProvider.php to contain:use Illuminate\Support\Facades\Schema;

public function boot()
{
    Schema::defaultStringLength(191);
}
//ON this error //  PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists")// After run -> php artisan migrate:fresh <- ! Note this will reset all tables in db

ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel

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

Source: stackoverflow.com

ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel

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

Source: stackoverflow.com

Similar codes

1 vote398 views1 answer
Inrandomorder laravel
PHP Laravel
5 votes397 views2 answers
Route() and with() in laravel
PHP Laravel
0 vote417 views1 answer
Redirect all request to public folder laravel htaccess
PHP Laravel
0 vote343 views3 answers
Laravel load relationship
PHP Laravel
0 vote384 views1 answer
Multipart json test laravel
PHP Laravel
0 vote368 views1 answer
Laravel datatable render html
PHP Laravel
13 votes396 views4 answers
Laravel make migration update table
PHP Laravel
26 votes383 views4 answers
Where is cache file in laravel
PHP Laravel
0 vote452 views2 answers
Laravel composite unique key
PHP Laravel
3 votes374 views3 answers
Laravel sort by function'
PHP Laravel