/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

8 votes183 views5 answers
Laravel route is current route
PHP Laravel
8 votes134 views1 answer
Storage image not showing in laravel
PHP Laravel
22 votes141 views4 answers
Laravel orWhere
PHP Laravel
1 vote148 views1 answer
How to create controler in laravel
PHP Laravel
0 vote150 views2 answers
Laravel Read CSV File
PHP Laravel
1 vote139 views1 answer
Laravel createmany example
PHP Laravel
4 votes146 views2 answers
Numbric validate laravel
PHP Laravel
0 vote136 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel
0 vote171 views1 answer
Laravel npm run dev mix error FIX
PHP Laravel
3 votes243 views2 answers
Laravel eloquent get one column value
PHP Laravel