Forum

laravel 8 - Syntax ...
 
Notifications
Clear all

laravel 8 - Syntax error or access violation: 1071 Specified key was too long

1 Posty
1 Users
0 Likes
697 Widok
0
Topic starter
 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`))
1 Answer
0
Topic starter
  1. edit config/database.php
  2. inside "mysql" object find
  3. 'engine' => null,
  4. modify this line
  5. 'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',
  6. or
  7. 'engine' => 'InnoDB',

 

Odpowiedź

Author Name

Author Email

Your question *

 
Preview 0 Revisions Saved
Share: