/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 votes184 views2 answers
Include and require in php
PHP
60 votes158 views6 answers
Php artisan make migration
PHP
0 vote185 views1 answer
Make a global php function in laravel so that accessed anywhere
PHP Laravel
0 vote165 views1 answer
Preg_split
PHP
9 votes162 views3 answers
How to convert array to string with commas in php
PHP
4 votes278 views3 answers
How to create an associative array in php
PHP
0 vote185 views1 answer
How to Create a Transient PHP wordpress
PHP
0 vote227 views1 answer
Wordpress filter category from widget
PHP
1 vote214 views1 answer
Multi condition inside single if in php
PHP
21 votes163 views6 answers
Php empty array
PHP