/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

1 vote332 views1 answer
Laravel eloquent where id not equal to
PHP Laravel
4 votes314 views1 answer
TRANSACTON LARAVEL QUERY BUILDER
PHP Laravel
2 votes318 views3 answers
Laravel public static variable
PHP Laravel
0 vote338 views1 answer
Get all users created in a month laravel
PHP Laravel
1 vote361 views1 answer
Laravel use references in other tables
PHP Laravel
2 votes300 views1 answer
Laravel get subdomain
PHP Laravel
0 vote309 views1 answer
Adding field to array on condition laravel
PHP Laravel
0 vote366 views1 answer
Calculate average in eager loading laravel
PHP Laravel
0 vote334 views2 answers
Asset function in laravel not working
PHP Laravel
2 votes312 views3 answers
Laravel check if field has changed
PHP Laravel