this post was submitted on 15 Jun 2023
17 points (94.7% liked)
main
1333 readers
1 users here now
Default community for midwest.social. Post questions about the instance or questions you want to ask other users here.
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I'm not that great at explaining but here goes: The activity table had some duplicate ap_ids that I guess were used to search for pictures and that delete I did cleared out all duplicates but left the earliest known rows that existed with each ap_id. So, I guess when it searches by ap_id and regular id for the link to the picture in pictrs it comes up blank because it shared an ap_id with another row that doesn't exist anymore and the regular id doesn't match what's in the query.