/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

2 votes123 views1 answer
Wordpress print post data
PHP
1 vote216 views2 answers
Laravel check if email is verified
PHP
6 votes148 views1 answer
Qual é a melhor linguagem de programação para iniciantes
PHP
2 votes133 views1 answer
Find word in text in laravel
PHP
27 votes121 views10 answers
Google translate
PHP
0 vote130 views1 answer
Laravel get referer without host
PHP Laravel
4 votes92 views1 answer
Opencart order change status
PHP
9 votes115 views4 answers
Php current page url
PHP
0 vote123 views1 answer
Features of PHP7
PHP
0 vote131 views1 answer
Codeigniter 4 query builder get inserted id
PHP