this post was submitted on 04 Jun 2025
110 points (99.1% liked)

Fediverse

34115 readers
702 users here now

A community to talk about the Fediverse and all it's related services using ActivityPub (Mastodon, Lemmy, KBin, etc).

If you wanted to get help with moderating your own community then head over to !moderators@lemmy.world!

Rules

Learn more at these websites: Join The Fediverse Wiki, Fediverse.info, Wikipedia Page, The Federation Info (Stats), FediDB (Stats), Sub Rehab (Reddit Migration)

founded 2 years ago
MODERATORS
ruud@lemmy.world
TragicNotCute@lemmy.world
Xylinna@lemmy.world
MrCenny@lemmy.world
automodbeta@lemmy.world
woelkchen@lemmy.world
110
How will we deal with all the broken images? (lemm.ee)
submitted 2 days ago by Irelephant@lemm.ee to c/fediverse@lemmy.world
35 comments fedilink hide all child comments
 

When an instance goes down, all of the images on it go with it. there's going to be a lot from lemm.ee, especially given its size.

you are viewing a single comment's thread
view the rest of the comments
[–] ptz@dubvee.org 53 points 2 days ago* (last edited 2 days ago) (1 children)

I'm gonna run some scripts on my instance's database to look for posts that have lemm.ee pict-rs URLs and local thumbnails. Then update the url value to that of the local thumbnail_url. That'll at least fix them on my instance where I have a copy.

I won't be doing that until after lemm.ee shuts down, otherwise the original values will federate back in if there's any activity on the posts.

For comment images or ones where my instance didn't create a thumbnail, they'll just have to be broken I guess - same goes for the community icons, though I suppose I could go ahead and get local versions of those and update the communities afterward. Prob also set those to "Mods only" in the database to keep local users from trying to post there.

For user avatars, I'll probably just clear those in the database so when looking back at old content from .ee, it won't try to fetch them and timeout/404.

There were less posts to worry about then, but for community icons and user avatars, that's the same thing I did when kbin shut down.

[–] Shadow@lemmy.ca 18 points 2 days ago* (last edited 2 days ago) (1 children)

Mind empowering my laziness and sharing that query?

I was also planning on bulk locking all their communities, to avoid any isolated islands of people that don't realize the community is gone.

[–] ptz@dubvee.org 10 points 2 days ago* (last edited 2 days ago)

I'm still putting that together, but it's basically something like:

UPDATE post set url = thumbnail_url where thumbnail_url like 'https://dubvee.org/pictrs/image/%' and url like 'https://lemm.ee/pictrs/image/%'

For the Kbin users to clear out their avatar/banners, I just did:

UPDATE person set avatar=NULL, banner=NULL where instance_id=(select id from instance where domain='kbin.run')

UPDATE community set icon=NULL, banner=NULL where instance_id=(select id from instance where domain='kbin.run')

...and will update that for lemm.ee

I'm working on a Bun/NodeJS script to download the avatars, icons, and banners for all the lemm.ee users/communities, upload them to my pictrs, and then update the DB with the new values referencing the local images.

Prob gonna have to break that up into two steps so I can download and file the images before lemm.ee goes down and upload/assign them after (so they're not overwritten by federation).

Not sure if I'm gonna do that for comment / post body images. Basically, I just want the archived communities to look nice.