/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 vote145 views1 answer
Nova laravel image
PHP Laravel
0 vote123 views1 answer
Check null in laravel blade
PHP Laravel
1 vote139 views2 answers
Laravel migration check if table has column
PHP Laravel
1 vote159 views1 answer
How to add property to the request object in laravel
PHP Laravel
7 votes129 views3 answers
Laravel get latest
PHP Laravel
0 vote120 views1 answer
WithErrors laravel
PHP Laravel
4 votes123 views1 answer
Uuid nom package for laravel 18.04
PHP Laravel
3 votes129 views2 answers
Laravel withtrashed
PHP Laravel
50 votes260 views6 answers
Add column in laravel migration
PHP Laravel
0 vote125 views1 answer
Controller class does not exist laravel
PHP Laravel