/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 vote231 views1 answer
Make() laravel
PHP Laravel
18 votes236 views6 answers
Redirect to route laravel
PHP Laravel
4 votes247 views1 answer
Refresh a specific migration in laravel
PHP Laravel
3 votes235 views3 answers
Laravel csrf-token in view
PHP Laravel
0 vote254 views1 answer
Laravel apache public folder
PHP Laravel
39 votes220 views6 answers
Create foreign key laravel migration
PHP Laravel
17 votes240 views6 answers
Update query laravel
PHP Laravel
0 vote225 views3 answers
Laravel - How to create custom configuration variables and access
PHP Laravel
0 vote248 views1 answer
S how to store jwt in http cookie laravel
PHP Laravel
0 vote248 views1 answer
Laravel validate number to be at least 3 digits
PHP Laravel