/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 vote253 views2 answers
Laravel lumen
PHP Laravel
29 votes231 views6 answers
Where like laravel
PHP Laravel
0 vote232 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
0 vote232 views4 answers
Laravel collection contains
PHP Laravel
3 votes238 views1 answer
Laravel find by
PHP Laravel
0 vote253 views1 answer
Access storage from the view laravel 6
PHP Laravel
0 vote256 views1 answer
Debugbar:clear in laravel
PHP Laravel
1 vote229 views1 answer
Cart laravel
PHP Laravel
15 votes317 views2 answers
Update column value laravel
PHP Laravel
4 votes234 views2 answers
Laravel pass variables to view
PHP Laravel