jeudi 30 avril 2020

Foreign key mismatch - "password_resets" referencing "users" on dropColumn

I'm trying to drop a column (lets call it fooboo) on 'users' table with migrations and i'm getting the next error:

General error: 1 foreign key mismatch - "password_resets" referencing "users" (SQL: INSERT INTO users (id, name, email, password, fooboo, created_at, updated_at) SELECT id, name, email, password, fooboo, created_at, updated_at FROM __temp__users)

The up() function in migration class:


    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->dropColumn('fooboo');
        });
    }

This column in particular doesn't have any index, FK or anything that could create conflict. It is just a boolean with a default value FALSE.

I'm getting this error with sqlite when running my unit tests (phpunit). I can't solve this problem just removing the column on migration class that creates it, i need a new migration to run on production server.

Asking our friend google, i can only find this error associated with missed migrations, that's not my case.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire