database Archives

Access violation error in Laravel 5.4 migration

Posted on June 20, 2017August 14, 2019

When we setup a fresh laravel 5.4 and tried to run default user tables migration

php artisan migrate

1	php artisan migrate

then we got a below error

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_
unique`(`email`))

[Illuminate\Database\QueryException]

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_

unique`(`email`))

After searching for this error in google, we came to know that it is due to mysql database engine updation. There are few solutions recommended in few places. We tried them but […]