/PHP/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();

Similar codes

1 vote131 views2 answers
How many users can a cron handle in laravel in single run
PHP Laravel
1 vote122 views1 answer
Query sort alphabetically wp
PHP
6 votes100 views1 answer
Route params link laravel
PHP
0 vote136 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 vote111 views1 answer
Php trim string if longer than
PHP
35 votes140 views3 answers
Run seeder command in laravel
PHP Laravel
1 vote122 views1 answer
Google translate api php
PHP
0 vote123 views1 answer
Using laravel passport with mongodb
PHP Laravel
1 vote177 views1 answer
Laravel old value or default
PHP
32 votes133 views4 answers
Laravel seed fresh
PHP Laravel