/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 vote381 views2 answers
Laravel "query()->find"
PHP Laravel
4 votes370 views3 answers
Laravel 7 eloquent on delete set null schema
PHP Laravel
-1 vote315 views1 answer
Laravel 7 generator
PHP Laravel
3 votes437 views1 answer
Php extensions for laravel
PHP Laravel
4 votes414 views5 answers
Laravel with and where
PHP Laravel
2 votes369 views1 answer
How get all files name in one folder in laravel
PHP Laravel
9 votes377 views3 answers
Laravel with select
PHP Laravel
9 votes379 views5 answers
Laravel create password hash
PHP Laravel
1 vote404 views1 answer
Laravel return list of ids
PHP Laravel
2 votes377 views2 answers
Laravel collection slice
PHP Laravel