/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

100 votes358 views6 answers
Php substr_replace
PHP
8 votes325 views3 answers
Laravel 8 check if record exists
PHP Laravel
1 vote273 views1 answer
How to mantain text in form after error php
PHP
14 votes298 views3 answers
Enqueue wordpress
PHP
0 vote271 views1 answer
Default php timezone to newyork
PHP
0 vote322 views8 answers
Syntax error, unexpected token "}", expecting "," or ";" php
PHP
1 vote290 views1 answer
Ipn listener paypel php
PHP
0 vote274 views3 answers
Chrome web driver
PHP
8 votes304 views5 answers
Laravel route model binding
PHP Laravel
0 vote256 views1 answer
SQLSTATE[22023]: Invalid parameter value:
PHP