Hi, I am trying to run the Prisma Upgrade CLI to upgrade my MySQL DB to Prisma 2, it gives me this: ALTER TABLE

File

ADD UNIQUE (

logoCompany

); but there is no field/column called logoCompany on File, so I get this error: Key column ‘logoCompany’ doesn’t exist in table Any ideas on how I can proceed from this state? Do I have to manually add the field and populate it with values? Or can I put the unique constraint on the Company field ‘logotype’ instead? Thanks 🙏🏼

Hey Josef 👋 Hmm, that sounds strange! Can you please open an issue in the `upgrade` repo, we'll look into it. Also, can you share you your Prisma 1 data model with the relevant types? (I assume

File

and

Company

would be relevant here.)

Thank you Nikolas! I have added an issue, let me know if I should add more info. https://github.com/prisma/upgrade/issues/89

Thanks for the issue, I'll write up a response there 👍

Great, thanks for formatting 🙂 My data model might not be the best one since migrating from Graphcool, but at least the system has worked so far 🙂

Great, thanks for formatting

No worries 😄

I hope so. I’ll do the same with the other 2 errors and continue with the upgrade process and we’ll see how it goes 🙂 If you have time, please have a look at my response on the issue so I know if I’m on the right track.

Probably better to create one (or multiple) new issue(s) for those 🙂

Hi @nikolasburk, sorry to bother you again. I added an issue and got a short response, but after my added info I heard no more. Can you confirm whether someone is looking at the issue? Big thanks 🙏🏼 https://github.com/prisma/upgrade/issues/90

Thanks for the ping, I just responded in the issue 🙂