/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

11 votes256 views3 answers
Laravel running a specific migration on different path
PHP Laravel
1 vote287 views2 answers
Insert batch in laravel
PHP Laravel
1 vote308 views1 answer
Where year month laravel
PHP Laravel
0 vote263 views1 answer
Query builder laravel getmedia undefined method
PHP Laravel
24 votes329 views6 answers
Laravel create model
PHP Laravel
1 vote296 views1 answer
Docx file validation laravel 8
PHP Laravel
1 vote332 views1 answer
I cannot login to my CPanel hosted Laravel Application, my SSL has expired
PHP Laravel
1 vote293 views2 answers
Scheduling in laravel in custom cron
PHP Laravel
14 votes273 views5 answers
Laravel debugbar
PHP Laravel
3 votes285 views3 answers
Laravel notification
PHP Laravel