/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

1 vote169 views1 answer
Laravel s3 presigned url
PHP Laravel
0 vote263 views1 answer
ErrorException Undefined index(laravel 7 array helpers)
PHP Laravel
2 votes160 views2 answers
404 page in laravel
PHP Laravel
0 vote211 views1 answer
Laravel simplexmlelement not found
PHP Laravel
0 vote162 views1 answer
Laravel 8 date difference in days
PHP Laravel
1 vote165 views2 answers
Laravel gmail
PHP Laravel
0 vote171 views1 answer
Laravel subtract date
PHP Laravel
1 vote170 views1 answer
Laravel increment column value in update query
PHP Laravel
6 votes173 views3 answers
Laravel ecommerce
PHP Laravel
12 votes197 views2 answers
Tomorrow carbon laravel
PHP Laravel