/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

2 votes197 views3 answers
Php laravel dump
PHP Laravel
21 votes217 views2 answers
Long text in laravel migration
PHP Laravel
0 vote205 views1 answer
Multiple databases user validation in Laravel
PHP Laravel
0 vote167 views1 answer
How to login laravel passport with postman
PHP Laravel
1 vote203 views2 answers
Redirect::route('profile') and with() in laravel
PHP Laravel
1 vote200 views1 answer
Laravel password verification
PHP Laravel
0 vote186 views1 answer
Laravel admin panel free package
PHP Laravel
-1 vote191 views2 answers
Laravel eloquent update multiple records
PHP Laravel
0 vote214 views1 answer
A facade root has not been set laravel 7
PHP Laravel
1 vote217 views1 answer
'cross-env' is not recognized as an internal or external command, laravel
PHP Laravel