安装laravel-admin总是提示这个，是什么原因呢。

r2252342

安装laravel-admin总是提示这个，是什么原因呢。


执行的php artisan admin:install这条命令



错误：
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table

   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 D:\phpstudy_pro\WWW\laravel-admin\vendor\laravel\framework\src\Illuminate\Database\Connection.php:669
    665|         // If an exception occurs when attempting to run a query, we'll format the error
    666|         // message to include the bindings with SQL, which will make this exception a
    667|         // lot more helpful to the developer instead of just the database's errors.
    668|         catch (Exception $e) {
  > 669|             throw new QueryException(
    670|                 $query, $this->prepareBindings($bindings), $e
    671|             );
    672|         }
    673|

  Exception trace:

  1   Doctrine\DBAL\Driver\PDOException:"SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")
      D:\phpstudy_pro\WWW\laravel-admin\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:123

  2   PDOException:"SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")
      D:\phpstudy_pro\WWW\laravel-admin\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:121

  Please use the argument -v to see more details.

xljbear

mysql 版本低于5.7 MyISAM表的主键最大是1000字节，升级mysql

king51

安装页面上面不是写着解决办法吗
https://github.com/z-song/laravel-admin/issues/1541

r2252342

king51 发表于 2020-1-21 11:31
安装页面上面不是写着解决办法吗
https://github.com/z-song/laravel-admin/issues/1541 ...

已解决。非常感谢！