/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 vote170 views1 answer
Remove public or index file from url in laravel
PHP Laravel
2 votes212 views5 answers
Undefined index: name laravel
PHP Laravel
0 vote178 views1 answer
Datetime-local laravel migration data type
PHP Laravel
0 vote177 views4 answers
Laravel 8: bootstrap
PHP Laravel
4 votes164 views1 answer
Uuid nom package for laravel 18.04
PHP Laravel
7 votes182 views3 answers
Laravel how to call function in same controller
PHP Laravel
5 votes197 views2 answers
Laravel vue
PHP Laravel
8 votes192 views1 answer
Laravel symlink command
PHP Laravel
3 votes179 views1 answer
Laravel validation greater than or equal to
PHP Laravel
0 vote175 views1 answer
Change the date format in laravel view page
PHP Laravel