/PHP/Laravel/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 vote311 views2 answers
How set field after another field in migration in laravel
PHP Laravel
1 vote300 views1 answer
Call metho din config laravel
PHP Laravel
1 vote306 views3 answers
Delete a migration laravel
PHP Laravel
0 vote327 views1 answer
How use variable in string in laravel
PHP Laravel
4 votes373 views2 answers
How to Get Last Executed Query in Laravel
PHP Laravel
4 votes345 views2 answers
Validate year laravel
PHP Laravel
0 vote318 views2 answers
Laravel store file
PHP Laravel
4 votes302 views1 answer
Laravel install production
PHP Laravel
0 vote304 views1 answer
How to create a new component in laravel
PHP Laravel
0 vote239 views1 answer
Laravel wordpress reset password
PHP Laravel