/PHP/Laravel/Laravel General error: 1215 Cannot add foreign key constraint"

Laravel General error: 1215 Cannot add foreign key constraint"

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 vote240 views1 answer
Laravel store blob image into database
PHP Laravel
7 votes247 views6 answers
Sort laravel eloquent
PHP Laravel
15 votes256 views3 answers
Laravel timezone
PHP Laravel
4 votes222 views2 answers
Laravel eloquent sum column
PHP Laravel
9 votes268 views5 answers
Laravel updateOrInsert
PHP Laravel
1 vote230 views1 answer
Laravel add crf token form
PHP Laravel
2 votes308 views1 answer
Add to url anchor tag laravel with variable
PHP Laravel
0 vote239 views2 answers
New static laravel
PHP Laravel
0 vote245 views1 answer
Laravel-medialibrary change name of file
PHP Laravel
0 vote280 views1 answer
Laravel recursive relationships
PHP Laravel