#454: Edit ticket comments
----------------------------------------+-----------------------------------
Reporter: [EMAIL PROTECTED] | Owner: cboos
Type: enhancement | Status: new
Priority: normal | Milestone: 0.11
Component: ticket system | Version: 0.7
Severity: normal | Resolution:
Keywords: SPAM |
----------------------------------------+-----------------------------------
Comment (by [EMAIL PROTECTED]):
This is what I've been sending to other folks:
So here we go. These all require being in your trac-env/db folder (or
however you have it setup, you want to be in the folder with the db)
- Deleting comments
1) Run this: sqlite trac.db "SELECT * FROM ticket_change WHERE
ticket=406"
Change the ticket number to the one you want to
affect.
2) You'll get something like this back:
406|1134596968|tick|comment||This is at least .9, but
probably needs to be moved to 1.00
3) Copy the second set of numbers, in this case the 1134596968.
This is the time you'll need for the next command
4) sqlite trac.db "DELETE FROM ticket_change WHERE ticket=418 and
time=1136229618"
Change the ticket number and the time to what you
need. Viola, it's just gone.
- Deleting a ticket (I think, make a test ticket before doing this on a
live one)
1) sqlite trac.db "SELECT * FROM ticket WHERE id=549"
2) sqlite trac.db "DELETE FROM ticket WHERE id=549"
Hope this helps. For Growl, the spam got to be too much and I just
disabled nondevs ticket rights. It's sad, and not what I wanted, but oh
well.
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/454>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
