/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

-1 vote198 views1 answer
Notice: Undefined variable: _SESSION in C:\xampp\htdocs\practice\header.php on line 7
PHP
0 vote126 views2 answers
Laravel form collective add asterisk
PHP
0 vote147 views2 answers
Laravel apiresource
PHP
0 vote170 views1 answer
Set custome table laravel eloquent
PHP Laravel
3 votes161 views4 answers
PHP executable not found. Install PHP 7 and add it to your PATH or set the php.executablePath setting
PHP
0 vote157 views1 answer
Current time input field in laravel form
PHP Laravel
1 vote132 views2 answers
Laravel init
PHP
0 vote137 views1 answer
Mapping, Filtering and Reducing in PHP
PHP
2 votes139 views1 answer
Fetch value from json link in php
PHP
11 votes135 views5 answers
Php version
PHP