/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

6 votes342 views5 answers
Laravel collection map
PHP Laravel
0 vote348 views1 answer
Laravel migration folder
PHP Laravel
0 vote345 views1 answer
Laravel role
PHP Laravel
1 vote407 views2 answers
Laravel update only changed fields
PHP Laravel
3 votes332 views5 answers
Laravel request has
PHP Laravel
0 vote356 views2 answers
Default language laravel
PHP Laravel
28 votes334 views12 answers
Laravel middleware
PHP Laravel
0 vote337 views2 answers
Check method in laravel
PHP Laravel
3 votes363 views1 answer
Laravel back button
PHP Laravel
0 vote350 views1 answer
Last page url in php laravel
PHP Laravel