/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

0 vote222 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
50 votes263 views6 answers
Laravel database seeder
PHP Laravel
3 votes244 views1 answer
Back route laravel
PHP Laravel
6 votes245 views4 answers
Laravel set config
PHP Laravel
0 vote242 views1 answer
How to calculate age using query builder in laravel?
PHP Laravel
0 vote215 views3 answers
Laravel has many deep
PHP Laravel
2 votes233 views1 answer
Laravel mix purge css
PHP Laravel
9 votes172 views2 answers
Laravel collection filter
PHP Laravel
-1 vote251 views1 answer
When to create a service in laravel
PHP Laravel
0 vote233 views1 answer
Laravel factory get foreign key
PHP Laravel