Home / Questions / 263064
Accepted
elapez
Asked: 2020-05-14 06:16:42 +0800 CST 2020-05-14 06:16:42 +0800 CST

Error with php artisan migrate

  • 772

I am using xampp, php 7.1.1, laravel 5.5, MySQL(MariaDB), all in a windows environment.

when I try to set the initial migration it gives me the following response

$ php artisan migrate
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 767 bytes (SQL: 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 767 bytes

As a result, it effectively creates the users table (users) and another "migrations" table, but it does not create the "password reset" table

What am I missing?

laravel

1 Answers

  1. Best Answer

    This is a fairly common error, doing some research I found this article where it explains the reason for this failure.

    What happens is that Laravel by default works in 'utf8mb4' and if you are using MySQL > 5.7.7 or MariaDB > 10.2.2 you must specify the default size of strings.

    The only thing you would have to do is add this to the AppServiceProvider:

    use Illuminate\Support\Facades\Schema;

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

    It is a fairly common problem. It's been a while since I touched laravel in depth, but the same thing that happens to you always happened to me.

    EDIT

    I have also found this in the Laravel documentation , where they themselves tell you to write what I just put above

    • 3