Subscribe Us

Header Ads

Cara mengatasi error 1071 specified key was too long max key length is 767 bytes Laravel 5.4 dan 5.5

Pada kali ini saya mengalami 1071 Specified key was too long; max key length is 767 bytes error ini muncul ketika kita pertama kali membuat project baru dan melakukan migrate database. Untuk mengatasinya cukup mudah sekali kok. Kita mulai cara mengatasinya ya.

Error :

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

Error tersebut terkadang muncul di Laravel 5.4 dan Laravel 5.5

1. Buka file "app/Providers/AppServiceProviders.php"

Letakkan Schema::defaultStringLength(191); pada function boot();

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;

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

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

Coba kembali lakukan migrate database. Error akan ilang. Mantapp

Post a Comment

0 Comments