/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

2 votes122 views1 answer
Php routing
PHP
0 vote137 views1 answer
Date format with t and z php
PHP
6 votes167 views4 answers
Get template directory uri
PHP
0 vote124 views1 answer
Calculate average in eager loading laravel
PHP
0 vote121 views1 answer
$e = array("red", "green", "blue"); echo intval($e) . "<br>";
PHP
0 vote84 views1 answer
Not have permision elgg settings.php
PHP
0 vote138 views1 answer
WooCommerce Catalog Mode snippets
PHP
4 votes128 views4 answers
Php timestamp
PHP
0 vote143 views1 answer
Carbon equal dates
PHP
21 votes124 views3 answers
How to get ip address of pc in php
PHP