/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 vote353 views1 answer
Run new oroject laravel with idff port
PHP Laravel
9 votes381 views3 answers
Pass variable to blade laravel
PHP Laravel
0 vote341 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
0 vote353 views1 answer
Install laravel jetstream inertia js
PHP Laravel
1 vote356 views1 answer
How convert big text to array that text have br in laravel
PHP Laravel
0 vote344 views3 answers
Laravel query builder get last insert id
PHP Laravel
1 vote354 views1 answer
How to store an image in laravel directly from url
PHP Laravel
7 votes371 views3 answers
Laravel append array to array
PHP Laravel
1 vote407 views1 answer
Edit data using model in laravel 8
PHP Laravel
-1 vote329 views1 answer
Excel extract date from dd mm yyyy laravel blade
PHP Laravel