[rt-users] Remove a ticket

[Alberto Villanueva]

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.es
 

-----Mensaje original-----
De: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] En nombre de Alberto
Villanueva
Enviado el: martes, 17 de febrero de 2009 11:03
Para: 'Emmanuel Lacour'; rt-users at 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
 

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

On Tue, Feb 17, 2009 at 09:21:27AM +0100, Alberto Villanueva wrote:
> 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 at 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 at bestpractical.com


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