/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

0 vote225 views1 answer
Laravel list all tbales
PHP Laravel
4 votes248 views2 answers
How to Get Last Executed Query in Laravel
PHP Laravel
1 vote233 views3 answers
Check image exist or not in laravel
PHP Laravel
1 vote218 views1 answer
How convert big text to array that text have br in laravel
PHP Laravel
-1 vote199 views3 answers
Delete rows by migration laravel
PHP Laravel
3 votes222 views1 answer
Print session in laravel
PHP Laravel
0 vote209 views1 answer
Laravel notification attach file
PHP Laravel
2 votes220 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP Laravel
0 vote261 views1 answer
Pass array from controller laravel with compact
PHP Laravel
16 votes200 views3 answers
Laravel request validate
PHP Laravel