/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

56 votes268 views6 answers
Laravel seeder
PHP Laravel
0 vote148 views1 answer
How to migrate new column without empty the table in laravel
PHP Laravel
4 votes135 views2 answers
Datetime blade laravel
PHP Laravel
0 vote138 views4 answers
Installing bootstrap ui in laravel app
PHP Laravel
1 vote147 views1 answer
Laravel 8: seed users + Jetstream teams
PHP Laravel
7 votes130 views3 answers
Laravel creat new model
PHP Laravel
5 votes139 views2 answers
Laravel check method is post
PHP Laravel
2 votes126 views1 answer
Get the current route in laravel
PHP Laravel
1 vote152 views1 answer
Image dimension when uploading in laravel validation
PHP Laravel
1 vote153 views3 answers
Laravel title dynamic
PHP Laravel