{"id":20106,"date":"2020-02-06T11:10:11","date_gmt":"2020-02-06T03:10:11","guid":{"rendered":"http:\/\/4563.org\/?p=20106"},"modified":"2020-02-06T11:10:11","modified_gmt":"2020-02-06T03:10:11","slug":"%e5%ae%89%e8%a3%85laravel-admin%e6%80%bb%e6%98%af%e6%8f%90%e7%a4%ba%e8%bf%99%e4%b8%aa%ef%bc%8c%e6%98%af%e4%bb%80%e4%b9%88%e5%8e%9f%e5%9b%a0%e5%91%a2%e3%80%82","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=20106","title":{"rendered":"\u5b89\u88c5laravel-admin\u603b\u662f\u63d0\u793a\u8fd9\u4e2a\uff0c\u662f\u4ec0\u4e48\u539f\u56e0\u5462\u3002"},"content":{"rendered":"\n

\t\t\t\t\tr2252342<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-1-21 11:20:34\t<\/p>\n

\u5b89\u88c5laravel-admin\u603b\u662f\u63d0\u793a\u8fd9\u4e2a\uff0c\u662f\u4ec0\u4e48\u539f\u56e0\u5462\u3002<\/h3>\n

\u5b89\u88c5laravel-admin\u603b\u662f\u63d0\u793a\u8fd9\u4e2a\uff0c\u662f\u4ec0\u4e48\u539f\u56e0\u5462\u3002<\/p>\n

\u6267\u884c\u7684php artisan admin:install\u8fd9\u6761\u547d\u4ee4<\/p>\n

\u9519\u8bef\uff1a
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table<\/p>\n

   IlluminateDatabaseQueryException: SQLSTATE: 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`))<\/p>\n

at D:phpstudy_proWWWlaravel-adminvendorlaravelframeworksrcIlluminateDatabaseConnection.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|<\/p>\n

Exception trace:<\/p>\n

1   DoctrineDBALDriverPDOException::("SQLSTATE: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")
      D:phpstudy_proWWWlaravel-adminvendordoctrinedballibDoctrineDBALDriverPDOStatement.php:123<\/p>\n

2   PDOException::("SQLSTATE: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")
      D:phpstudy_proWWWlaravel-adminvendordoctrinedballibDoctrineDBALDriverPDOStatement.php:121<\/p>\n

Please use the argument -v to see more details. \t\t\t\t<\/p>\n

\t\t\t\t\txljbear<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-1-21 11:31:16\t<\/p>\n

<\/h3>\n

\t\tmysql \u7248\u672c\u4f4e\u4e8e5.7 MyISAM\u8868\u7684\u4e3b\u952e\u6700\u5927\u662f1000\u5b57\u8282\uff0c\u5347\u7ea7mysql\t\t\t\t<\/p>\n

\t\t\t\t\tking51<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-1-21 11:31:41\t<\/p>\n

<\/h3>\n

\t\tyc014t \u5b89\u88c5\u9875\u9762\u4e0a\u9762\u4e0d\u662f\u5199\u7740\u89e3\u51b3\u529e\u6cd5\u5417
https:\/\/github.com\/z-song\/laravel-admin\/issues\/1541\t\t\t\t<\/p>\n

\t\t\t\t\tr2252342<\/strong> \t\t\t\t\u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-1-21 12:12:01\t<\/p>\n

<\/h3>\n

\t\tking51 \u5927\u4f6c\u6709\u8bdd\u8bf4 : 2020-1-21 11:31
\u5b89\u88c5\u9875\u9762\u4e0a\u9762\u4e0d\u662f\u5199\u7740\u89e3\u51b3\u529e\u6cd5\u5417
https:\/\/github.com\/z-song\/laravel-admin\/issues\/1541 …<\/p>\n

\u5df2\u89e3\u51b3\u3002\u975e\u5e38\u611f\u8c22\uff01\t\t\t <\/p>\n","protected":false},"excerpt":{"rendered":"

r2252342 \u5927\u4f6c\u6709\u8bdd\u8bf4 : …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/20106"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20106"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/20106\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20106"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}