/PHP/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 vote139 views1 answer
Connect an if statement to an input php
PHP
0 vote168 views1 answer
Php get ip by domain
PHP
47 votes159 views6 answers
Php array lenght
PHP
12 votes225 views2 answers
Phpmyadmin add foreign key
PHP
18 votes171 views4 answers
Use if in laravel blade
PHP Laravel
0 vote136 views1 answer
Php remove nbsp from string
PHP
40 votes211 views6 answers
Php format datetime
PHP
0 vote169 views1 answer
Odoctrine querybuilder print sql
PHP
0 vote177 views1 answer
Next year php string
PHP
2 votes207 views6 answers
Laravel 8 ui auth
PHP Laravel