在运行`php artisan migrate`时遇到错误：`PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")`。解决方法是在`app/Providers/AppServiceProvider.php`中添加`use IlluminateSupportFacadesSchema;`并在`boot`方法内添加`Schema::defaultStringLength(191);`。如果出现`Base table or view already exists: 1050 Table ‘users’ already exists`错误，删除user表后重新运行迁移。
运行php artisan migrate报错
PDOException:: (“SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes”)
解决办法：
在app/Providers/AppSeviceProvider.php文件内添加
use Illuminate\Support\Facades\Schema;
foot方法内添加
Schema::defaultStringLength(191);
<?php
namespace App\Providers;
use Illuminate\Support\Facades\Schema;
use
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
最低0.47元/天 解锁文章
扫一扫
