/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

3 votes224 views6 answers
Add to collection laravel
PHP Laravel
0 vote225 views2 answers
Laravel store file
PHP Laravel
30 votes230 views6 answers
Laravel migration column types
PHP Laravel
0 vote330 views1 answer
Schema key issue laravel
PHP Laravel
1 vote214 views1 answer
Searchable dropdown laravel blade
PHP Laravel
5 votes215 views2 answers
Laravel jetstream livewire
PHP Laravel
3 votes220 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel
0 vote252 views1 answer
Laravel allow null records relationship
PHP Laravel
5 votes233 views2 answers
Laravel print exception message
PHP Laravel
1 vote215 views1 answer
Laravel doesNotHave in model
PHP Laravel