How to delete the comment of a deleted user?

Using Ghost
1

I’m running into the problem of the delete the comment for a deleted user. The only options that I can see are to explore the API or do some SQL edit to point the comment at an active user and then use impersonate to delete the comment.

Here is how the head of comment looks. The persons comment remains following this.

Screenshot 2023-10-30 at 7.06.37 am

Any ideas?

2

Not a fan of making edits to the database, but in this case could see no other way.

To fix issue of deleting a comment made by a an already deleted member used the following:

delete from comments where member_id is null;