/PHP/Laravel/General error: 1215 Cannot add foreign key constraint laravel

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

14 votes218 views6 answers
Transaction in laravel
PHP Laravel
1 vote253 views2 answers
How set field after another field in migration in laravel
PHP Laravel
1 vote218 views2 answers
Laravel collection isNotEmpty
PHP Laravel
18 votes241 views4 answers
Use if in laravel blade
PHP Laravel
5 votes235 views3 answers
Laravel eloquent duplicate record
PHP Laravel
0 vote276 views1 answer
Laravel asset prevent browser caching
PHP Laravel
2 votes282 views2 answers
Truncate table laravel eloquent
PHP Laravel
0 vote257 views1 answer
Laravel array length
PHP Laravel
15 votes227 views6 answers
Laravel migration default value
PHP Laravel
0 vote267 views1 answer
Add class to row laravel
PHP Laravel