/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 vote444 views2 answers
Laravel composite unique key
PHP Laravel
0 vote385 views1 answer
How to separate admin and user login in laravel
PHP Laravel
2 votes415 views2 answers
Public_path laravel
PHP Laravel
0 vote372 views2 answers
Sweet alert confirm box laravel
PHP Laravel
0 vote413 views1 answer
Laravel stack script
PHP Laravel
0 vote387 views1 answer
Laravel DB facade relations
PHP Laravel
1 vote359 views1 answer
Invalid datetime format laravel
PHP Laravel
0 vote443 views1 answer
Laravel request query logger
PHP Laravel
1 vote413 views1 answer
Laravel password verification
PHP Laravel
3 votes358 views3 answers
Laravel get a url using name
PHP Laravel