赞
踩
laravel报错: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
blog_adminsadd unique
blog_admins_email_unique(
email))
解决方案:
在 app/Providers/AppServiceProvider 的 boot 方法内添加:Schema::defaultStringLength(191);
修改后代码如下:
<?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() { // } /** * Bootstrap any application services. * * @return void */ public function boot() { // Schema::defaultStringLength(191); } }
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。