/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

4 votes331 views2 answers
Delete all rows in table laravel
PHP Laravel
2 votes380 views3 answers
Laravel web php request to redirect to another page
PHP Laravel
6 votes351 views2 answers
How to set tinyint default 0 laravel migration
PHP Laravel
0 vote334 views2 answers
New static laravel
PHP Laravel
0 vote333 views1 answer
Laravel query with optional filter
PHP Laravel
0 vote399 views1 answer
Laravel hasMany with join
PHP Laravel
0 vote419 views1 answer
Laravel array cast
PHP Laravel
0 vote362 views1 answer
Laravel asset resolving to http not https
PHP Laravel
1 vote373 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
0 vote327 views1 answer
Setup cron on macos for laravel
PHP Laravel