laravel-vue-starter icon indicating copy to clipboard operation
laravel-vue-starter copied to clipboard

migrate error using mysql: Cannot add foreign key constraint

Open LarryEitel opened this issue 7 years ago • 1 comments

I set db to mysql and when I run migrate I get:

[Illuminate\Database\QueryException]

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `users` add constraint `users_sp_id_foreign` foreign key (`sp_id`) references `users` (`id`))

LarryEitel avatar Jul 02 '17 14:07 LarryEitel

well you can remove that its not necessary , unless you need it... ill update it soon, but you can remove that column that should clear out

codeitlikemiley avatar Jul 15 '17 13:07 codeitlikemiley