【laravel5.8】 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long； max

最新推荐文章于 2025-01-17 22:45:50 发布

隔壁小白

最新推荐文章于 2025-01-17 22:45:50 发布

阅读量241

点赞数

分类专栏： php laravel 文章标签： laravel php composer

本文链接：https://blog.youkuaiyun.com/cbaln0/article/details/110132090

版权

php 同时被 2 个专栏收录

18 篇文章

订阅专栏

laravel

1 篇文章

订阅专栏

博客提到在app\Providers\AppServiceProvider.php文件中添加默认值，涉及PHP开发相关操作，与Laravel框架可能存在关联，Composer或许也会在开发流程中起到作用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

D:\wwwroot\www.test.com>php artisan admin:install
Migration table created successfully.

In Connection.php line 664:

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


In Connection.php line 458:

  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

在app\Providers\AppServiceProvider.php添加默认值

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema; //add fixed sql

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        Schema::defaultStringLength(191); //add fixed sql
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}