/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

2 votes166 views1 answer
Redirect on validation error laravel to specific section laravel
PHP
3 votes212 views2 answers
Php grab month from date
PHP
0 vote179 views1 answer
Laravel new line in language file
PHP
0 vote174 views1 answer
Refresh database tables yii 1
PHP
0 vote189 views1 answer
Subquery in laravel
PHP Laravel
0 vote185 views1 answer
Wp order archive page post by title
PHP
4 votes202 views1 answer
Laravel request all except token
PHP Laravel
19 votes286 views2 answers
Typeof php
PHP
0 vote167 views1 answer
Class 'Pusher' not found
PHP
1 vote176 views1 answer
Default time of session in php
PHP