/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 vote263 views1 answer
Laravel-medialibrary change name of file
PHP Laravel
2 votes268 views4 answers
Laravel run schedule locally
PHP Laravel
8 votes268 views6 answers
Laravel session
PHP Laravel
5 votes308 views2 answers
Laravel naming conventions
PHP Laravel
2 votes253 views5 answers
Laravel db drop table
PHP Laravel
8 votes276 views1 answer
Laravel create symbolic link storage
PHP Laravel
22 votes269 views6 answers
Laravel log
PHP Laravel
0 vote297 views1 answer
Laravel seeding with relationships
PHP Laravel
37 votes320 views6 answers
Laravel create or update
PHP Laravel
18 votes284 views4 answers
Create model view controller laravel
PHP Laravel