/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

23 votes341 views6 answers
Laravel validation messages
PHP Laravel
0 vote440 views1 answer
Laravel 8 Factory - One To Many (Polymorphic) Relationship
PHP Laravel
4 votes408 views3 answers
Laravel restore deleted
PHP Laravel
0 vote340 views2 answers
Laravel get namespace
PHP Laravel
2 votes350 views2 answers
Laravel foreach first
PHP Laravel
0 vote345 views2 answers
What is composer in laravel
PHP Laravel
0 vote343 views2 answers
Laravel FileManager Display Blank pop up page
PHP Laravel
0 vote338 views1 answer
Insert views laravel database
PHP Laravel
1 vote381 views1 answer
Laravel foreach else
PHP Laravel
1 vote318 views1 answer
Change verify email template laravel
PHP Laravel