/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 vote309 views1 answer
Laravel blade image
PHP Laravel
8 votes290 views3 answers
Laravel redirect back with errors and input
PHP Laravel
0 vote349 views1 answer
Laravel append parameter to links
PHP Laravel
0 vote314 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
0 vote314 views1 answer
Remove controller cache laravel
PHP Laravel
1 vote276 views3 answers
Required_if laravel
PHP Laravel
0 vote296 views1 answer
Laravel Google Line Chart
PHP Laravel
1 vote321 views1 answer
Laravel 6 make http request
PHP Laravel
0 vote311 views1 answer
Laravel8 can't read env
PHP Laravel
0 vote309 views1 answer
Image not save laravel
PHP Laravel