TIL how-to disable a magazine on /kbin

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.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • tech
  • drbboard
  • updates
  • testing
  • til
  • bitcoincash
  • programming
  • Sacramento
  • All magazines