/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

0 vote295 views1 answer
How to create module in laravel
PHP Laravel
39 votes269 views6 answers
Laravel foreign key constraint
PHP Laravel
0 vote252 views2 answers
Laravel event listener
PHP Laravel
26 votes251 views4 answers
Carbon date time laravel
PHP Laravel
0 vote262 views1 answer
Laravel catch TokenMismatchException
PHP Laravel
0 vote255 views1 answer
Laravel request file empty
PHP Laravel
0 vote252 views1 answer
Laravel collection shuffle
PHP Laravel
1 vote252 views1 answer
Laravel map array
PHP Laravel
4 votes264 views3 answers
Laravel cmd command to watch logs
PHP Laravel
0 vote222 views1 answer
Laravel username validation
PHP Laravel