Support the ongoing development of Laravel.io →
Cache Database Testing
Last updated 2 years ago.
0

I think I've done it. I believe "user_id" needed to be an index key so I changed:

            $table->integer('user_id');

with

            $table->integer('user_id')->unsigned()->index();
0

i faced this error too. normally, i add foreign keys as a separate migration. // Schema::table('users', function(Blueprint $table){$table->integer('user_id')->unsigned()->index()->nullable();});

and ...add nullable() to the key as well.

// $table->integer('user_id')->unsigned()->index()->nullable();

0

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.