/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

1 vote216 views3 answers
Lumen
PHP
0 vote192 views1 answer
Laravel assign class dynamically if condition true
PHP
8 votes321 views3 answers
Php date plus days
PHP
0 vote179 views1 answer
Php inline variables string
PHP
1 vote206 views1 answer
Boot method laravel life cycle
PHP
0 vote187 views1 answer
Laravel allow null records relationship
PHP
36 votes186 views6 answers
Remove last character from string in php
PHP
7 votes201 views2 answers
Get order by laravel
PHP
8 votes204 views3 answers
Install php 7.4 on ubuntu 20.04
PHP
2 votes228 views2 answers
Check if date between two dates laravel
PHP Laravel