/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

15 votes335 views6 answers
Confirm password validation in laravel
PHP
44 votes298 views3 answers
Php trim string to length
PHP
0 vote305 views2 answers
Can we generate alphanumeric 6 digit primary key in phpmyadmin
PHP
2 votes407 views2 answers
How to add data to the request object in laravel
PHP Laravel
-1 vote372 views3 answers
Delete rows by migration laravel
PHP Laravel
0 vote314 views1 answer
Laravel model relationships with two columns match
PHP
0 vote370 views1 answer
Php usort two columns
PHP
1 vote330 views2 answers
Laravel ckeditor
PHP
0 vote320 views1 answer
Auto submit button php
PHP
0 vote344 views1 answer
Artisa create event
PHP