/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 vote157 views1 answer
Get all users created in a month laravel
PHP Laravel
1 vote155 views1 answer
Laravel password verification
PHP Laravel
2 votes140 views3 answers
Laravel auth check login
PHP Laravel
2 votes157 views2 answers
Laravel many to many update all pivot
PHP Laravel
2 votes155 views3 answers
Where is in array laravel
PHP Laravel
1 vote145 views1 answer
How to store an image in laravel directly from url
PHP Laravel
26 votes187 views6 answers
Carbon in laravel
PHP Laravel
2 votes111 views2 answers
Find in string laravel
PHP Laravel
0 vote156 views1 answer
Query relationships laravel and select some columns
PHP Laravel
8 votes143 views6 answers
Laravel command not found
PHP Laravel