/PHP/Laravel General error: 1215 Cannot add foreign key constraint"

Laravel General error: 1215 Cannot add foreign key constraint"

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

0 vote147 views1 answer
Standalone laravel orm
PHP
-1 vote188 views2 answers
Elvis operator php
PHP
0 vote145 views1 answer
The configuration file now needs a secret passphrase (blowfish_secret)
PHP
3 votes158 views2 answers
Library not loaded: /usr/local/opt/icu4c/lib/libicuio.64.dylib Referenced from: /usr/local/bin/php
PHP
1 vote166 views1 answer
Laravel read origanl value before update
PHP Laravel
3 votes141 views2 answers
Php mysql search database and display results
PHP
6 votes161 views1 answer
Laravel Route::group definition
PHP Laravel
0 vote184 views1 answer
Php kommentar
PHP
0 vote243 views1 answer
Augmenter la dimension des fichiers WP
PHP
1 vote189 views1 answer
Laravel profile migration tool
PHP Laravel