/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 vote309 views1 answer
Laravel create new file if not exists
PHP Laravel
27 votes305 views3 answers
Laravel what is migrations
PHP Laravel
1 vote340 views1 answer
Static function model laravel
PHP Laravel
1 vote302 views2 answers
Get the unique rows from table laravel
PHP Laravel
0 vote320 views1 answer
Laravel number input positive only
PHP Laravel
-2 votes291 views4 answers
Laravel get ID from insert
PHP Laravel
0 vote344 views1 answer
Send emails with runtime configurations in laravelk
PHP Laravel
0 vote266 views2 answers
Sortbydesc on a collection laravel
PHP Laravel
7 votes300 views3 answers
Laravel where has
PHP Laravel
0 vote320 views1 answer
Laravel with callback
PHP Laravel