/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 vote199 views1 answer
Config smp gamil laravel
PHP Laravel
30 votes209 views6 answers
Laravel migration column types
PHP Laravel
0 vote227 views1 answer
Laravel collection average
PHP Laravel
0 vote215 views1 answer
Getting key from env returns null laravel
PHP Laravel
0 vote210 views3 answers
Method put laravel
PHP Laravel
0 vote313 views2 answers
Array collapse laravel
PHP Laravel
6 votes213 views3 answers
Laravel get single column value
PHP Laravel
1 vote171 views1 answer
Laravel validation on fields inside array in request
PHP Laravel
0 vote209 views1 answer
Laravel get query in normal sql without bindings
PHP Laravel
1 vote210 views1 answer
How to return data in json format in laravel
PHP Laravel