/PHP/General error: 1215 Cannot add foreign key constraint laravel

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 vote223 views1 answer
Laravel run function after forgot password
PHP
1 vote201 views2 answers
Change php version using htaccess
PHP
0 vote218 views1 answer
How to Limit Excerpt Length in WordPress
PHP
0 vote171 views4 answers
Php youtube url to embed
PHP
2 votes201 views1 answer
Check php package list
PHP
2 votes202 views3 answers
Laravel get file contents from storage
PHP Laravel
0 vote197 views1 answer
Get_categories not__in
PHP
1 vote227 views1 answer
Increase execution size wp-config.php
PHP
15 votes211 views3 answers
Laravel date set timezone
PHP
3 votes216 views3 answers
Php best debugging functions
PHP