/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 vote172 views1 answer
Connect php mysql procedural way
PHP
3 votes212 views6 answers
Laravel jwt token
PHP
39 votes153 views6 answers
Foreign key laravel migration
PHP
3 votes181 views2 answers
Error: Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.
PHP
3 votes160 views2 answers
Get json from url php
PHP
1 vote183 views1 answer
Wordpress stop redirect to https
PHP Wordpress
0 vote203 views1 answer
Add selected to dropdpown item laravel
PHP Laravel
2 votes154 views2 answers
How unset request parameter in laravel
PHP
1 vote170 views1 answer
'https://', 'www.' & all sub derictories reomve from a url with regex
PHP
0 vote154 views1 answer
Php jwt firebase
PHP