Can't Access my Instance from Browser, but Apps Work Fine?
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)
You're viewing a single thread.
Tried restarting the stack?
2 0 ReplyYep, restarted it a couple of times. (Sorry, my instance wasn't federated with this one so I didn't see the comment) Still, OP, just replying from my Beehaw account since I can't see your comment on my instance.
1 0 Reply