/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

1 vote215 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
1 vote258 views1 answer
Edit data using model in laravel 8
PHP Laravel
0 vote215 views1 answer
Laravel database engine innodb
PHP Laravel
-1 vote235 views2 answers
Adminlte 3 laravel
PHP Laravel
0 vote219 views3 answers
Laravel Eloquent sum of multiplied columns
PHP Laravel
0 vote252 views3 answers
Database and files backup laravel
PHP Laravel
0 vote213 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
1 vote228 views1 answer
Laravel websockets onclose
PHP Laravel
33 votes178 views8 answers
Laravel faker
PHP Laravel
7 votes228 views3 answers
Laravel table in model
PHP Laravel