/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

12 votes222 views6 answers
Laravel json response
PHP Laravel
0 vote204 views1 answer
Laravel make view command
PHP Laravel
0 vote193 views2 answers
Create model controller migration factory laravel in one command
PHP Laravel
0 vote226 views1 answer
Check Data Load More Laravel Livewire
PHP Laravel
0 vote210 views1 answer
Update laravel .env variables dynamically
PHP Laravel
3 votes212 views3 answers
Laravel clear table
PHP Laravel
1 vote202 views2 answers
Laravel model set new attribute
PHP Laravel
9 votes225 views5 answers
Laravel exist
PHP Laravel
1 vote200 views1 answer
Laravel not finding asset files in public directory
PHP Laravel
1 vote239 views1 answer
Password validation rules laravel
PHP Laravel