/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

4 votes163 views2 answers
Mix is not recognized
PHP
0 vote188 views1 answer
Symfony how to respond in-memory file
PHP
0 vote170 views1 answer
Php get object josn
PHP
-2 votes220 views3 answers
Inner join codeigniter
PHP CodeIgniter
0 vote182 views1 answer
Put the date from new york with php
PHP
0 vote208 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
16 votes162 views2 answers
Php print object
PHP
3 votes230 views1 answer
Php strc types
PHP
0 vote173 views1 answer
What is the name of scripting engine in PHP?
PHP
0 vote207 views1 answer
Get id by url wordpress
PHP