/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 vote313 views1 answer
Laravel with eager where
PHP Laravel
2 votes343 views1 answer
Laravel carbon human readable
PHP Laravel
1 vote338 views1 answer
How get the latest arraye value in laravel
PHP Laravel
0 vote495 views1 answer
Schema key issue laravel
PHP Laravel
-1 vote336 views1 answer
Laravel hide columns
PHP Laravel
0 vote316 views1 answer
$this- attribute laravel
PHP Laravel
0 vote351 views1 answer
How to validate email or phone number single parameter request in laravel
PHP Laravel
1 vote366 views2 answers
Explode function in laravel
PHP Laravel
0 vote386 views1 answer
Can i do a relation between 2 coulnm in mongodb laravel
PHP Laravel
6 votes325 views2 answers
Create migration model and seeder laravel at once
PHP Laravel