/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 vote247 views1 answer
Laravel best practices
PHP Laravel
0 vote194 views1 answer
Laravel storage save file folder on disk
PHP
9 votes185 views3 answers
Uninstall phpmyadmin ubuntu
PHP
19 votes222 views4 answers
Laravel bootstrap auth
PHP Laravel
0 vote205 views2 answers
How to update dropdown value in laravel
PHP Laravel
1 vote183 views1 answer
Php set header to utf-8
PHP
0 vote218 views1 answer
'laravel'
PHP Laravel
0 vote169 views2 answers
How to lookup value object php
PHP
17 votes332 views4 answers
WordPress debug
PHP Wordpress
0 vote193 views2 answers
For loop in ACF
PHP