SN: submit error: Invalid `prisma.$queryRawUnsafe()` \ stacker news ~meta

pull down to refresh

SN: submit error: Invalid `prisma.$queryRawUnsafe()`

156 sats \ 6 comments \ @AG 6 Mar 2024 meta

Trying to submit a post as usual, but getting this error when clicking on post:

submit error: Invalid prisma.$queryRawUnsafe() invocation: Raw query failed. Code: 23503. Message: insert or update on table "ItemUpload" violates foreign key constraint "ItemUpload_uploadId_fkey"

https://m.stacker.news/19146

What's next?

view all related items

0 sats \ 2 replies \ @Jon_Hodl 25 Nov 2024

I am having this same issue right now. It seems like I have to re-upload my images since it's a post I have been working on for a few days.

21 sats \ 1 reply \ @AG OP 26 Nov 2024

Is a media issue, meaning you uploaded an image on SN more than 24h ago in your post. Just delete and reapload the image and will be fine ;)

0 sats \ 0 replies \ @Jon_Hodl 26 Nov 2024

Thanks for the reply. I will get the new images uploaded.

0 sats \ 2 replies \ @AG OP 6 Mar 2024

Ok I got the image that is giving the issue m.stacker.news/18588 look's like isn't available anymore, how it's possible?

0 sats \ 1 reply \ @ek 6 Mar 2024 freebie

We delete images that weren't used in a post or comment within 24 hours but I think that shouldn't apply here. When did you upload the image?

However, seems like the issue was indeed that the image was deleted in our database. The error basically says that the image wasn't found in our database (violates foreign key constraint "ItemUpload_uploadId_fkey").

For anon uploads, we delete the image within 1 hour if unused. Did you upload it without being logged in maybe?