Illuminate\Database\QueryException : 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`))
解決辦法:?
如果新安裝,記得清空數(shù)據(jù)庫。
我們可以在 AppServiceProvider.php 文件里的 boot 方法里設(shè)置一個(gè)默認(rèn)值:
文件路徑: /app/providers/AppServiceProvider.php烫映,加上加粗兩句代碼即可
<?php
namespace?App\Providers;
use?Illuminate\Support\ServiceProvider;
use?Illuminate\Support\Facades\Schema;
class?AppServiceProvider?extends?ServiceProvider
{
????/**
?????*?Register?any?application?services.
?????*
?????*?@return?void
?????*/
????public?function?register()
????{
????????//
????????Schema::defaultStringLength(191);
????}
????/**
?????*?Bootstrap?any?application?services.
?????*
?????*?@return?void
?????*/
????public?function?boot()
????{
????????//
????}
}