/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

8 votes314 views1 answer
Laravel custom attributes
PHP Laravel
0 vote322 views4 answers
Installing bootstrap ui in laravel app
PHP Laravel
2 votes299 views4 answers
Laravel redirect action
PHP Laravel
4 votes289 views2 answers
Laravel carbon get month name español
PHP Laravel
46 votes379 views5 answers
Add column migration laravel
PHP Laravel
0 vote349 views1 answer
Laravel download file change name
PHP Laravel
5 votes325 views5 answers
Laravel composer update
PHP Laravel
0 vote336 views1 answer
Laravel import csv to database
PHP Laravel
0 vote341 views1 answer
Laravel select only some columns relationship
PHP Laravel
0 vote328 views1 answer
Laravel random value from array
PHP Laravel