[Trac-tickets] Re: [The Trac Project] #454: Edit ticket comments

[The Trac Project]

#454: Edit ticket comments
----------------------------------------+-----------------------------------
 Reporter:  tim.alsop at cybersafe.ltd.uk  |        Owner:  cboos
     Type:  enhancement                 |       Status:  new  
 Priority:  normal                      |    Milestone:  0.11 
Component:  ticket system               |      Version:  0.7  
 Severity:  normal                      |   Resolution:       
 Keywords:  SPAM                        |  
----------------------------------------+-----------------------------------
Comment (by Chris Ashworth):

 Although it won't be sufficient when the spam gets really bad, I've been
 dealing with comment spam as follows:

 I wrote two scripts, gettracdb and puttracdb to download (and upload) the
 trac.db file to my local machine.
 I grabbed [http://sqlitebrowser.sourceforge.net/ SQLite Database Browser]
 to edit the database.
 When I get spammed, I grab the database, open it, go to "Browse Data",
 select ticket_change, delete the offending rows, and then upload the
 database back onto my server.

 Not a long-term solution, but relatively painless for small volumes.

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/454>
The Trac Project <http://trac.edgewall.com/>