/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

1 vote111 views1 answer
Cakephp 4 change layout view in a method
PHP
0 vote119 views1 answer
Discord.py Levels
PHP
0 vote135 views1 answer
Use s3 storage laravel
PHP Laravel
14 votes135 views3 answers
How to convert string to int in php laravel
PHP Laravel
1 vote118 views1 answer
Php reset mysql array
PHP
10 votes94 views5 answers
How to remove public from url in laravel
PHP
1 vote117 views1 answer
Phpspreadsheet edit excel file
PHP
15 votes120 views6 answers
Remove spaces from string php
PHP
0 vote105 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP
1 vote119 views1 answer
Merge two objects in php
PHP