/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

0 vote232 views2 answers
Steps to create laravel project
PHP
0 vote217 views1 answer
Enhanced ecommerce data layer for woocommerce
PHP
0 vote233 views1 answer
Pagination in codeigniter with example
PHP
15 votes220 views3 answers
Php inline if
PHP
6 votes236 views2 answers
Get size files in laravel
PHP Laravel
0 vote236 views1 answer
Laravel migration add date of birth column
PHP
7 votes214 views6 answers
Php get url parameter
PHP
0 vote238 views1 answer
Use the DebugBar like an array where keys are the collector names
PHP
0 vote217 views7 answers
Php
PHP
6 votes217 views2 answers
Login selected user laravel
PHP