/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 vote173 views1 answer
Clear from faild_jobs laravel
PHP
10 votes237 views6 answers
Php redirect to another page
PHP
0 vote129 views1 answer
Select only relation columns in laravel
PHP
1 vote161 views1 answer
Php remove bom
PHP
0 vote187 views1 answer
Adding field to array on condition laravel
PHP
0 vote172 views1 answer
Best Image Manipulation and Graphs tools for php
PHP
1 vote213 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
1 vote168 views1 answer
Causes of class not found in laravel
PHP
0 vote174 views1 answer
Wordpress wpdb delete
PHP
0 vote210 views1 answer
Codeigniter remote queries very slow
PHP CodeIgniter