/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 vote125 views1 answer
How to display category and subcategory list
PHP
-1 vote164 views1 answer
Laravel set production
PHP
0 vote183 views1 answer
Laravel collection tap
PHP Laravel
0 vote157 views1 answer
Codeigniter 4 query builder get inserted id
PHP
2 votes148 views1 answer
Josn header php
PHP
0 vote173 views1 answer
Refresh web route laravel
PHP Laravel
0 vote155 views1 answer
How to read data from serial port in php
PHP
5 votes141 views1 answer
Php cors disable
PHP
8 votes145 views5 answers
Wherebetween laravel
PHP
0 vote226 views2 answers
Laravel query where and
PHP