/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

14 votes198 views2 answers
Laravel change value to intger
PHP Laravel
0 vote205 views2 answers
Laravel form collective add asterisk
PHP Laravel
2 votes178 views2 answers
Laravel throw exception with status code
PHP Laravel
0 vote195 views1 answer
Laravel secure url with query string
PHP Laravel
1 vote164 views1 answer
Laravel bindings query
PHP Laravel
0 vote199 views2 answers
Laravel insert multiple rows from form
PHP Laravel
0 vote183 views1 answer
Laravel model relationships with two columns match
PHP Laravel
0 vote169 views1 answer
How see the list all artisan in laravel
PHP Laravel
0 vote169 views2 answers
Option selected in laravel blade
PHP Laravel
0 vote168 views1 answer
Laravel: get last id
PHP Laravel