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

Laravel General error: 1215 Cannot add foreign key constraint"

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

2 votes316 views1 answer
Laravel blade file naming conventine
PHP Laravel
1 vote324 views1 answer
Select sum in laravel
PHP Laravel
9 votes322 views3 answers
Laravel with select
PHP Laravel
1 vote324 views2 answers
Set nav link active on the basis of route laravel
PHP Laravel
0 vote312 views2 answers
Laravel apiresource
PHP Laravel
0 vote312 views1 answer
Laravel csrf token or protection or laravel form
PHP Laravel
0 vote346 views1 answer
Check the existing image in s3 laravel
PHP Laravel
0 vote321 views1 answer
Get deleted value laravel
PHP Laravel
2 votes341 views1 answer
Laravel time to human redable format
PHP Laravel
0 vote283 views2 answers
Laravel project make
PHP Laravel