I enabled Jira's anonymous bug reporting/commenting feature but without any anti-spam protection. Now I have thousands of spam. I think I can safely do something akin to deleting all comments everywhere between two dates and get rid of 99.9% of spam. How can I do this?
No way to do this from user interface. You might want to do this at database, Search for comments from jiraaction table between those dates and then remove them!
Do this only while JIRA is offline and reindex after it is back up.
this was the solution I needed. Quick, easy, painless. Thank you.
The query was DELETE FROM jiraaction WHERE actiontype="comment" AND id > [first id of spam]; worked great
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.