How to remove multiple items from queue

ragdoll

I think that every comment and discussion is being added to the AntiSpam plugin queue. Is this correct?
Anyway, I have removed a spamming user and its comments are still on the list. I can only mark them as not spam, since if I click the other button I obviously get an error.
How can I remove this entries?

hgtonight

What error do you get?

What version of Vanilla are you running?

ragdoll

It's the 404, since the user has been removed. Anyway, the 404 is not the problem. I'd like to know how to remove the entries.

pdfforge

We are using this sql to remove orphaned spam log entries:

-- DELETE DISCUSSIONS

create table tmp_spam_id (tid int(10));

insert into tmp_spam_id
SELECT l.ID FROM GDN_AntiSpamLog l
LEFT OUTER JOIN GDN_Discussion d ON l.ForeignID = d.DiscussionID
WHERE d.DiscussionID IS NULL
AND l.ForeignType = 'discussion';

DELETE FROM GDN_AntiSpamLog
WHERE
ForeignType = 'discussion'
AND ID IN (
SELECT tid FROM tmp_spam_id
);

DROP TABLE tmp_spam_id;

-- DELETE COMMENTS

create table tmp_spam_id (tid int(10));

insert into tmp_spam_id
SELECT l.ID FROM GDN_AntiSpamLog l
LEFT OUTER JOIN GDN_Comment c ON l.ForeignID = c.CommentID
WHERE c.CommentID IS NULL
AND l.ForeignType = 'comment';

DELETE FROM GDN_AntiSpamLog
WHERE
ForeignType = 'comment'
AND ID IN (
SELECT tid FROM tmp_spam_id
);

DROP TABLE tmp_spam_id;

That's no solution to the underlying problem, but helps for the moment.

We are thinking of ways to solve our spam problems and maybe we will create a fork of this module, enhace it and share it here again. Nothing promised right now though