/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

0 vote267 views1 answer
What was the old name of PHP?
PHP
0 vote268 views1 answer
How to include page specific css in xphp smart header
PHP
0 vote310 views1 answer
Group_concat mysql limit issue
PHP
19 votes323 views6 answers
Laravel date validation
PHP Laravel
0 vote286 views1 answer
Check if object has method php
PHP
4 votes319 views5 answers
Laravel get first record
PHP
0 vote327 views1 answer
If home else php wordpress
PHP Wordpress
1 vote286 views1 answer
Custom column for latest() laravel
PHP Laravel
2 votes329 views3 answers
Php remove html tag
PHP
0 vote235 views1 answer
Mailgun composer
PHP