ok so guys you wont believe this i found this community called fuck draconic and i made a post called “guys what is this community about” with this gif to better represent my emotions and i got banned from it i mean what the heck

gif was

  • Unruffled [they/them]@lemmy.dbzer0.comMEnglish
    7·
    4 days ago

    DMs can only be purged directly from the database afaik db0, according to the Lemmy World HQ chat anyways, snippet below:

    update private_message
set deleted = true
from person
where person.id = private_message.creator_id
and person.actor_id in ('https://example.world/u/johndoe', 'https://example.world/u/janedoe');

    Unfortunately, they aren’t automatically removed on the banning of a user.

    Ping for @[email protected] for when you are back in action.

    • Draconic NEO@lemmy.dbzer0.com
      9·
      4 days ago

      Damn that sucks, this seems like an oversight, if a user is purged it should also delete their messages from the database, just like it deletes all their posts and comments.