/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

18 votes150 views6 answers
Wherein laravel
PHP Laravel
0 vote148 views1 answer
How to get all the records with same ID in laravel
PHP Laravel
0 vote149 views2 answers
Laravel create event listener
PHP Laravel
6 votes181 views4 answers
Laravel use url
PHP Laravel
15 votes143 views6 answers
Laravel custom validation message
PHP Laravel
2 votes173 views2 answers
Laravel blade auth check
PHP Laravel
0 vote152 views1 answer
Laravel retry failed transactions
PHP Laravel
1 vote179 views1 answer
Laravel images mimetypes validatiion
PHP Laravel
44 votes181 views6 answers
How to make controller in laravel
PHP Laravel
0 vote164 views1 answer
Exclude row from clooection laravel
PHP Laravel