/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

4 votes190 views3 answers
Laravel description substring
PHP Laravel
2 votes207 views6 answers
Laravel get query parameters
PHP Laravel
1 vote192 views1 answer
How to change laravel 8 login credentials
PHP Laravel
0 vote206 views1 answer
Order table in laravel
PHP Laravel
1 vote198 views1 answer
Laravel apache2
PHP Laravel
0 vote205 views1 answer
Laravel many to many relation update
PHP Laravel
1 vote199 views1 answer
Invalid datetime format laravel
PHP Laravel
5 votes188 views5 answers
Install laravel 8 with composer
PHP Laravel
4 votes193 views1 answer
Disable register laravel
PHP Laravel
2 votes146 views1 answer
Laravel get file name
PHP Laravel