/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 vote179 views2 answers
Php check credit card expiration
PHP
6 votes176 views1 answer
How do decode base64 php
PHP
2 votes165 views5 answers
Ubuntu install php
PHP
4 votes198 views2 answers
Php ini_set timeout
PHP
0 vote160 views1 answer
Php is datetime
PHP
40 votes168 views6 answers
Randomstring php
PHP
0 vote181 views1 answer
SoapClient Laravel 8
PHP Laravel
20 votes160 views6 answers
Php array sort by key
PHP
31 votes170 views5 answers
How to make db seeder in laravel
PHP Laravel
0 vote191 views2 answers
Laravel collection sort by date
PHP Laravel