Laravel：SQLSTATE[42000]: Syntax Error Or Access Violation: 1071 Specified Key Was Too Long; Max Key Length

Laravel：SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

主机百科更新于 2020-07-23 01:33:55首发于 2020-07-23 01:33:55技术115

laravel 5.4 版本改变默认的数据库字符集为utf8mb4。如果你运行MySQL v5.7.7或者更高版本，则不需要做任何事情。

否则你在运行 migrations 命令时，可能会碰到下面这个错误：

   [IlluminateDatabaseQueryException]  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

[IlluminateDatabaseQueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email)) SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

   我们可以在 <a href="https://www.zjwiki.com/tag/app" title="appflickr.photos.notes.edit rel="nofollow">app</a>ProvidersAppServiceProvider.php 文件里中的 boot 方法里设置<a href="https://www.zjwiki.com/tag/一个" title="一个flickr.photos.notes.edit rel="nofollow">一个</a>默认值来解决这个错误：

1	我们可以在 appProvidersAppServiceProvider.php 文件里中的 boot 方法里设置一个默认值来解决这个错误：

   Schema::defaultStringLength(200);

1	Schema::defaultStringLength(200);

完整的AppServerProvider.php文件代码如下：

   <?php  namespace AppProviders;    use IlluminateSupportServiceProvider;  use IlluminateSupportFacadesSchema;    class AppServiceProvider extends ServiceProvider  {      public function boot()      {          Schema::defaultStringLength(200);      }        public function register()      {          //      }  }

1	<?php namespace AppProviders; use IlluminateSupportServiceProvider; use IlluminateSupportFacadesSchema; class AppServiceProvider extends ServiceProvider {     public function boot()     {         Schema::defaultStringLength(200);     }     public function register()     {         // } }

未经允许不得转载：主机百科 » Laravel：SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

0 赞

Laravel：SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

相关文章

置顶推荐

随机推荐

热门排行