/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

1 vote326 views1 answer
Parametre grouping laravel quert
PHP Laravel
46 votes369 views5 answers
Add column migration laravel
PHP Laravel
1 vote310 views1 answer
Laravel model increase the value by one
PHP Laravel
25 votes288 views6 answers
Laravel use cache
PHP Laravel
0 vote297 views1 answer
Doiffernce between text and string in laravel migration
PHP Laravel
4 votes311 views1 answer
Refresh a specific migration in laravel
PHP Laravel
1 vote339 views1 answer
How to add properties to the request object in laravel
PHP Laravel
1 vote281 views3 answers
Laravel eloquent bulk insert
PHP Laravel
63 votes437 views6 answers
Clear all cache in laravel
PHP Laravel
1 vote311 views1 answer
Use model from variable laravel
PHP Laravel