/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 votes227 views1 answer
How to check query execution time in laravel
PHP Laravel
37 votes205 views4 answers
Get PHP String Length
PHP
0 vote207 views1 answer
Php post variables to another page with submit button php
PHP
0 vote220 views3 answers
Laravel collection each
PHP Laravel
0 vote183 views1 answer
Php nginx file not found
PHP
1 vote211 views1 answer
How to remove jstream package
PHP
5 votes183 views2 answers
Check if array value exists in another array php
PHP
0 vote201 views1 answer
Php, Africa timezones
PHP
1 vote187 views1 answer
How to go to another folder in php
PHP
0 vote178 views1 answer
How to reduce time taken by php script on server
PHP