/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

0 vote277 views3 answers
Oop php
PHP
0 vote258 views1 answer
How to disable Gutenberg / block editor for certain post types
PHP
36 votes256 views6 answers
Laravel 8 foreign key migration
PHP Laravel
1 vote233 views1 answer
Redirect image attachment pages in Wordpress
PHP
1 vote232 views2 answers
Php append string
PHP
0 vote256 views2 answers
Laravel has one through relationship
PHP
7 votes265 views6 answers
Sort laravel eloquent
PHP Laravel
0 vote284 views1 answer
Wordpress is_tag function
PHP
1 vote227 views1 answer
Centos search directory php.exe
PHP
0 vote288 views1 answer
Laravel migrate if not exists
PHP Laravel