/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 vote129 views1 answer
Add custom attribute for validation errors laravel
PHP Laravel
11 votes147 views6 answers
Laravel route
PHP Laravel
16 votes128 views6 answers
Laravel group routes
PHP Laravel
1 vote128 views3 answers
Create new laravel project with specific version
PHP Laravel
0 vote131 views1 answer
Hint extension in visual studio code for laravel
PHP Laravel
0 vote138 views1 answer
Laravel.log" could not be opened in append mode
PHP Laravel
0 vote124 views1 answer
Get All dates of a month with laravel carbon
PHP Laravel
44 votes145 views2 answers
Laravel version command
PHP Laravel
1 vote134 views2 answers
Db name laravel
PHP Laravel
3 votes137 views1 answer
Laravel firstOrFail
PHP Laravel