coreui-free-laravel-admin-template icon indicating copy to clipboard operation
coreui-free-laravel-admin-template copied to clipboard

Published 20 hours ago • verified publisher icon coreui

ERROR While Migrating

Open thomas-tahmasebi opened this issue 5 years ago • 2 comments

Migrating: 2014_10_12_000000_create_users_table

Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter tableusersadd uniqueusers_email_unique(email))

thomas-tahmasebi avatar Jan 01 '20 12:01 thomas-tahmasebi

This looks like a problem with the database itself, not with our project. I suggest you change the database engine and check if the problem still exists. By the way, which database is causing the problem?

rakieta2015 avatar Jan 02 '20 09:01 rakieta2015

Check this thread: https://github.com/laravel/framework/issues/17508

The solutions there are either editing app/Providers/AppServiceProvider.php or config/database.php

Both solutions got me past that issue to the next issue...

williamwithin avatar Jan 15 '20 18:01 williamwithin