[Trac] Fun with SQLite Manager

2011-04-18 Thread David S
Ok, now that I've finally have two newly created projects working I'd figure I'd learn on how SQLite Manager works. I've been tasked with either removing a ticket complete (say, ticket #1700) or finding a way to remove a comment that exist within ticket #1700. Is the second option possible or is

Re: [Trac] Fun with SQLite Manager

2011-04-18 Thread David Chase
There's a trac-hack for that: http://trac-hacks.org/wiki/TicketDeletePlugin Apparently incorporated into 0.12, anyway. David On 2011-04-18, at 1:56 PM, David S wrote: Ok, now that I've finally have two newly created projects working I'd figure I'd learn on how SQLite Manager works. I've

Re: [Trac] Fun with SQLite Manager

2011-04-18 Thread Chris Mulligan
The SQL to do this is pretty easy. It should work just fine to do it in production, but to be safe you might bring down apache/tracd/whatever so there's no locking contention. If you just want to delete the comments from a specific author on a specific ticket: delete from ticket_change where