Error: db error: ERROR: syntax error at or near ","
   0: sql_migration_connector::sql_database_step_applier::apply_migration
             at migration-engine\connectors\sql-migration-connector\src\<http://sql_database_step_applier.rs:11|sql_database_step_applier.rs:11>
   1: migration_core::api::SchemaPush
             at migration-engine\core\src\<http://api.rs:184|api.rs:184>

i keep getting this error from

npx prisma db push

, and i really cant fix it or figure out whats wrong. it started happening when prisma was telling me It will have to drop my data to push my db, because I changed my enum (but the enum is identical to whats in the database except with a different name), so I simply went into the database and manually renamed the enum to match what it is in my prisma schema, so that prisma wouldnt have to drop my data. the only 2 outcomes i can get are prisma saying it has to drop my data, or the above error. anything i should try/do?

@Garrick Chippendale 👋 Any reason you’re using

prisma db push

instead of Migrate? Usually changing names in the schema and running

db push

will delete the older type and create a new one. So you can’t change that directly in the database and run

db push

again.