/PHP/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 vote276 views1 answer
Laravel import data from csv
PHP Laravel
107 votes323 views6 answers
Php get current date
PHP
0 vote202 views2 answers
Woocommerce get user id by email
PHP
28 votes205 views6 answers
Laravel drop foreign key
PHP
1 vote199 views1 answer
Is php the fucking worst
PHP
7 votes187 views2 answers
How to make a php info
PHP
1 vote217 views1 answer
Why laravel site loading only
PHP Laravel
0 vote204 views1 answer
Inner pages not found yii
PHP
5 votes239 views3 answers
Return view controller laravel
PHP Laravel
0 vote211 views1 answer
Eager loading in hasmany belongsto relationship
PHP