Hi guys,
recently our trac 0.8.4 was overwhelmed by spam in a very short period.
We have to clean the database in order to continue.
As there are tickets that are pure spam, there are tickets that contain
some spam and there are tickets with spam comments and changes made by
spammers I thought of the following solution but I am not sure how to
actually do it.
1. Make a table like ticket, just add an additional column called 'comment'
2. Regenerate all past states of tickets in the table - one row
corresponds to one state (that could have several changed fields).
3. Then from the table with all states - delete the spam states.
4. Regenerate the non spam ticket and ticket_change tables.
Can anyone help me with ideas?
Kind regards:
al_shopov
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
