/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

3 votes113 views1 answer
Laravel get route in unauthenticated
PHP Laravel
6 votes115 views1 answer
Laravel bootstrap ui
PHP Laravel
0 vote114 views1 answer
My laravel has no docker-composer.yml file
PHP Laravel
0 vote102 views1 answer
Laravel vue build production
PHP Laravel
0 vote120 views1 answer
Laravel cron job on shared hosting
PHP Laravel
0 vote164 views1 answer
Laravel job delay dispatch
PHP Laravel
-1 vote70 views1 answer
Laravel 7 generator
PHP Laravel
2 votes108 views4 answers
Laravel htaccess
PHP Laravel
1 vote116 views2 answers
Laravel eloquent with query extra parameter
PHP Laravel
5 votes129 views3 answers
Laravel model limit
PHP Laravel