The database fix that I did broke some pictures for users and communities. Just an FYI on why you might not be seeing some.

  • seahorse [Ohio]OPMA
    link
    fedilink
    English
    arrow-up
    7
    ·
    1 year ago

    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.