/PHP/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();

Similar codes

7 votes337 views3 answers
Get price woocommerce product
PHP
0 vote327 views2 answers
A php session was created by a session_start()
PHP
0 vote446 views1 answer
Delete previous uploaded image when update laravel
PHP Laravel
1 vote315 views1 answer
Date format in laravel month name day name
PHP
0 vote327 views1 answer
Laravel firstorcreate with multiple parameters
PHP
0 vote315 views1 answer
Docker : from php alpine
PHP
1 vote388 views1 answer
Use app name in laravel blade
PHP Laravel
1 vote290 views2 answers
Laravel validate video
PHP
0 vote315 views1 answer
Double in migration laravel
PHP
3 votes334 views5 answers
Laravel delete multiple rows
PHP