/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

6 votes158 views4 answers
Laravel spatie asigne role
PHP
0 vote185 views1 answer
Iterating rows in php
PHP
0 vote161 views1 answer
Send parameter to function in php can null
PHP
4 votes164 views3 answers
Get current route in blade laravel
PHP
0 vote224 views1 answer
Twig filter line break
PHP
0 vote160 views1 answer
Get count mini cart item total
PHP
6 votes178 views2 answers
Login selected user laravel
PHP
0 vote150 views1 answer
Install phpredis MAC OSX
PHP
2 votes141 views2 answers
Php username regex
PHP
0 vote176 views1 answer
Date format in wordpress post
PHP