/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 vote195 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
-2 votes209 views1 answer
Laravel model bind with route in model
PHP Laravel
0 vote238 views1 answer
Link fake data in seeder laravel
PHP Laravel
24 votes212 views4 answers
Laravel query not null
PHP Laravel
0 vote215 views1 answer
Laravel run seeder enter timestamps
PHP Laravel
8 votes195 views6 answers
Command not found: laravel
PHP Laravel
0 vote232 views1 answer
Laravel simple
PHP Laravel
0 vote196 views1 answer
Running laravel project in mobile phone
PHP Laravel
0 vote196 views1 answer
Show data from a table in laravel 8
PHP Laravel
10 votes287 views4 answers
Compact laravel
PHP Laravel