/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

0 vote381 views1 answer
Laravel package for getID3()
PHP Laravel
3 votes328 views4 answers
How to use php variable in javascript file
PHP
0 vote307 views1 answer
Yii2 clear schema cache
PHP
0 vote350 views1 answer
How to get only content-length with CURL PHP?
PHP
0 vote416 views1 answer
Laravel dingo api response
PHP Laravel
12 votes373 views6 answers
Set session data in laravel
PHP Laravel
39 votes359 views6 answers
Php uppercase
PHP
2 votes326 views2 answers
Laravel validate form data unique
PHP
0 vote294 views2 answers
Php 8 null safe operator
PHP
0 vote321 views1 answer
Beautify var_dump
PHP