/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

6 votes140 views2 answers
Nav active in laravel
PHP Laravel
2 votes139 views2 answers
Get all sort by laravel
PHP Laravel
0 vote143 views1 answer
Laravel range query
PHP Laravel
2 votes130 views1 answer
Global laravel request()
PHP Laravel
-1 vote156 views2 answers
String and number laravel faker
PHP Laravel
0 vote149 views1 answer
Array of dates laravel
PHP Laravel
0 vote154 views1 answer
Laravel one session per user
PHP Laravel
-1 vote143 views1 answer
Create new record via model in laravel
PHP Laravel
1 vote150 views2 answers
Get database name laravel
PHP Laravel
7 votes136 views3 answers
Laravel creat new model
PHP Laravel