/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

1 vote328 views1 answer
Why job laravel do not worl
PHP Laravel
1 vote326 views1 answer
Laravel php artisan make:controller in subfolder
PHP
1 vote312 views3 answers
Print query statement in laravel
PHP Laravel
5 votes463 views2 answers
Php select option
PHP
1 vote363 views1 answer
WordPress asking for FTP credentials on localhost
PHP Wordpress
8 votes284 views6 answers
Php scandir
PHP
0 vote349 views1 answer
Laravel ID Generator
PHP Laravel
18 votes293 views6 answers
Laravel routes
PHP Laravel
0 vote281 views1 answer
How to grab shortcode from custom post type
PHP
0 vote296 views1 answer
Update onlu one column laravel
PHP