/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

6 votes277 views2 answers
Where is the php ini file located on server
PHP
0 vote305 views2 answers
Get post date and time in wordpress
PHP
35 votes279 views6 answers
Php format date
PHP
0 vote349 views2 answers
Search string inside array of objects php
PHP
66 votes274 views6 answers
Php array length
PHP
9 votes392 views3 answers
Define url wordpress
PHP Wordpress
1 vote284 views1 answer
How to add property to the request object
PHP
57 votes297 views6 answers
In array php
PHP
0 vote288 views1 answer
Wp varnish ip
PHP
0 vote345 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel