/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

7 votes134 views1 answer
Ternary operator laravel blade
PHP Laravel
1 vote196 views1 answer
Laravel fixed character limit
PHP Laravel
18 votes129 views6 answers
Install laravel auth
PHP Laravel
2 votes122 views1 answer
Attach multiple files in laravel mailable
PHP Laravel
1 vote142 views2 answers
Laravel query builder sum
PHP Laravel
0 vote162 views1 answer
Laravel where has query
PHP Laravel
26 votes181 views6 answers
Laravel make model with migration and controller
PHP Laravel
2 votes151 views4 answers
Laravel hash password check
PHP Laravel
18 votes141 views6 answers
Laravel form validation
PHP Laravel
7 votes137 views1 answer
Laravel auth user_id
PHP Laravel