* trac-admin $TRAC_ENV ticket remove <id-of-spam-only-ticket>
This is trivial even now - just delete everything with the ticket# from
TICKET_CHANGE and set the necessary values in TICKET.
* http://trac-hacks.org/wiki/TicketDeletePlugin on Trac Hacks, which
also has the ability
to delete specific comments
Changes where only comments are added are also easy to get rid of - just
delete them from TICKET_CHANGE - comments do not have the
oldvalue-newvalue chain.
However there are cases when a spammer changes other fields with or
without changing the comment.
So I am still back to the drawing board - not knowing enough SQL +
sqlite-supported procedural language to do this.
I would believe that similar work will be necessary in cases beyond spam
fighting (filtering out changes based on some criteria). This is a
problem not bound to this oldish version of TRAC but will be useful in
future as well.
Yes - it is my problem but I think that no matter the anti-spam measures
- public sites will always have spam that needs to be purged.
Kind regards:
al_shopov
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
