/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 vote422 views1 answer
Laravel unauthenticated user resending
PHP Laravel
3 votes366 views3 answers
Laravel carbon count days between dates
PHP Laravel
13 votes358 views6 answers
How to run laravel project
PHP Laravel
1 vote358 views2 answers
Running laravel as host
PHP Laravel
1 vote350 views1 answer
Laravel queue work schedule cpanel
PHP Laravel
53 votes450 views6 answers
Laravel run seed
PHP Laravel
0 vote396 views1 answer
Use id as key in co;lection laravel
PHP Laravel
0 vote419 views2 answers
View blade not found in laravel
PHP Laravel
0 vote360 views1 answer
Laravel 8 blade get days and hours ago
PHP Laravel
0 vote387 views1 answer
Laravel-5-on-shared-hosting-wrong-public-path
PHP Laravel