/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

18 votes300 views6 answers
Wherein laravel
PHP
0 vote312 views1 answer
Map associative array php0
PHP
4 votes355 views3 answers
Get current route in blade laravel
PHP Laravel
0 vote265 views1 answer
Size array php
PHP
22 votes383 views2 answers
Where status is null sql in laravel
PHP Laravel
0 vote306 views2 answers
Collection get first element laravel
PHP Laravel
1 vote353 views1 answer
Undefined type auth
PHP
4 votes318 views1 answer
Db enable query log
PHP
0 vote324 views2 answers
Remove slashes from json php
PHP
1 vote305 views1 answer
Php session working on localhost but not on hosting server
PHP