/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

1 vote317 views1 answer
Laravel helper function for check string is exist in another string
PHP Laravel
24 votes291 views4 answers
Where not null in laravel
PHP Laravel
0 vote313 views1 answer
How to excluse csrf in a route laravel
PHP Laravel
1 vote364 views2 answers
Laravel update only changed fields
PHP Laravel
28 votes286 views5 answers
Laravel whereRaw
PHP Laravel
1 vote331 views3 answers
Not equal in laravel blade
PHP Laravel
0 vote291 views1 answer
Add query string to url laravel
PHP Laravel
4 votes369 views3 answers
Laravel restore deleted
PHP Laravel
-1 vote299 views4 answers
Adminlte in laravel 8
PHP Laravel
0 vote331 views4 answers
Form::select laravel
PHP Laravel