Laravel error while migrating 42000

Published 1 week ago by Twittler

Hi guys, i just don't know what happened, i just migrated users file and i got this error:

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))

at /Applications/MAMP/htdocs/RunescapeTips/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664 660| // If an exception occurs when attempting to run a query, we'll format the error 661| // message to include the bindings with SQL, which will make this exception a 662| // lot more helpful to the developer instead of just the database's errors. 663| catch (Exception $e) {

664| throw new QueryException( 665| $query, $this->prepareBindings($bindings), $e 666| ); 667| } 668|

Exception trace:

1 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes") /Applications/MAMP/htdocs/RunescapeTips/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458

2 PDOStatement::execute() /Applications/MAMP/htdocs/RunescapeTips/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458

Any suggestions how i can solve this?

bobbybouwmann

This should fix and explain your problem: https://laravel-news.com/laravel-5-4-key-too-long-error

Please sign in or create an account to participate in this conversation.