/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 votes259 views2 answers
Why we use pusher in laravel
PHP Laravel
2 votes203 views1 answer
Base64 encode laravel
PHP Laravel
0 vote231 views1 answer
Laravel vue error 500
PHP Laravel
0 vote221 views1 answer
Redirect all request to public folder laravel htaccess
PHP Laravel
3 votes212 views4 answers
Round() laravel
PHP Laravel
0 vote198 views2 answers
Laravel filesystem
PHP Laravel
12 votes237 views6 answers
Laravel model where
PHP Laravel
0 vote161 views1 answer
Laravel showing index of problem
PHP Laravel
2 votes208 views1 answer
How send user to 404 page if not exist page in laravel
PHP Laravel
33 votes198 views6 answers
How to run a specific migration in laravel
PHP Laravel