/PHP/Laravel/Errno: 150 foreign key constraint is incorrectly formed laravel 8

Errno: 150 foreign key constraint is incorrectly formed laravel 8

Since increments() creates an unsigned integer column, you need to define the foreign key column as unsigned integer too.

Default migrations in Laravel 6+ use bigIncrements(), so you need to use unsignedBigInteger() method:

$table->unsignedBigInteger('order_id');
https://laravel.com/docs/6.x/migrations#foreign-key-constraints

For default migrations in older versions of Laravel use unsignedInteger() method:

$table->unsignedInteger('order_id');
Or:

$table->integer('order_id')->unsigned();

-2

Similar codes

0 vote359 views1 answer
Query without chaining not working - Laravel
PHP Laravel
0 vote359 views1 answer
Str not found laravel
PHP Laravel
3 votes305 views1 answer
Laravel policy create
PHP Laravel
10 votes334 views2 answers
Laravel route list
PHP Laravel
0 vote353 views1 answer
Laravel return a single dimensional array
PHP Laravel
0 vote352 views1 answer
Create a button add in laravel
PHP Laravel
0 vote383 views1 answer
Formate date using carbon in laravel blade
PHP Laravel
7 votes358 views3 answers
Laravel search function
PHP Laravel
0 vote360 views1 answer
Laravel store mail driver info in database
PHP Laravel
1 vote333 views1 answer
Return response array laravel
PHP Laravel