发布于 4年前

laravel 在执行 `php artisan migrate`出现错误, PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 b

在执行 php artisan migrate出现错误

 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 b

解决方案

  1. 修改config/database.php文件,将utf8mb4替换成utf8
  2. 修改app/Providers/AppServiceProvider.php文件
public function boot()
{
    \Illuminate\\Support\\Facades\\Schema::defaultStringLength();
}

相关文章

©2020 edoou.com   京ICP备16001874号-3