I am having trouble with prisma admin and playground after renaming a required field. I have renamed

emailId: string! @unique

to

email: string! @unique @rename(oldName: "emailId")

. Now playground and admin don't give me

email

field to query with, but only

emailId

. And, if I use

emailId

field, I get this error in AWS logs:

{"key":"error/unhandled","requestId":"local:cjvtbwikjdlacjoicq6mx","clientId":"my-prisma@dev","payload":{"exception":"java.sql.SQLSyntaxErrorException: (conn=17632) Unknown column 'Alias.emailId' in 'field list'","query":"query GetUsers

All the trouble remains even after I have reset the data and deployed again (without

rename

directive this time) (I assume since it's not resetting schema). How do I fix this? Thanks! 🙂

Did you ever do a force deploy? Do you have access to the underlying database? Can you see how the actual DB structure looks like?

Hello @divyendu Really sorry that I din't see this message until now. Harshit, the master, solved it on screenshare. I wasn't deleting tables and their indexes properly from the workbench. Thank you 🙂

Awesomeness 🙂

Have a fresh query, and Harshit has switched off the day for good perhaps. You must be busy, so as you get some minutes, kindly look at my issue with reproduction in forum here: https://www.prisma.io/forum/t/prisma-category-self-relation-hierarchy-doesnt-set-child-categories-ever-and-takes-parent-only-for-one-category/7181

Shared with the guy who maintains Admin! 🙂