/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 vote260 views1 answer
Laravel use npm package
PHP Laravel
21 votes261 views2 answers
Long text in laravel migration
PHP Laravel
-1 vote238 views1 answer
Laravel set production
PHP Laravel
39 votes227 views6 answers
Foreign key laravel migration
PHP Laravel
37 votes276 views4 answers
Foreign key in laravel migration
PHP Laravel
16 votes244 views4 answers
Add foreign key column laravel 5.8
PHP Laravel
1 vote274 views1 answer
What is app_env in laravel
PHP Laravel
0 vote241 views4 answers
Share var in a maser layout laravel
PHP Laravel
1 vote240 views1 answer
How check if variable is resgister in laravel
PHP Laravel
0 vote246 views1 answer
Snactum laravel
PHP Laravel