/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

0 vote270 views1 answer
Null check nested object laravel
PHP
14 votes272 views4 answers
Php get index of string
PHP
55 votes281 views6 answers
Php time format
PHP
1 vote301 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP
5 votes283 views2 answers
Set unique value validation for laravel form request
PHP
12 votes286 views4 answers
Php open csv
PHP
0 vote334 views1 answer
Laravel not rollback even has error
PHP Laravel
3 votes331 views1 answer
How to named route resource laravel
PHP Laravel
1 vote303 views1 answer
Laravel nova 3 belongtomany don't display
PHP Laravel
0 vote293 views1 answer
Variable "$id" is not defined by operation "GetPost".
PHP