/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 vote259 views1 answer
Laravel flutter save image in data
PHP Laravel
4 votes267 views2 answers
Switch in laravel
PHP Laravel
1 vote228 views2 answers
Laravel collection isNotEmpty
PHP Laravel
0 vote258 views1 answer
Snactum laravel
PHP Laravel
1 vote290 views1 answer
Laravel include with variable
PHP Laravel
0 vote270 views1 answer
Get value mentthod get laravel
PHP Laravel
1 vote278 views1 answer
Laravel group by created_at date only
PHP Laravel
0 vote306 views1 answer
Laravel relation select fields
PHP Laravel
0 vote254 views1 answer
Refresh web route laravel
PHP Laravel
0 vote282 views3 answers
Laravel pagination with search filter
PHP Laravel