/PHP/SQLSTATE[42000]: Syntax error or access violation: 1071

SQLSTATE[42000]: Syntax error or access violation: 1071

Laravel migation error

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

SQLSTATE[42000]: Syntax error or access violation: 1071

use Illuminate\Support\Facades\Schema;

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Schema::defaultStringLength(191);
}

Source: stackoverflow.com

Similar codes

88 votes251 views6 answers
Php split string
PHP
0 vote282 views1 answer
Error: Class '\App\Models\User' not found in file D:\teraNinga\mazadat\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php on line 183
PHP
2 votes244 views1 answer
Return back in blade laravel
PHP Laravel
63 votes229 views6 answers
Clear all cache in laravel
PHP
5 votes245 views4 answers
Laravel response redirect
PHP
0 vote228 views1 answer
Pagination always show 5 pages
PHP
33 votes227 views6 answers
Create migration command in laravel
PHP
0 vote279 views2 answers
Php codeigniter unit testing
PHP CodeIgniter
0 vote235 views1 answer
Laravel Mix npm run production error
PHP
1 vote240 views1 answer
Xampp to test on mobile
PHP