/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 votes229 views2 answers
Echo query in laravel
PHP Laravel
0 vote211 views1 answer
Laravel passport vue 401 Unauthorized
PHP Laravel
1 vote228 views1 answer
Forenkey set inlaravel 8
PHP Laravel
3 votes213 views1 answer
Laravel remove controller
PHP Laravel
0 vote268 views1 answer
Laravel sanctum Provoking tokens
PHP Laravel
0 vote233 views2 answers
Use class in blade laravel
PHP Laravel
1 vote234 views1 answer
How can set defult value for yield in laravel
PHP Laravel
0 vote216 views1 answer
Install laravel jetstream inertia js
PHP Laravel
0 vote229 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
0 vote239 views2 answers
Faker image laravel
PHP Laravel