/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

7 votes229 views5 answers
Search laravel
PHP Laravel
0 vote139 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel
9 votes107 views1 answer
Npm run dev error laravel 8
PHP Laravel
1 vote144 views1 answer
Insert data using model in laravel 8
PHP Laravel
1 vote232 views1 answer
Mysqli_query insert in laravel
PHP Laravel
2 votes143 views3 answers
Laravel web php request to redirect to another page
PHP Laravel
0 vote159 views1 answer
Laravel collection reject
PHP Laravel
1 vote150 views1 answer
Php laravel string substring
PHP Laravel
13 votes179 views5 answers
Zsh: command not found: laravel
PHP Laravel
0 vote150 views1 answer
Update laravel .env variables dynamically
PHP Laravel