/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 vote213 views3 answers
Laravel collection sort
PHP Laravel
1 vote299 views1 answer
Laravel gates
PHP Laravel
0 vote258 views1 answer
Laravel Pusher 401 Unauthorized
PHP Laravel
0 vote263 views1 answer
Laravel eloquent many to many query using whereHas
PHP Laravel
0 vote215 views2 answers
Send data using ajax in laravel
PHP Laravel
2 votes266 views1 answer
Laravel string key
PHP Laravel
4 votes284 views2 answers
Validate year laravel
PHP Laravel
3 votes252 views1 answer
Laravel check if environment is production
PHP Laravel
8 votes250 views6 answers
Command not found: laravel
PHP Laravel
0 vote272 views1 answer
Laravel use npm package
PHP Laravel