/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

9 votes146 views5 answers
Add leading zeros in php
PHP
0 vote174 views1 answer
Count number of rows laravel controller
PHP Laravel
0 vote160 views1 answer
$_get and $_post in php
PHP
4 votes130 views3 answers
Laravel 7 eloquent on delete set null schema
PHP
0 vote139 views6 answers
For
PHP
0 vote149 views1 answer
Php calculate age as float
PHP
0 vote132 views1 answer
Como destruir uma variavel de sessão
PHP
0 vote148 views1 answer
How uplpoad video in laravel
PHP Laravel
0 vote78 views1 answer
Wp table with hostname setup
PHP
0 vote122 views1 answer
PHP script
PHP