/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

1 vote223 views1 answer
Add 2 hours to current time in cakephp
PHP CakePHP
6 votes182 views1 answer
A2dismod
PHP
21 votes193 views1 answer
Php delete array item by value not key
PHP
0 vote175 views3 answers
Php find multiple value in array
PHP
0 vote182 views1 answer
Test lockForUpdate laravel
PHP
6 votes197 views1 answer
Laravel check collection not empty
PHP Laravel
1 vote200 views1 answer
Laravel old value or default
PHP Laravel
2 votes235 views2 answers
How to check php version codeigniter 3
PHP CodeIgniter
3 votes190 views3 answers
Install breeze
PHP
5 votes181 views2 answers
Php check if class exists
PHP