Unique constraint failed on the (not available)

Original message was deleted

averagedev999•11/6/23, 10:56 AM

are you sure about the unique constraint on chatRoomId in the event model?

perako•11/6/23, 10:59 AM

just tested it again, now its not allowing me to upload event even the first one, its saying
Invalid

prisma.event.create()

prisma.event.create()

invocation:
Unique constraint failed on the (not available),

tryna figure out whats wrong

perako•11/6/23, 11:07 AM

it seems like I did the explicit many to many relation wrong,

I tried to make it implicit and now it works again

averagedev999•11/6/23, 11:08 AM

awesome

perako•11/6/23, 11:08 AM

But tryna make it to explicit tho for role staff,

can you review my UserInChatRoom?

averagedev999•11/6/23, 11:09 AM

i don’t get the question

perako•11/6/23, 11:10 AM

theres a photo of UserInChatRoom in my question,

I think I did it wrong,
Im tryna make it a explicit many to many

averagedev999•11/6/23, 11:12 AM

try setting up a composite unique index on userId and chatRoomId instead of just userId

averagedev999•11/6/23, 11:12 AM

cuz one user can be in many chat rooms

averagedev999•11/6/23, 11:13 AM

btw i g2g now and will answer other questions later in the evening

Balduin•11/6/23, 11:42 AM

that

toast

toast

are you using? is it custom or a libary?

perako•11/6/23, 6:29 PM

react-hot-toast library