/PHP/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

0 vote167 views1 answer
How to validate email or phone number single parameter request in laravel
PHP
8 votes160 views1 answer
Laravel show routes artisan
PHP
0 vote185 views1 answer
Is null sqlalchemy filter
PHP
0 vote202 views1 answer
Laravel on cascade set null
PHP Laravel
1 vote184 views1 answer
Return response array laravel
PHP Laravel
4 votes178 views2 answers
Laravel get authorization bearer token
PHP
0 vote185 views3 answers
Laravel disable Logging
PHP Laravel
0 vote165 views1 answer
Php date format minus 1 day
PHP
0 vote183 views1 answer
Php generating number
PHP
0 vote217 views1 answer
Laravel custom abort message
PHP Laravel