/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

0 vote335 views1 answer
Get record of last 24 hours in laravel
PHP Laravel
6 votes371 views4 answers
Laravel url previous
PHP Laravel
0 vote336 views4 answers
Laravel old value for select option
PHP Laravel
0 vote333 views1 answer
Laravel count distance lat/longtidue
PHP Laravel
0 vote347 views2 answers
Laravel call controller method from view
PHP Laravel
19 votes308 views6 answers
Laravel Route Group
PHP Laravel
38 votes330 views6 answers
Laravel foreign key
PHP Laravel
1 vote293 views4 answers
Laravel generate slug
PHP Laravel
1 vote275 views1 answer
Trim laravel
PHP Laravel
1 vote319 views1 answer
Laravel redirect external url
PHP Laravel