/PHP/Laravel/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();

-2

Similar codes

0 vote225 views1 answer
Laravel doesn't work update
PHP Laravel
0 vote236 views1 answer
Laravel enable extensions on Ubuntu
PHP Laravel
5 votes221 views1 answer
Laravel model method like foreach parts of
PHP Laravel
0 vote254 views1 answer
Laravel asset prevent browser caching
PHP Laravel
3 votes257 views1 answer
Laravel e commerce full project
PHP Laravel
50 votes589 views6 answers
Laravel migration add column to existing table
PHP Laravel
3 votes233 views3 answers
Laravel sort by function'
PHP Laravel
2 votes249 views4 answers
Laravel hash password check
PHP Laravel
5 votes221 views3 answers
Enum table in laravel
PHP Laravel
19 votes204 views5 answers
Php artisan auth in laravel 8
PHP Laravel