/PHP/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

0 vote119 views1 answer
Edit vendor details in wcfm
PHP
1 vote158 views1 answer
Laravel end date greater than start date validation
PHP Laravel
0 vote120 views1 answer
Php check if type is mysqli_result
PHP
0 vote127 views1 answer
Eventon php code
PHP
1 vote112 views1 answer
Laravel date diff
PHP
11 votes137 views2 answers
Eloquent get distinct
PHP
0 vote141 views1 answer
Laravel Your requirements could not be resolved to an installable set of packages.
PHP Laravel
3 votes119 views2 answers
Php camelcase to snake case
PHP
1 vote117 views1 answer
Modal form with php
PHP
1 vote126 views1 answer
Install php-mbstring in ubuntu
PHP