/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

5 votes176 views4 answers
Laravel auth register false
PHP Laravel
0 vote191 views1 answer
How to update a table based on three columns laravel
PHP Laravel
1 vote180 views1 answer
How to save data from api to laravel
PHP Laravel
0 vote182 views2 answers
General error: 1215 Cannot add foreign key constraint laravel
PHP Laravel
0 vote202 views1 answer
Polymorph laravel return order by
PHP Laravel
8 votes204 views4 answers
Laravel hash password sample
PHP Laravel
1 vote185 views1 answer
Get value by today yesterday in laravel
PHP Laravel
2 votes188 views2 answers
Laravel sidebar menu active
PHP Laravel
0 vote190 views1 answer
How to extract code from controller to helpers or other method in laravel
PHP Laravel
0 vote184 views1 answer
How to stop message of laravel mix
PHP Laravel