"Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearLE
Lemmy Support eleanor Now 100%

Can't Access my Instance from Browser, but Apps Work Fine?

I think this means that something is wrong with lemmy-ui, but I'm not sure what.

ETA: I'm eleanorOpossum on beehaw.org.

EDIT: FIGURED IT OUT

Cause: I deleted everything in the pictrs folder after the CSAM raid on lemmy.world. The UI was crashing because it couldn't load the site icon.

Solution: TL; DR: I ran this UPDATE site SET icon = NULL FROM local_site WHERE site.id = local_site.site_id; in the database.

My install uses lemmy-ansible, so my DB was in a docker container.

  • I ran docker ps to find the id of the container running the DB
  • Then I ran this to connected to it docker exec -it $CONTAINER_ID_FROM_DOCKER_PS pqsql -U lemmy -d lemmy
  • Then I searched for my instance in the
  • And then I ran this SQL expression to set my site icon to null; UPDATE site SET icon = NULL FROM local_site WHERE site.id = local_site.site_id;

Based on this comment and the rest of that thread (along with some basic SQL knowledge)

5
5
Comments 5