/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 vote352 views1 answer
Make model inside module laravel
PHP Laravel
7 votes200 views2 answers
Laravel carbon get month number
PHP Laravel
0 vote204 views1 answer
Sort by number of views descending laravel
PHP Laravel
1 vote178 views1 answer
Laravel bindings query
PHP Laravel
0 vote332 views4 answers
Findmany laravel
PHP Laravel
1 vote184 views2 answers
Laravel add attribute to model
PHP Laravel
3 votes200 views6 answers
Laravel cors
PHP Laravel
0 vote214 views1 answer
Laravelda urlga requestlarni cheklash
PHP Laravel
11 votes193 views3 answers
Laravel running a specific migration on different path
PHP Laravel
0 vote213 views1 answer
Laravel collection intersectKey
PHP Laravel