/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 vote122 views1 answer
Post request data not getting from guzzle laravel
PHP Laravel
2 votes118 views2 answers
Laravel migration two primary key
PHP Laravel
5 votes120 views2 answers
Route() and with() in laravel
PHP Laravel
1 vote114 views3 answers
Print query statement in laravel
PHP Laravel
9 votes120 views4 answers
Add another field in existing migration laravel
PHP Laravel
0 vote124 views1 answer
Comment installer laravel avec docker
PHP Laravel
0 vote138 views1 answer
Laravel vue error 500
PHP Laravel
0 vote107 views1 answer
Laravel hiding attributes JSON
PHP Laravel
3 votes104 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP Laravel
1 vote56 views1 answer
Laravel data types
PHP Laravel