/PHP/Laravel/General error: 1215 Cannot add foreign key constraint laravel

General error: 1215 Cannot add foreign key constraint laravel

Laravel 5.8 Added bigIncrements As Defaults

So there is mismatch in foreign key field types. You see bigIncrements(id) in 
User table and unsigned Integer(user_id) in questions table.

How to fix:

1. Either change original migration from bigIncrements() to just
increments()

2. Or in your foreign key column do unsignedBigInteger() instead of 
unsignedInteger().

Laravel General error: 1215 Cannot add foreign key constraint"

 public function up()
    {
        Schema::table('tests', function (Blueprint $table) {
            $table->string('gender');
        });
    }

Source: dev.to

Similar codes

0 vote284 views1 answer
Laravel factory relationship one to many
PHP Laravel
8 votes215 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
0 vote226 views2 answers
How to pass bearer token in swagger in laravel
PHP Laravel
0 vote463 views2 answers
Laravel orm tutorial
PHP Laravel
2 votes229 views3 answers
Laravel migration drop foreign keys
PHP Laravel
5 votes218 views3 answers
Enum table in laravel
PHP Laravel
16 votes248 views2 answers
Laravel/ui v3.0.0 requires php ^7.3 -> your php version (8.0.2) does not satisfy that requirement.
PHP Laravel
1 vote227 views3 answers
Difference between guard and fillable laravel
PHP Laravel
0 vote227 views1 answer
Laravel Code To Rename file on server in the storage folder
PHP Laravel
20 votes229 views4 answers
Laravel where is null
PHP Laravel