Permanently Delete Comments

Using Ghost
1

How can I permanently delete a comment on a blog post?

I’ve got a spam comment and I can hide it, but it shows the following messages under the comments:

  • for subscribers: This comment has been hidden.
  • for non-subscribers: This comment has been removed.

I would like to permanently delete the comment so the above messages aren’t shown at all.

Is it possible?

2 Likes
2

I’d like to know that too.
I got a nasty comment from an anonymous member, who it seems signed up just to torment me. I’m thinking of removing this member, since I don’t know who it is and he/she left a nasty comment. I have hidden it, but I want to remove it permanently, but I can’t find settings for it anywhere. Very annoying!

3 Likes
3

Sorry to hear that. Hope they just go away.

Meanwhile, it would be really nice to eliminate all traces of deleted comments. I don’t really see the use of “This comment has been hidden/removed” messages.

1 Like
4

Yep, it’s one of those scratch your head moments, I don’t get that either.

2 Likes
5

@software_writer Yes, it should be a possibility to handle comments properly, edit them, remove them, hide them, give warnings and of course totally delete them.

1 Like
6

I’m not sure if we can “fake” delete comments for subscriber display with CSS.

7

Hmm, interesting idea. Will have to investigate but sounds like a possible solution. I already hide/modify a bunch of stuff on the page with CSS and JavaScript so it could work.

Thanks @cuongtran!

8

There’s a way to log in as the other user and delete the comment as such. I can’t find the option to hide the comment, myself, but I was able to delete it like that.

9

I’ve heard about that, but it would be a huge no-no for me since I need permission from the user in order to do so. Like I’ve mentioned before, I have had some help from a friend and this person leaving the nasty comments has most likely stopped now. The account is still there and it will remain until he removes it himself.

1 Like
10

Hide “This comment has been hidden”.. meilechh shared this a while back and it works perfectly for me. It doesn’t perm delete them, but it at least hides the messages saying they’ve been removed.

11

wait, there’s a line saying the comment has been removed! why is there a line saying the comment has been removed? who does that benefit?

2 Likes
12

That’s a very good question. Beats me.

1 Like
13

If you self host, or have access to the database, first backup your database, then do the following:

  1. Connect to the database, the credentials would be in /path/to/your-ghost/installation. View the credentials by doing nano config.production.json
  2. connect to the database using mysql client. mysql -u ghost_user -p -h 127.0.0.1 ghost_production. Enter password when prompted
  3. you’re looking for comments table. select id from comments where status = 'deleted'. This would give you the deleted comment id.
  4. Delete the comment. delete from comments where id = 'comment_id'