/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 vote210 views1 answer
Map associative array php0
PHP
0 vote157 views1 answer
Payment gateway webhook returning 302 laravel
PHP
0 vote169 views1 answer
Wp+get custom field phpto
PHP
1 vote177 views1 answer
Laravel php artisan make:controller in subfolder
PHP
0 vote169 views1 answer
Wordpress get user data from email
PHP
2 votes166 views1 answer
Smarty shorthand assign var
PHP
0 vote190 views1 answer
Laravel looping checking if last record has reached
PHP Laravel
0 vote176 views1 answer
Wordpress admin settings form
PHP Wordpress
0 vote152 views1 answer
Stampare post checkbox php
PHP
0 vote154 views1 answer
Lcomposer symfony/filesystem
PHP