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 ='[email protected]';
Replace the name with the magazine you want to hide on your server. You can exit this command using \q
.
You must log in or # to comment.