Fixing syntax error or access violation 1071 specified key was too long max key length is 767 bytes
[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))
[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Solution:-Remove all migrated tables first from database.
Then,In App/Providers/ folder open "AppServiceProvider.php" and add below codes.
Step 1. On add "use Illuminate\Support\Facades\Schema;" under namespace App\Providers;.
Step 2. In boot method add Schema::defaultStringLength(191);
No comments