hi I was trying to create a migration where I changed the ty Prisma #orm-help

hi, I was trying to create a migration where I cha...

Shamim Fahad

08/15/2022, 10:54 AM

hi, I was trying to create a migration where I changed the type of id from String to BigInt but I'm getting this error

Error: P3006

Migration

20220815103305_product_and_order_incremental_id

failed to apply cleanly to the shadow database. Error: db error: ERROR: value type string doesn't match type int of column "id" HINT: you will need to rewrite or cast the expression 0: sql_migration_connector::validate_migrations at migration-engine/connectors/sql-migration-connector/src/lib.rs:270 1: migration_core:state:DevDiagnostic at migration-engine/core/src/state.rs:250 can anyone help me about what I should do?

👀 1

Raphael Etim

08/24/2022, 9:49 AM

Hi @Shamim Fahad 👋 Were you able to fix this issue?

Shamim Fahad

08/25/2022, 5:57 AM

No, not actually

Raphael Etim

08/25/2022, 9:25 AM

Thanks for getting back to me. I'll try to reproduce this scenario and see if i can come up with a fix.

Shamim Fahad

08/25/2022, 10:02 AM

okay, thank you 🙂

Shamim Fahad

08/25/2022, 10:04 AM

I deleted my previous migrations for a workaround this problem since I was stuck with it

Raphael Etim

08/25/2022, 10:10 AM

Ah i see. I can actually see why there could be issues. The change in datatype from String to BigInt is actually a factor especially if you already had values stored on the column due to datatype mismatch.

Shamim Fahad

08/25/2022, 10:13 AM

I tried with a new db, but the issue remained

Shamim Fahad

08/25/2022, 10:15 AM

i mean I cleaned the table that I had the column, but I got the same result

Austin

08/30/2022, 7:10 PM

Can you share the code that is causing this error?

Open in Slack

Previous Next