[rt-users] Safely removing all 'DEAD' tickets

[Vivek Khera]

>>>>> "JV" == Jesse Vincent <jesse at bestpractical.com> writes:

JV> On Wed, Jan 22, 2003 at 11:01:13PM +0100, THAUVIN Blaise (Dir. Informatique FRP) wrote:
>> Hi Dave,
>> 
>> I think I have found one case where the script can corrupt the database. I
>> used it before trying to upgrade a database from RT2 to RT3 and it made the
>> import fail.
  
JV> For the record, I consider this to be a bug in my code for RT3 as well
JV> as the dead ticket deletion script ;) RT 2.1.62 should fix it.

Referential integrity checks in the DB are *good*.  Please tell the
MySQL folks. ;-)

I delete my dead tickets thusly: "delete from tickets where
status='dead'" and let the RI checks delete the associated records in
other tables.