/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

7 votes115 views2 answers
Laravel field types from database field type
PHP Laravel
1 vote127 views1 answer
How to add property to the request object in laravel
PHP Laravel
3 votes126 views1 answer
Back route laravel
PHP Laravel
0 vote117 views1 answer
Access-control-allow-origin php laravel
PHP Laravel
0 vote113 views1 answer
Laravel collection has
PHP Laravel
3 votes109 views5 answers
Get current locale laravel
PHP Laravel
0 vote121 views1 answer
Display data from two dimensional array in vew laravel
PHP Laravel
2 votes111 views2 answers
Laravel migration alter column unique
PHP Laravel
1 vote110 views1 answer
Human readable date laravel
PHP Laravel
5 votes120 views2 answers
Laravel print exception message
PHP Laravel