/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

3 votes335 views1 answer
Laravel edit form modal example
PHP Laravel
7 votes365 views3 answers
How to show validation error in laravel blade
PHP Laravel
3 votes291 views1 answer
Laravel use relations in where
PHP Laravel
0 vote341 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP Laravel
5 votes388 views4 answers
App url laravel
PHP Laravel
0 vote351 views2 answers
Laravel insert multiple rows from form
PHP Laravel
-1 vote317 views1 answer
Return true false laravel
PHP Laravel
0 vote343 views1 answer
Laravel keep old input
PHP Laravel
0 vote337 views1 answer
Laravel return a single dimensional array
PHP Laravel
0 vote359 views1 answer
Laravel return view in web.php
PHP Laravel