/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

15 votes147 views6 answers
Laravel custom validation message
PHP Laravel
0 vote143 views2 answers
How to update dropdown value in laravel
PHP Laravel
0 vote157 views1 answer
Laravel return a single dimensional array
PHP Laravel
12 votes147 views2 answers
Debug bar laravel print array
PHP Laravel
0 vote156 views1 answer
Laravel datatable render html
PHP Laravel
0 vote150 views1 answer
Laravel disable config cache
PHP Laravel
0 vote162 views1 answer
Laravel sanctum Provoking tokens
PHP Laravel
0 vote172 views1 answer
Laravel old value not working in textarea
PHP Laravel
-1 vote157 views3 answers
@forelse laravel
PHP Laravel
4 votes153 views4 answers
Laravel check if table has column
PHP Laravel