/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

0 vote306 views1 answer
How to pluck fullname database laravel
PHP
0 vote284 views1 answer
Generate report daily weekly monthly php mysql
PHP
0 vote353 views1 answer
How to on auto_recording using zoom api in php
PHP
2 votes307 views1 answer
How to run multiple laravel projects at same time
PHP
0 vote312 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
2 votes272 views2 answers
Open php.ini in ubuntu
PHP
0 vote284 views2 answers
Wordpress get post date custom format
PHP Wordpress
18 votes243 views4 answers
Carbon time laravel
PHP
0 vote334 views1 answer
How to take last entry in database in laravel Method Two
PHP Laravel
0 vote296 views1 answer
Laravel count soft delete data
PHP