/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

8 votes242 views3 answers
Laravel log query for model
PHP Laravel
0 vote215 views1 answer
Get url parameter laravel 5.2 constructor
PHP Laravel
1 vote237 views1 answer
Laravel artisan progress bar
PHP Laravel
1 vote202 views1 answer
How get the latest data in database in laravel
PHP Laravel
0 vote246 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP Laravel
2 votes220 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP Laravel
12 votes224 views2 answers
Get current authenticated user laravel
PHP Laravel
0 vote225 views1 answer
Laravel DB facade relations
PHP Laravel
0 vote191 views1 answer
Laravel migrate specific path
PHP Laravel
2 votes205 views1 answer
Laravel scheduler every 2 hours
PHP Laravel