/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

1 vote341 views1 answer
Increment single column laravel
PHP Laravel
2 votes353 views1 answer
Laravel model quard
PHP Laravel
1 vote357 views1 answer
How to add attribute to the request object in laravel
PHP Laravel
5 votes332 views2 answers
Remove “/public” from Laravel route
PHP Laravel
0 vote356 views1 answer
Laravel collection shuffle
PHP Laravel
12 votes315 views3 answers
Validation.required laravel
PHP Laravel
1 vote341 views1 answer
Foreign key nullable in laravel
PHP Laravel
2 votes292 views1 answer
Laravel slug route
PHP Laravel
1 vote349 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel
0 vote283 views1 answer
How to pass parameter to middleware from route in laravel
PHP Laravel