/PHP/Laravel/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

0 vote149 views1 answer
Laravel map the output of the api
PHP Laravel
0 vote154 views1 answer
Laravel custom validation check if valid url
PHP Laravel
4 votes137 views1 answer
Uuid nom package for laravel 18.04
PHP Laravel
0 vote141 views1 answer
Laravel disable config cache
PHP Laravel
0 vote159 views1 answer
Parameters inside Laravel localized string
PHP Laravel
0 vote141 views1 answer
RequestCriteria laravel
PHP Laravel
13 votes130 views6 answers
Laravel api routes
PHP Laravel
0 vote150 views2 answers
Laravel "query()->find"
PHP Laravel
14 votes136 views6 answers
Transaction in laravel
PHP Laravel
8 votes138 views6 answers
Laravel collection unique
PHP Laravel