/PHP/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();

Similar codes

23 votes146 views4 answers
Datetime difference in php
PHP
2 votes136 views3 answers
Sort array by date php
PHP
0 vote164 views1 answer
Wordpress function _() not working
PHP Wordpress
0 vote253 views1 answer
Wordpress add class on navigation menu
PHP
1 vote152 views1 answer
Array_last in laravel 8
PHP Laravel
108 votes393 views6 answers
String contains php
PHP
1 vote156 views1 answer
Ffmpeg generate thumbnail in php
PHP
8 votes124 views4 answers
Laravel model soft delete
PHP
0 vote154 views1 answer
Laravel select only some columns relationship
PHP Laravel
0 vote127 views1 answer
Php named parameters
PHP