/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

12 votes274 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
18 votes192 views3 answers
Php try to decode json
PHP
0 vote214 views1 answer
Laravel route not calling function of controller
PHP Laravel
0 vote198 views1 answer
Find distance between two coordinate in php
PHP
5 votes180 views5 answers
Laravel csrf token off
PHP
0 vote212 views1 answer
Laravel return redirect by stuckOverFlow
PHP Laravel
0 vote179 views2 answers
Php 5.6 xampp
PHP
0 vote181 views1 answer
One-through-many
PHP
1 vote187 views1 answer
How get the latest data in database in laravel
PHP
26 votes203 views6 answers
Header php location
PHP