SPAM in comments

• Deleting comments
  • cd to trac db dir

    cd /roll_trac/arb/db
    

  • Run this:

    sqlite3 trac.db "SELECT * FROM ticket_change WHERE ticket=NUM"
    

    Change the ticket NUMber to the one you want to affect.
  • You'll get something like this back:

    406|1134596968|tick|commentThis is at least .9, but probably needs to be moved to 1.00
    

  • Copy the second set of numbers, in this case the 1134596968.
  • This is the time you'll need for the next command

    sqlite3 trac.db "DELETE FROM ticket_change WHERE ticket=NUM and time=TIME"
    

    Change the ticket NUMber and the TIME to what you need.
    Voila, it's just gone.
    Found on:  http://trac.edgewall.org/ticket/454#comment:70