this post was submitted on 02 Jul 2023
19 points (100.0% liked)

Geddit

5 readers
1 users here now

Geddit

We are a friendly community that runs on free open source software.

Basic community rules:

founded 1 year ago
MODERATORS
 

After upgrading Geddit.social to Lemmy v0.18 the whole platform broke..

After many hours of editing configs, debugging and trying out various fixes a little database query to remove the "site icon" fixed it and now are back online!

I'll keep an eye out on further issues..

you are viewing a single comment's thread
view the rest of the comments
[–] stux@geddit.social 8 points 1 year ago (2 children)

The exact fix for us using Docker:

  • Run docker exec -it <postgres-container> "bash" to connect to your postgres database container.
  • Run psql -U lemmy to connect to the database with the lemmy user.
  • Run update site set icon = null where id = 1; then \q then exit

By randommouse on Github](https://github.com/LemmyNet/lemmy-ui/issues/1530#issuecomment-1605781461)

[–] IbuMichele@mas.to 2 points 1 year ago
[–] jsalvador@mastodon.social 2 points 1 year ago (1 children)

@stux U can actually run this as one single command :-)

[–] stux@geddit.social 2 points 1 year ago (1 children)

Haha im sure i could! But im not such a docker expert and i was happy with this already 😃

[–] jsalvador@mastodon.social 2 points 1 year ago (1 children)

@stux Learning is always a long travel!

[–] shipp@mastodon.coffee 2 points 1 year ago

@jsalvador @stux activitypub is cool, this is simultaneously a Lemmy and mastodon thread and I couldn't even tell lol