/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 vote141 views1 answer
How to select and deselect all items without use name in laravel
PHP Laravel
1 vote145 views1 answer
Laravel best practices
PHP Laravel
17 votes126 views3 answers
Laravel order by desc
PHP Laravel
16 votes128 views6 answers
Laravel validation array
PHP Laravel
0 vote137 views1 answer
Laravel.log" could not be opened in append mode
PHP Laravel
0 vote128 views1 answer
Get nearby from longitude and latitude in laravel
PHP Laravel
24 votes116 views6 answers
Validation error message in laravel
PHP Laravel
0 vote135 views1 answer
Laravel: Unknown: Failed opening required 'server.php' (include_path='php\PEAR
PHP Laravel
1 vote142 views1 answer
Laravel group by created_at date only
PHP Laravel
9 votes73 views2 answers
Laravel collection filter
PHP Laravel