当前位置:首页 > 技术 > PHP > php相关文章

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

2015-10-11 来源:未知 作者:admin

laravel安装Breeze时出现如下报错:

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

解决

在配置目录config/database.php找到mysql项。

将'engine' => null

改成'engine' => 'InnoDB ROW_FORMAT=DYNAMIC'

相关内容: Laravel
『 猜你喜欢 』