/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 vote149 views1 answer
Laravel ID Generator
PHP Laravel
1 vote155 views1 answer
Laravel group by created_at date only
PHP Laravel
3 votes141 views2 answers
Laravel base table or view not found hasmany
PHP Laravel
0 vote142 views4 answers
Date format change in laravel blade
PHP Laravel
0 vote145 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP Laravel
1 vote138 views3 answers
Import faker in laravel
PHP Laravel
-2 votes145 views1 answer
Laravel model bind with route in model
PHP Laravel
-1 vote127 views3 answers
Grouping route in laravel
PHP Laravel
0 vote219 views2 answers
Array collapse laravel
PHP Laravel
4 votes133 views4 answers
Multiple middleware laravel
PHP Laravel