/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

0 vote256 views1 answer
Wordpress wpdb delete
PHP Wordpress
29 votes223 views6 answers
Laravel model with migration
PHP
0 vote266 views1 answer
Laravel display the date the participation was created
PHP Laravel
16 votes231 views6 answers
Get last word from string php
PHP
15 votes241 views6 answers
Confirm password validation in laravel
PHP
1 vote214 views1 answer
Php has constant
PHP
0 vote269 views1 answer
Read xml file in php wordpress
PHP Wordpress
0 vote249 views1 answer
Php return associative array
PHP
0 vote210 views1 answer
Open a file in a new window phpstorm
PHP
0 vote257 views1 answer
Get stock product woocommerce by id
PHP