/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

0 vote166 views4 answers
Date format change in laravel blade
PHP Laravel
1 vote187 views1 answer
Unless blade laravel
PHP Laravel
3 votes169 views3 answers
Laravel csrf-token in view
PHP Laravel
0 vote156 views1 answer
Trait 'laravel\sanctum\HasApiTokens' not found laravel 7
PHP Laravel
-1 vote173 views1 answer
Chrome web driver laravel
PHP Laravel
1 vote157 views1 answer
How to return data in json format in laravel
PHP Laravel
3 votes155 views1 answer
Laravel validation pdf
PHP Laravel
0 vote163 views1 answer
Laravel access request in provider
PHP Laravel
1 vote157 views1 answer
Insert data using model in laravel 8
PHP Laravel
5 votes158 views5 answers
Install laravel 8 with composer
PHP Laravel