Hello, I'm having some issues with updating our da...
# orm-help
e
Hello, I'm having some issues with updating our database. I imagine it's due to forgetting to run migrate on a change or something but I'm really new to Prisma and its workflows so I'm a bit stuck on what to do. That image shows a change I did prior to the one I'm trying to do now and it seems I forgot to migrate that one as well. I cannot reset the database (prod). I've tried following the guides on here: https://www.prisma.io/docs/guides/database/production-troubleshooting#migration-history-conflicts specifically with the moving fowards but the resultant forwards.sql only includes information about the change I'm currently trying to do and has nothing about the sentVerification column. I am using a CMS called KeystoneJS which handles the prisma schema generation but it is up to me to run the prisma commands which is where I get a bit lost.
1
I believe I might've discovered the issue. When developing in KeystoneJS I needed to set an option to use migrations which is something I had forgotten to set when I finished developing version 1. The database already had all the changes I had made.
That was the issue. Setup a local postgres server to get a migration (why it wouldnt set up a migration on the prod idk) and then resolved it.
n
Glad to hear that you were able to resolve this 🙂 👍