/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

0 vote144 views1 answer
If session is empty laravel
PHP Laravel
4 votes142 views3 answers
Laravel view routes
PHP Laravel
1 vote166 views1 answer
How to add attribute to the request object in laravel
PHP Laravel
0 vote152 views1 answer
Laravel change string to text
PHP Laravel
0 vote146 views1 answer
Laravel how to query belongsTo relationship
PHP Laravel
0 vote155 views1 answer
Laravel: Validation unique on update
PHP Laravel
0 vote149 views1 answer
Laravel Auth::logoutOtherDevices
PHP Laravel
1 vote145 views1 answer
Autoload file laravel
PHP Laravel
0 vote204 views1 answer
Laravel vu3
PHP Laravel
0 vote159 views1 answer
What is actullay work model in laravel
PHP Laravel