/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

0 vote242 views1 answer
Laravel unique column except self
PHP Laravel
0 vote234 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel
2 votes234 views4 answers
Laravel hash password check
PHP Laravel
0 vote245 views2 answers
How to implement maatwebsite excel in my laravel project
PHP Laravel
7 votes223 views3 answers
Laravel active menu item
PHP Laravel
0 vote234 views1 answer
Check mobile or email in laravel
PHP Laravel
0 vote238 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP Laravel
1 vote220 views1 answer
Laravel plural and singular
PHP Laravel
2 votes232 views2 answers
Laravel eloquent get all where in
PHP Laravel
16 votes200 views6 answers
Laravel validation array
PHP Laravel