/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

5 votes129 views3 answers
Wordpress get fiture image
PHP
1 vote130 views1 answer
How to add properties to the request object
PHP
4 votes154 views4 answers
Laravel carbon today date format
PHP Laravel
0 vote151 views1 answer
Laravel select custom column
PHP Laravel
0 vote122 views1 answer
Hit a simple url using curl in php
PHP
1 vote146 views1 answer
Laravel sprintf span in controller
PHP
5 votes137 views3 answers
Crrate model in laravel
PHP Laravel
6 votes122 views5 answers
Php if url contains
PHP
0 vote191 views1 answer
Check multiple roles with Blade directive @can?
PHP
0 vote120 views1 answer
Big database file into database php
PHP