/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 vote369 views1 answer
Dummy data in laravel
PHP Laravel
0 vote279 views1 answer
Php curl detect 404
PHP
22 votes341 views6 answers
Fix to 2 decimal places php
PHP
0 vote271 views1 answer
Xss=removed
PHP
0 vote322 views1 answer
Logout all users laravel 8
PHP Laravel
5 votes254 views1 answer
Debug wordpress errors
PHP
0 vote384 views1 answer
Encode in laravel api
PHP Laravel
120 votes504 views6 answers
Replace all occurrences of a string in javascript
PHP
1 vote275 views1 answer
Get year in laravel 8
PHP
0 vote265 views1 answer
Get upload error codeigniter
PHP