/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

8 votes202 views1 answer
Storage image not showing in laravel
PHP
104 votes332 views6 answers
Array_push in php
PHP
6 votes209 views3 answers
Ubuntu php uninstall
PHP
0 vote229 views1 answer
Wordpress change post format
PHP
0 vote247 views1 answer
Add selected to dropdpown item laravel
PHP Laravel
4 votes223 views2 answers
Ubuntu laravel storage permission
PHP
14 votes256 views6 answers
Laravel create model and migration
PHP Laravel
0 vote228 views1 answer
This domain is not registered with Tiny Cloud. Please see the quickstart guide or create an account.
PHP
0 vote219 views3 answers
Chrome web driver
PHP
0 vote211 views1 answer
Woocommerce change "Billing Details" text
PHP