I have a few tables and I’m getting an error that I don’t quite follow

model Item {
  id       String @id @default(cuid()) 
  age    String

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  publishers  Publisher[]

}

Model Publisher {
  id            String @id @default(cuid()) 
  name          String @unique

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  media Item[]
}

When I try to create/upsert an Item, I get the error that publisher

name

is not unique (

Unique constraint failed on the fields: ("name")

. However, I’m using

connectOrCreate

within the upsert which means (in my understanding) if the current transaction has found that

name

already exists it should

connect

it (and not try to create it, which might be causing the error). Regardless, I’m trying to figure out where I’m wrong or what I can do to investigate more but so far I don’t understand how to solve this. I’d appreciate any help/thoughts from anyone 👍 (I have tried regenerating and that has not made a difference)

👋 Hello @Isaac Curtiss thank you for sharing the solution and I'm very glad to see you resolved this issue! I'm very curious about your use case, is this for an app in production? Can you tell us a little more about your tech stack?

Hey! Yea, sure I was working on a quick proof of concept/quick MVP with the RemixJS framework. This was not for a production application 👍

Ah I see! Did you end up having a successful MVP with Prisma and Remix?

Yep! I was able to get it working