/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 vote95 views6 answers
How to install bootstrap in laravel 8
PHP
2 votes98 views3 answers
How to get a whole number from decimal in php
PHP
0 vote98 views1 answer
Compare key and one array
PHP
9 votes90 views3 answers
Php check if int is odd
PHP
0 vote96 views1 answer
Entitymanager get repository
PHP
1 vote97 views1 answer
Tailwind text vertical alignment doesn't work
PHP
0 vote101 views1 answer
How to check if a user sent you money in paypal in php
PHP
16 votes153 views6 answers
Php string to date
PHP
0 vote87 views1 answer
Eloquent update row response
PHP
0 vote123 views1 answer
Laravel move file from local to s3
PHP Laravel