/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

25 votes326 views4 answers
Php get client ip address
PHP
0 vote347 views1 answer
Load order by entity_id magento 2
PHP
3 votes345 views1 answer
Laravel web.php auth Undefined type 'Auth'.
PHP
3 votes318 views2 answers
Php convert unix time to date
PHP
1 vote356 views1 answer
Php array in cookie
PHP
0 vote327 views1 answer
Getting the closest string match using php
PHP
6 votes381 views1 answer
How to add new column in table laravel
PHP Laravel
0 vote353 views1 answer
Doctrine where
PHP
0 vote350 views1 answer
Laravel get data from model to controller
PHP Laravel
2 votes389 views2 answers
Enable shortcodes in text widgets
PHP