/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 vote223 views1 answer
Arr::only laravel
PHP Laravel
1 vote226 views1 answer
Php clear output
PHP
1 vote207 views2 answers
Php replace space with 20
PHP
7 votes215 views3 answers
Php version check code
PHP
0 vote184 views1 answer
Don't have xdebgu ini file
PHP
2 votes184 views2 answers
Validate password laravel
PHP
14 votes182 views2 answers
Laravel database select
PHP
0 vote179 views1 answer
Php connect
PHP
0 vote232 views1 answer
Wp table with hostname setup
PHP Wordpress
1 vote213 views2 answers
Laravel return response with headers
PHP Laravel