Chris, Is this done via the sqlite-manager plugin on Firefox. Or was that a command line example?
On Apr 18, 6:30 pm, Chris Mulligan <[email protected]> wrote: > 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 ticket = 1700 and field = "comment" and > author="davids"; > > On Apr 18, 2011, 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 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 it better just to delete ticket #1700? > > > My question is, is there a problem with removing #1700 on an active > > Trac db? Currently we're up to 1750 and growing and here I am messing > > around with ticket #1700! :( Will the db know that #1700 is removed > > and just keep a "blank" entry for a non-existent #1700 if I choose to > > delete it (on an active db). > > > I'd rather just remove the comment within the ticket rather than > > remove the whole ticket number, if possible. > > > Also, what field do I look for when using the SQLite Manger on the > > Tables column when I decided on either removing the "comment" or the > > whole "ticket number?" > > > id > > name > > source > > target > > tempPath > > startTime > > endtime > > state > > > Above are just a few example fields I found in the moz_downloads table > > for downloads.sqlite db. And since I don't have SQLite installed yet > > on our Trac clients I'm just using the downloads.sqlite as an > > example. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Trac Users" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/trac-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
