/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

0 vote340 views1 answer
Laravel use model inside blade
PHP
-2 votes321 views1 answer
Php curl_exec get response json
PHP
1 vote320 views1 answer
Php insert array into mysql table
PHP
1 vote346 views1 answer
How to retrieve value from stdclass array in php
PHP
1 vote315 views1 answer
Get advanced custom field value in wordpress
PHP
0 vote317 views1 answer
Area of a circle segment in php
PHP
0 vote382 views1 answer
Laravel Pusher 401 Unauthorized
PHP Laravel
8 votes321 views4 answers
Codeigniter 4 redirect to home
PHP
3 votes360 views2 answers
Php string underscore into camelcase
PHP
0 vote324 views1 answer
Php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider
PHP