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

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

Similar codes

7 votes128 views2 answers
Laravel field types from database field type
PHP Laravel
42 votes117 views5 answers
Create controller laravel with model
PHP Laravel
1 vote109 views2 answers
Laravel model set new attribute
PHP Laravel
1 vote109 views1 answer
Laravel Post model for flat file CMS
PHP Laravel
1 vote120 views1 answer
Enablequerylog laravel
PHP Laravel
1 vote125 views1 answer
Laravel format number blade
PHP Laravel
0 vote110 views1 answer
Laravel faker generate country code
PHP Laravel
13 votes140 views3 answers
Laravel password encryption
PHP Laravel
4 votes119 views1 answer
Laravel request all except token
PHP Laravel
0 vote134 views3 answers
Embed the site when you click on the link laravel
PHP Laravel