/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

1 vote190 views2 answers
Table has column laravel
PHP
0 vote186 views1 answer
Doctrine query builder order by multiple
PHP
4 votes186 views1 answer
Use str laravel
PHP Laravel
1 vote160 views1 answer
Use username instead of email laravel
PHP Laravel
4 votes216 views2 answers
How to create access token in laravel
PHP Laravel
0 vote208 views1 answer
Laravel 8 clear compiled class files
PHP Laravel
3 votes192 views1 answer
Laravel check if array is empty
PHP
0 vote172 views1 answer
He PHP exec() function must be enabled.
PHP
0 vote161 views1 answer
Laravel get all tables
PHP
1 vote180 views2 answers
Php string replace space
PHP