Laravel Migration Error : Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes laravel 5.3

Question

[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter tabl e users add unique users_email_unique(email))

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

whats wrong? im using laravel 5.3

Possible duplicate of [Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes](https://stackoverflow.com/questions/42244541/laravel-migration-error-syntax-error-or-access-violation-1071-specified-key-wa) — Ashutosh Sharma, May 21 '18 at 07:28

score 7 · Answer 1 · answered Apr 13 '17 at 05:56

7

Refering to Laravel News and Laravel's migration guide:

As outlined in the Migrations guide to fix this all you have to do is edit your AppServiceProvider.php file and inside the boot method set a default string length:

use Illuminate\Support\Facades\Schema;

function boot()
{
    Schema::defaultStringLength(191);
}

answered Apr 13 '17 at 05:56

SteD

13,331
12
60
74

1

not work... this work in laravel 5.4 i try in laravel 5.3 i get the same error – muzamil indra Apr 13 '17 at 06:06
This worked for me when using the default `config\database.php` settings `'engine' => null` – mstephenson Apr 22 '20 at 17:35

score 2 · Answer 2 · answered Feb 03 '18 at 17:23

open create_user_tabel and then write one line inside up function.
  Schema::defaultStringLength(191);
e.g

    public function up()
    {      
      Schema::defaultStringLength(191);

    Schema::create('users', function (Blueprint $table) {
                $table->increments('id');
                $table->string('name');
                $table->string('email')->unique();
                $table->string('password');
                $table->rememberToken();
                $table->timestamps();
    }

It will work 100%.

score 0 · Answer 3 · answered Apr 13 '17 at 06:32

0

That error comes from the database basically..If you try to increase the length of that column by phpmyadmin, you will get the same error.

answered Apr 13 '17 at 06:32

Muhammad Rizwan

438
7
20

score 0 · Answer 4 · answered May 01 '17 at 15:25

As outlined in the Migrations guide to fix this all you have to do is edit your AppServiceProvider.php file and inside the boot method set a default string length:

use Illuminate\Support\Facades\Schema;

public function boot(){
    Schema::defaultStringLength(191);
}

After that everything should work as normal.

score 0 · Answer 5 · answered Nov 15 '18 at 14:43

In case, the above solutions or the official solution which is adding

Schema::defaultStringLength(191);

doesn't work. Try to edit the database.php file in config folder. Just edit

'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',

to

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',

and it should work. Hope it helps.

score 0 · Answer 6 · answered May 02 '21 at 07:08

0

Update your /app/Providers/AppServiceProvider.php to contain:

use Illuminate\Support\Facades\Schema;

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

answered May 02 '21 at 07:08

Hedayatullah Sarwary

1,063
9
19

Laravel Migration Error : Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes laravel 5.3

6 Answers6