/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 vote152 views3 answers
Php array_reverse keep keys
PHP
0 vote95 views1 answer
Php build query from array
PHP
5 votes118 views3 answers
Acf gallery
PHP
2 votes113 views1 answer
Wordpress print post data
PHP Wordpress
0 vote98 views1 answer
Character encoding to remove question marks as apostrophe php code
PHP
0 vote114 views1 answer
Laravel error reporting code for view
PHP Laravel
1 vote112 views1 answer
Model json laravel accessor to convert to array
PHP Laravel
7 votes112 views10 answers
Php .com
PHP
0 vote95 views1 answer
Remove action from theme wordpress
PHP
0 vote119 views1 answer
Fichier wp-config.php
PHP