分享每一天-laravel 错误 1071 Specified key was too long; max key length is 1000 bytes

laravel 错误 1071 Specified key was too long; max key length is 1000 bytes

PHP 2027 0 创建时间：2020-09-18 17:39:39

#### 环境描述：
- laravel8.4.0
- mysql5.6
- php7.3

laravel 执行 php artisan migrate 安装数据库报错：

```php

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`))

at C:\Users\Administrator\Desktop\demo_laravel\laravel8\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    667▕         // If an exception occurs when attempting to run a query, we'll format the error
    668▕         // message to include the bindings with SQL, which will make this exception a
    669▕         // lot more helpful to the developer instead of just the database's errors.
    670▕         catch (Exception $e) {
  ➜ 671▕             throw new QueryException(
    672▕                 $query, $this->prepareBindings($bindings), $e
    673▕             );
    674▕         }
    675▕

1   C:\Users\Administrator\Desktop\demo_laravel\laravel8\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:131
      Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")

2   C:\Users\Administrator\Desktop\demo_laravel\laravel8\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:129
      PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")
```

数据库不支持长字节 需要在 \app\Providers\AppServiceProvider.php文件
里面添加状态码191 具体代码如下
![](http://www.seedblog.cn/uploads/article/2020-09-18/ism9uCT27jV1pXlUCLPPhVJAelrjEafYuPnWSiNX.png)

laravel 错误 1071 Specified key was too long; max key length is 1000 bytes

商品推荐

广告推荐

推荐文章