/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

39 votes173 views3 answers
Add column in laravel migration cmnd
PHP Laravel
4 votes156 views4 answers
Installing laravel 8
PHP Laravel
49 votes229 views6 answers
Laravel clear all cache
PHP Laravel
0 vote160 views2 answers
Laravel collection every
PHP Laravel
1 vote175 views1 answer
Why job laravel do not worl
PHP Laravel
16 votes163 views6 answers
Laravel redirect back
PHP Laravel
0 vote167 views3 answers
Laravel select default old value
PHP Laravel
4 votes159 views2 answers
Laravel reduce
PHP Laravel
28 votes241 views12 answers
Laravel middleware
PHP Laravel
0 vote157 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP Laravel