/PHP/Laravel/Laravel General error: 1215 Cannot add foreign key constraint"

Laravel General error: 1215 Cannot add foreign key constraint"

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 vote285 views1 answer
Function is not defined laravel
PHP Laravel
0 vote294 views1 answer
Laravel eloquent update quantity
PHP Laravel
0 vote324 views1 answer
Data type for price in laravel
PHP Laravel
9 votes282 views3 answers
Laravel validation image or file
PHP Laravel
0 vote309 views1 answer
Laravel collection union
PHP Laravel
0 vote315 views1 answer
Laravel secure url with query string
PHP Laravel
0 vote290 views1 answer
Laravel use npm package
PHP Laravel
0 vote292 views1 answer
Laravel save or post
PHP Laravel
-1 vote221 views1 answer
Laravel 7 generator
PHP Laravel
10 votes271 views6 answers
Format time laravel
PHP Laravel