/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

2 votes358 views3 answers
Where is in array laravel
PHP Laravel
19 votes359 views6 answers
Laravel Route Group
PHP Laravel
8 votes323 views1 answer
Laravel get variable from url
PHP Laravel
9 votes354 views3 answers
Laravel load view in variable
PHP Laravel
0 vote350 views1 answer
Composer require laravelcollection
PHP Laravel
0 vote363 views1 answer
Updateorinsert laravel for large data
PHP Laravel
0 vote351 views1 answer
Laravel follow and unfollow relationship
PHP Laravel
2 votes341 views2 answers
Laravel dropIndex
PHP Laravel
1 vote325 views1 answer
Persian error laravel
PHP Laravel
47 votes385 views6 answers
How to run specific seeder in laravel
PHP Laravel