/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

3 votes398 views1 answer
Laravel validation greater than or equal to
PHP Laravel
0 vote380 views1 answer
Add like and equal in same query in laravel
PHP Laravel
0 vote322 views1 answer
Laravel firstorcreate usage
PHP Laravel
5 votes322 views6 answers
Sync laravel
PHP
2 votes325 views2 answers
Laravel migration two primary key
PHP
1 vote374 views2 answers
Laravel SPA cors
PHP Laravel
5 votes317 views2 answers
How to clear session in laravel
PHP
1 vote335 views1 answer
Php time ago
PHP
1 vote358 views1 answer
How to add data to an object in php
PHP
0 vote344 views1 answer
Php delete all files in folder
PHP