/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

1 vote169 views1 answer
How get just one parameter of all objects in one array in laravel
PHP
0 vote167 views1 answer
How to increase request timeout in laravel
PHP
1 vote120 views1 answer
Get month in words php
PHP
1 vote165 views1 answer
How to save information on pdf file in laravel project
PHP
0 vote264 views2 answers
Wp create user programmatically
PHP
44 votes162 views2 answers
Laravel version command
PHP
6 votes190 views3 answers
Disable foreign key laravel
PHP Laravel
2 votes170 views1 answer
Your composer dependencies require a php version ">= 7.3.0"
PHP
3 votes159 views1 answer
Php loop through every day of the year
PHP
2 votes194 views2 answers
Laravel 8 websockets
PHP