/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

3 votes121 views2 answers
Cannot create an instance of class viewmodel
PHP
5 votes129 views3 answers
Download npm package
PHP
0 vote137 views1 answer
Array filter php get first object
PHP
0 vote136 views1 answer
Encrypt/decrypt data php
PHP
48 votes139 views6 answers
Laravel join table
PHP
0 vote132 views1 answer
Pass the product name to form field cf7 woocommerce
PHP
14 votes125 views6 answers
Laravel migration set default value
PHP Laravel
3 votes99 views2 answers
Php link to page
PHP
0 vote163 views1 answer
Binance api buymarket php
PHP
25 votes137 views6 answers
Header location php
PHP