/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

3 votes120 views2 answers
Clear cache via route laravel
PHP Laravel
0 vote128 views1 answer
How to increase request timeout in laravel
PHP Laravel
2 votes129 views2 answers
404 page in laravel
PHP Laravel
0 vote120 views1 answer
Pass variable in laravel ancher tag laravel 8
PHP Laravel
8 votes129 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
47 votes178 views6 answers
Laravel create seeder
PHP Laravel
9 votes144 views1 answer
Get data in orderby in laravel
PHP Laravel
1 vote129 views1 answer
Datediff in hour query builder laravel
PHP Laravel
3 votes124 views2 answers
Order number generate laravel
PHP Laravel
0 vote151 views2 answers
Pluck only category name and id from model in laravel
PHP Laravel