/PHP/General error: 1215 Cannot add foreign key constraint laravel

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

25 votes104 views4 answers
Carbon now
PHP
-1 vote152 views1 answer
Wamp php version update
PHP
0 vote115 views1 answer
Group by not working - Laravel
PHP Laravel
0 vote96 views3 answers
Why are my css properties not being applied to php file
PHP
0 vote96 views1 answer
Last item coma replace and php
PHP
0 vote101 views1 answer
Cpt change link
PHP
26 votes140 views3 answers
SQLSTATE[42000]: Syntax error or access violation: 1071
PHP
3 votes107 views1 answer
Events.js:174 error discord.js
PHP
1 vote170 views1 answer
Changer le logo Admin WordPress
PHP Wordpress
0 vote112 views1 answer
Php return function result to variable
PHP