/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

2 votes238 views3 answers
Laravel auth check login
PHP Laravel
0 vote195 views1 answer
Laravel routes options
PHP Laravel
9 votes233 views5 answers
Laravel create password hash
PHP Laravel
0 vote230 views4 answers
Image Upload in Laravel
PHP Laravel
0 vote154 views1 answer
Laravel collection take
PHP Laravel
0 vote227 views1 answer
Laravel - Comparison betweeon two column values - whereColumn
PHP Laravel
1 vote267 views1 answer
How to catch query exception in laravel 8
PHP Laravel
0 vote227 views1 answer
Laravel response download video laravel medialibrary
PHP Laravel
4 votes221 views4 answers
Laravel update query builder
PHP Laravel
6 votes224 views2 answers
Laravel : commande introuvable
PHP Laravel