When attempting to add new data to an array, I encountered an error. Strangely enough, the creation is successful when the array is empty, but once it contains data, I get the following error message:
- error Error:
Invalid `prisma.user.update()` invocation:Unique constraint failed on the constraint: `_id_`
Below is the code snippet:
post.ts
const { id } = req.query as { id: string }
const { title, animeId, image } = req.body as { title: string; animeId: string; image: string }
if (!title || !animeId || !image) return res.status(400).send("Missing fields");
return prisma.user.update({
where: {
id: id as string
},
data: {
saved: {
create: {
title,
animeId,
image
}
}
},
include: {
saved: true
}
}).then(data => {
return res.status(200).send(data.saved)
})
schema.prisma
model User {
id String @id @default(auto()) @map("_id") @db.ObjectId
created DateTime @default(now())
name String
email String @unique
password String
saved SavedAnime[]
}
model SavedAnime {
id String @id @default(auto()) @map("_id") @db.ObjectId
user User? @relation(fields: [id], references: [id])
title String
animeId String
image String
}
Despite debugging the code and finding no issues, the error still arises when trying to insert new data into the array.