1

Kbin moderation tools are still in the making. In the meanwhile Kbin admins should not be afraid of PostgreSQL....

TIL I learned that the magazine table has a visibility column that can be set to "trashed". It will not remove the magazine, but it will hide the magazine on your site.

You can use the psql command to login with your username/password credentials (eg. psql -U kbin or using the default user: psql -U postgres). Then connect to the kbin database using: \c kbin. Then try this SQL query:

UPDATE magazine set visibility ='trashed' where name ='blala@lemmy.ml';

Replace the name with the magazine you want to hide on your server. You can exit this command using \q.

no comments (yet)
sorted by: hot top controversial new old
there doesn't seem to be anything here
this post was submitted on 29 Jun 2023
1 points (100.0% liked)

Today I Learned

1 readers
1 users here now

Today I Learned (TIL). You learn something new every day; what did you learn today?

founded 1 year ago
MODERATORS