I’m looking to increase the column length of a varchar field. Pretty simple, I have done it before with no issues but I’m having errors this time and I’m thiking it’s because this is a Unique tagged column.

this is the prisma schema:

email   String      @unique @db.VarChar(128) /// from 80 to 120

this is the migration.sql

-- AlterTable
ALTER TABLE `users` MODIFY `email` VARCHAR(128);

and this is the error I got:

´´´

 migrate found failed migrations in the target database, new migrations will not be applied. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve
The `202405133507_alter_users_email_field_length` migration started at 2024-05-16 15:17:44.206 UTC failed

´´´