/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

1 vote123 views2 answers
Laravel get data from request
PHP
-1 vote140 views1 answer
Where is phpinfo()
PHP
0 vote212 views6 answers
Use varable on all site pages laravel
PHP
0 vote139 views1 answer
Php sms sending script
PHP
55 votes137 views18 answers
Php generate random number string
PHP
1 vote153 views1 answer
Php clear output
PHP
26 votes150 views6 answers
Laravel model with migration
PHP Laravel
17 votes148 views6 answers
Sort
PHP
0 vote148 views2 answers
Laravel restrict route
PHP
8 votes184 views1 answer
Laravel create symbolic link storage
PHP