/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

2 votes159 views1 answer
Live update mysql data in php
PHP
0 vote228 views1 answer
Get name of parent dir php
PHP
0 vote176 views1 answer
Check url parameter if not redirect wordpress
PHP
1 vote277 views1 answer
Print value in laravel console
PHP
0 vote180 views1 answer
Laravel scheduler on shared hosting
PHP
0 vote217 views1 answer
Create table laravel give name table
PHP Laravel
0 vote253 views1 answer
Limiter la révision des articles WordPress
PHP Wordpress
9 votes210 views3 answers
Laravel download
PHP Laravel
12 votes210 views6 answers
Laravel where and where
PHP Laravel
0 vote217 views1 answer
Laravel echo html
PHP Laravel