/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 vote252 views1 answer
Back() with errors in laravel
PHP Laravel
7 votes216 views6 answers
Laravel get url path
PHP Laravel
5 votes252 views4 answers
App url laravel
PHP Laravel
2 votes265 views6 answers
Get last id in laravel
PHP Laravel
3 votes213 views1 answer
Run laravel cron job on cpanel
PHP Laravel
12 votes324 views6 answers
Email validation in laravel
PHP Laravel
3 votes198 views1 answer
Laravel middleware route
PHP Laravel
0 vote243 views1 answer
Laravel count the types of users
PHP Laravel
0 vote219 views1 answer
Laravel eloquent order by alphabetical order
PHP Laravel
1 vote229 views1 answer
Laravel controller return message
PHP Laravel