/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

2 votes323 views2 answers
Laravel eloquent multiple primary key
PHP Laravel
0 vote359 views1 answer
Php increment sum
PHP
0 vote306 views1 answer
Laravel eloquent select one column in array
PHP
3 votes282 views2 answers
Php date timestamp now
PHP
2 votes315 views6 answers
Get last id in laravel
PHP
0 vote326 views3 answers
Php echo call javascript function with parameters
PHP
0 vote395 views2 answers
Laravel auth login with phone or email
PHP Laravel
11 votes348 views4 answers
Install phpmyadmin ubuntu 18.04
PHP
0 vote306 views1 answer
Edit a row from databse using php
PHP
0 vote304 views1 answer
Php check if cli mode
PHP