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

27 votes286 views4 answers
Common array methods php
PHP
33 votes313 views6 answers
Migrate specific migration laravel
PHP
44 votes358 views6 answers
How to make controller in laravel
PHP Laravel
0 vote266 views1 answer
Can i back up mysql database from php code?
PHP
1 vote293 views1 answer
For each multiple php
PHP
42 votes274 views3 answers
How to split sting in php
PHP
40 votes337 views6 answers
Rand string php
PHP
0 vote293 views2 answers
How to upload large video file in php
PHP
1 vote281 views1 answer
Laravel migration add datetime column with default
PHP
0 vote339 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP Laravel