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