[rt-users] AW: Deleting 'spam' tickets (Andy Moran)

[Andreas Wahlfeldt]

hi andy,

what you are going to do is EXTREMLY dangerous to the integrety of your
rt-db and as far as i know not supported in any way.
the recomended way to do this, would probably be to upgrade to rt3 and then
use rtx-shredder (http://search.cpan.org/~ruz/RTx-Shredder).

if you want/have to stay with rt2, there is a script that is supposed to do
what you need. 

notice: 
I'VE NEVER USED IT.
IT MIGHT BREAK YOUR DB.
IT MIGHT BREAK YOUR INSTALLATION FOR ANY FURTHER UPDATES.

you've been warned.
 
if (unsensibly enough) still being interested take a look here:

http://marc.free.net.ph/mbox/20031215.123203.713ec3e1.txt

but don't ever come and blame me.

good luck

cu
andreas

__________________________

Andreas Wahlfeldt
subshell GmbH
Margaretenstraße 43a
20357 Hamburg

t +49.40. 431 362-25
f +49.40. 431 362-29
e awahlfeldt(at)subshell.com
__________________________ 

> Message: 5
> Date: Wed, 24 Nov 2004 18:03:31 -0800
> From: Andy Moran <andy at wildbrain.com>
> Subject: [rt-users] Deleting 'spam' tickets
> To: rt-users at lists.bestpractical.com
> Message-ID: <41A53D73.2030408 at wildbrain.com>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> 
> Hello!
> 
> We are using RT 2.0.13.    Most of our tickets in our ticketing
> databases are a result of spam messages generating tickets.
> Fortunately, those get filtered to another queue where they await
> approval so we don't see them.. However, I feel like they are slowing
> down our ticketing system as there are hundreds of real tickets to
> thousands of spam generated tickets.
> 
> It was proposed that we manually go into our postgresql database and
> remove the tickets in question.     My questions:  Would removing
> (permanently) these tickets be possible, would it adversely effect RT
> somehow that the ticket no longer exists, and would RT reuse those
> ticket numbers at all?
> 
> 
> Thanks for your time!
> 
> --Andy
> 
> P.S.  We are thinking of reworking our system so that submissions marked
> as spam get held in a approval-only mailman list so they don't generate
> tickets until they are approved by someone.
>