/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 vote350 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
1 vote369 views2 answers
How console log laravel
PHP Laravel
1 vote378 views1 answer
Laravel run query migration
PHP Laravel
0 vote372 views1 answer
Laravel validate form data unique array
PHP Laravel
0 vote399 views2 answers
Laravel collection sort by date
PHP Laravel
1 vote350 views4 answers
Laravel form request validation api
PHP Laravel
0 vote390 views3 answers
Permissions for laravel deployment
PHP Laravel
8 votes356 views6 answers
Laravel new project
PHP Laravel
1 vote371 views1 answer
Date casting from datetime to d-m-Y laravel
PHP Laravel
13 votes363 views6 answers
Composer create project laravel
PHP Laravel