Remove a ticket

Hi all,

I would to remove all tickets, but I don’t remove the whole database. Does
someone know which the best manner to do that?

I have a solution, but I don’t know if it’s the best:

mysql -p

use

delete * from Transactions;

delete * from Tickets;

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

http://www.altran.es www.altran.es

Hi all,

I would to remove all tickets, but I don’t remove the whole database. Does
someone know which the best manner to do that?

You can use RTx::Shredder for this (as a module from CPAN if RT < 3.8,
included in 3.8.x).

Hi,

When I execute the sentence (rt-shredder --force -plugin ‘Tickets=status,new’),
I get the next error:

[warning]: RT::CachedGroupMember-12— bla,bla,bla

I’sorry by the “warning”.

Any idea??

Thanks a lot!

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.esDe: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] En nombre de Emmanuel Lacour
Enviado el: martes, 17 de febrero de 2009 9:26
Para: rt-users@lists.bestpractical.com
Asunto: Re: [rt-users] Remove a ticket

Hi all,

I would to remove all tickets, but I don’t remove the whole database. Does
someone know which the best manner to do that?

You can use RTx::Shredder for this (as a module from CPAN if RT < 3.8,
included in 3.8.x).

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

I also created the indexes:

CREATE INDEX SHREDDER_CGM1 ON CachedGroupMembers(MemberId, GroupId, Disabled);
CREATE INDEX SHREDDER_CGM2 ON CachedGroupMembers(ImmediateParentId,
MemberId);

CREATE UNIQUE INDEX SHREDDER_GM1 ON GroupMembers(MemberId, GroupId);

CREATE INDEX SHREDDER_TXN1 ON Transactions(ReferenceType, OldReference);
CREATE INDEX SHREDDER_TXN2 ON Transactions(ReferenceType, NewReference);
CREATE INDEX SHREDDER_TXN3 ON Transactions(Type, OldValue);
CREATE INDEX SHREDDER_TXN4 ON Transactions(Type, NewValue);

Saludos,

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.esDe: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] En nombre de Alberto
Villanueva
Enviado el: martes, 17 de febrero de 2009 11:03
Para: ‘Emmanuel Lacour’; rt-users@lists.bestpractical.com
Asunto: Re: [rt-users] Remove a ticket

Hi,

When I execute the sentence (rt-shredder --force -plugin ‘Tickets=status,new’),
I get the next error:

[warning]: RT::CachedGroupMember-12— bla,bla,bla

I’sorry by the “warning”.

Any idea??

Thanks a lot!

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

De: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] En nombre de Emmanuel Lacour
Enviado el: martes, 17 de febrero de 2009 9:26
Para: rt-users@lists.bestpractical.com
Asunto: Re: [rt-users] Remove a ticket

Hi all,

I would to remove all tickets, but I don’t remove the whole database. Does
someone know which the best manner to do that?

You can use RTx::Shredder for this (as a module from CPAN if RT < 3.8,
included in 3.8.x).

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

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