/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 vote194 views1 answer
Entrust laravel
PHP Laravel
1 vote199 views1 answer
Validation not exists with this id laravel
PHP Laravel
0 vote165 views1 answer
Auth log out laravel
PHP Laravel
0 vote200 views1 answer
How to select and deselect all items without use name in laravel
PHP Laravel
2 votes181 views3 answers
How get file size in laravel
PHP Laravel
1 vote185 views1 answer
Laravel set config value runtime
PHP Laravel
0 vote181 views1 answer
Laravel display multiple selected values
PHP Laravel
1 vote184 views1 answer
Laravel eloquent get 10 records
PHP Laravel
0 vote194 views2 answers
How to implement maatwebsite excel in my laravel project
PHP Laravel
1 vote168 views1 answer
How get the latest data in database in laravel
PHP Laravel