Quote by: sirromjBut it's occurred to me that I might be missing something and other tables beside gl_comments might need things adjusting due to my deletions?
The comment count in the story also needs to be updated. More importantly, though, is that comments are stored in a tree structure, which needs to be re-balanced. This can not easily be done manually.
So, please try Tom's suggestion (using the Spam-X Mass Delete option) first.
If that doesn't help, writing a short piece of custom code that calls CMT_deleteComment() for each comment to be deleted would be another option. Just don't mess with the gl_comments table directly.
bye, Dirk