/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

1 vote360 views1 answer
Paystack gateway integration laravel
PHP Laravel
16 votes338 views3 answers
Laravel request validate
PHP Laravel
0 vote395 views2 answers
Show query in laravel
PHP Laravel
6 votes321 views2 answers
Blade ::if
PHP Laravel
0 vote353 views1 answer
Laravel route match
PHP Laravel
3 votes407 views1 answer
Laravel loop through collection
PHP Laravel
0 vote379 views1 answer
Laravel model query limit
PHP Laravel
0 vote398 views2 answers
Count with condition laravel
PHP Laravel
0 vote305 views1 answer
Laravel alter seeder
PHP Laravel
4 votes429 views2 answers
Pass parameter to view laravel
PHP Laravel