/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

26 votes375 views6 answers
Laravel model with migration
PHP Laravel
19 votes340 views6 answers
Laravel date validation
PHP Laravel
4 votes338 views4 answers
Installing laravel 8
PHP Laravel
0 vote432 views1 answer
Pass array from controller laravel with compact
PHP Laravel
8 votes372 views4 answers
Laravel between dates
PHP Laravel
1 vote341 views2 answers
Scheduling in laravel in custom cron
PHP Laravel
0 vote373 views1 answer
Entrust laravel
PHP Laravel
0 vote318 views1 answer
Laravel eloquent return array where
PHP Laravel
39 votes322 views6 answers
Create foreign key laravel migration
PHP Laravel
4 votes347 views2 answers
Laravel collection random
PHP Laravel