/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

20 votes249 views3 answers
Make specific migration laravel
PHP Laravel
0 vote263 views1 answer
Edit items in Laravel collection
PHP Laravel
1 vote254 views2 answers
Laravel route group middleware prefix
PHP Laravel
3 votes240 views1 answer
Laravel validate max file size
PHP Laravel
4 votes245 views4 answers
Multiple middleware laravel
PHP Laravel
3 votes221 views3 answers
Loop index foreach laravel
PHP Laravel
0 vote259 views4 answers
Join table laravel count
PHP Laravel
0 vote241 views1 answer
Country code validation in laravel
PHP Laravel
0 vote223 views3 answers
Laravel how to fetch user from user model based on id from post
PHP Laravel
1 vote375 views1 answer
Tutorial crud laravel VueJS
PHP Laravel