laravel default username & password migration error

Question

In Connection.php line 647:

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

In Connection.php line 449:

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

How can i solve this??

When i want to migrate default migrations in CMD this error happens.

Possible duplicate of Laravel migration: unique key is too long, even if specified — Illia Yaremchuk
– Illia Yaremchuk, Commented Jan 31, 2018 at 9:07
Set a shorter key length? You've set your email field to a really long value? Can you post the table structure? — G_V
– G_V, Commented Jan 31, 2018 at 9:27
well this is because mySQL indexes are only available for string that has length lower than 192 .. you may want to change the defaultStringLength .. — Demonyowh
– Demonyowh, Commented Jan 31, 2018 at 10:03

Prince Lionel N'zi · Accepted Answer · 2018-01-31 09:04:53Z

4

Add this to your AppServiceProvider.php file:

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

This article by Laravel News explains it

answered Jan 31, 2018 at 9:04

Prince Lionel N'zi

2,5882 gold badges14 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Illia Yaremchuk · Accepted Answer · 2018-01-31 09:04:59Z

2

For Laravel 5.4 add code in AppServiceProvider.php

use Illuminate\Support\Facades\Schema;

and in boot

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

answered Jan 31, 2018 at 9:04

Illia Yaremchuk

2,0232 gold badges22 silver badges38 bronze badges

Collectives™ on Stack Overflow

laravel default username & password migration error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related