/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 vote190 views1 answer
Guzzlehttp/guzzle version with laravel-websockek
PHP Laravel
0 vote193 views1 answer
Url() inside laravel config files
PHP Laravel
0 vote171 views2 answers
Create model controller migration factory laravel in one command
PHP Laravel
1 vote161 views2 answers
Laravel model set new attribute
PHP Laravel
0 vote185 views4 answers
Form::select laravel
PHP Laravel
3 votes187 views4 answers
Round() laravel
PHP Laravel
3 votes186 views1 answer
Laravel back button
PHP Laravel
0 vote192 views1 answer
Laravel permission spatie cache clear
PHP Laravel
2 votes181 views3 answers
How get file size in laravel
PHP Laravel
0 vote185 views1 answer
Logout from all the devices in the jwt api laravel
PHP Laravel