382 Shredder deleting tickets and attachments?

If I use the built-in shredder to delete a ticket from the MySQL database, should it delete any attachments that were associated with that ticket? Or must I delete attachments separately?

Thank you,
PH

Paul Hirose : pthirose@ucdavis.edu : Sysadm Motto: rm -fr /MyLife
1034 Academic Surge : Programmer/Analyst : Backup Motto : rm -fr /
One Shields Avenue : Voice (530) 752-7181 : Robot, n.: Univ. Admin
Davis, CA 95616-8770 : Fax (530) 752-4465 : rec.pets.cat.anecdotes

Hi Paul,

This link could help you to understand how a ticket must be deleted:

http://wiki.bestpractical.com/view/DatabaseAdmin

Regards,

ALBERTO VILLANUEVA VAL
Consultor
Altran
ParqueEmpresarial Las Mercedes, Edificio 1
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57
www.altran.es-----Mensaje original-----
De: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] En nombre de Paul Hirose
Enviado el: jueves, 26 de febrero de 2009 21:41
Para: rt-users@lists.bestpractical.com
Asunto: [rt-users] 382 Shredder deleting tickets and attachments?

If I use the built-in shredder to delete a ticket from the MySQL database,
should it delete any attachments that were associated with that ticket? Or must
I delete attachments separately?

Thank you,
PH

Paul Hirose : pthirose@ucdavis.edu : Sysadm Motto: rm -fr /MyLife
1034 Academic Surge : Programmer/Analyst : Backup Motto : rm -fr /
One Shields Avenue : Voice (530) 752-7181 : Robot, n.: Univ. Admin
Davis, CA 95616-8770 : Fax (530) 752-4465 : rec.pets.cat.anecdotes
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Shredder deletes attachments with tickets.On Thu, Feb 26, 2009 at 11:40 PM, Paul Hirose pthirose@ucdavis.edu wrote:

If I use the built-in shredder to delete a ticket from the MySQL database, should it delete any attachments that were associated with that ticket? Or must I delete attachments separately?

Thank you,
PH


Paul Hirose : pthirose@ucdavis.edu : Sysadm Motto: rm -fr /MyLife
1034 Academic Surge : Programmer/Analyst : Backup Motto : rm -fr /
One Shields Avenue : Voice (530) 752-7181 : Robot, n.: Univ. Admin
Davis, CA 95616-8770 : Fax (530) 752-4465 : rec.pets.cat.anecdotes


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

So should rt-shredder NOT be used? Should the instructions in the wiki be used instead?

Separately, how do I delete Reminders? After I deleted all tix (or so I thought), I still had a couple Reminders in the DB. Should Reminders get deleted along w/Tix as well?

PHOn Fri, 27 Feb 2009, Alberto Villanueva wrote:

Hi Paul,

This link could help you to understand how a ticket must be deleted:

DatabaseAdmin - Request Tracker Wiki

Regards,

ALBERTO VILLANUEVA VAL
Consultor


Altran
ParqueEmpresarial Las Mercedes, Edificio 1
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57
www.altran.es

-----Mensaje original-----
De: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] En nombre de Paul Hirose
Enviado el: jueves, 26 de febrero de 2009 21:41
Para: rt-users@lists.bestpractical.com
Asunto: [rt-users] 382 Shredder deleting tickets and attachments?

If I use the built-in shredder to delete a ticket from the MySQL database,
should it delete any attachments that were associated with that ticket? Or must
I delete attachments separately?

Thank you,
PH


Paul Hirose : pthirose@ucdavis.edu : Sysadm Motto: rm -fr /MyLife
1034 Academic Surge : Programmer/Analyst : Backup Motto : rm -fr /
One Shields Avenue : Voice (530) 752-7181 : Robot, n.: Univ. Admin
Davis, CA 95616-8770 : Fax (530) 752-4465 : rec.pets.cat.anecdotes


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Paul Hirose : pthirose@ucdavis.edu : Sysadm Motto: rm -fr /MyLife
1034 Academic Surge : Programmer/Analyst : Backup Motto : rm -fr /
One Shields Avenue : Voice (530) 752-7181 : Robot, n.: Univ. Admin
Davis, CA 95616-8770 : Fax (530) 752-4465 : rec.pets.cat.anecdotes

So should rt-shredder NOT be used? Should the instructions in the
wiki be used instead?

Separately, how do I delete Reminders? After I deleted all tix (or
so I thought), I still had a couple Reminders in the DB. Should
Reminders get deleted along w/Tix as well?

I’ve found shredder reasonably reliable for deleting tickets. I’ve
found it to be much less reliable for deleting users… I’d quite like
to clear out all of the users which get created for spam tickets which
make it through, but I’ve had some difficulty. I’d have thought the
following procedure should work, in theory:

  1. Set status of spam tickets to deleted
  2. Use shredder to permanently remove tickets which are marked
    deleted (which works fine)
  3. Use shredder to remove those users who are not associated with any
    tickets (i.e. the no_tickets option to the users plugin)

This last step is where it falls down. I’ve tried it, and for some
reason it still ends up deleting some tickets, which rather suggests
that the no_tickets rule in the users plugin doesn’t quite work
properly. I haven’t yet found the time to hunt down the reason
though, I’m afraid,

Tim

The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.