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

1 vote287 views4 answers
Laravel assign active based on route name
PHP
0 vote244 views1 answer
Mysqli fetch row assoc
PHP
6 votes273 views3 answers
Php check if string contains url
PHP
0 vote282 views1 answer
Install phpunit on ubuntu 18.04
PHP
15 votes252 views3 answers
Delete file in php
PHP
0 vote268 views1 answer
Ubuntu 7.2 deleted php
PHP
0 vote252 views1 answer
Laravel where between cluse
PHP
7 votes285 views2 answers
Laravel collection isEmpty
PHP
0 vote273 views1 answer
Adding field to array on condition laravel
PHP Laravel
0 vote277 views1 answer
__dir__ in php
PHP