/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

13 votes278 views2 answers
Wp get logged in user id
PHP Wordpress
1 vote159 views2 answers
Belongs to many laravel
PHP
0 vote199 views1 answer
Imprimir texto en php
PHP
0 vote149 views1 answer
Php curl pass user:password
PHP
0 vote161 views1 answer
Autoload_namespaces.php failed to open stream: Permission denied
PHP
1 vote164 views2 answers
Set postman global variable header
PHP
0 vote165 views1 answer
Model hasmany laravel
PHP
4 votes152 views2 answers
Row count in codeigniter
PHP
0 vote156 views1 answer
See all php version debian
PHP
0 vote190 views6 answers
Laravel get last id
PHP Laravel