Thanks for the advice Thomas - wish I'd known about those utilities before but still learning about RT and I get a bit ahead of myself.
rt-validator -c definitely uncovered a number of orphaned Transaction records and others that needed to be removed. Much better than hunting around and using raw SQL. David ------------------------------------------------------------------ David T. Grayston Systems & Database Administrator University of Washington School of Public Health Office of the Dean > -----Original Message----- > From: [email protected] [mailto:rt-users- > [email protected]] On Behalf Of Thomas Sibley > Sent: Friday, August 24, 2012 3:57 PM > To: [email protected] > Subject: Re: [rt-users] Extra requestor being added > > On 08/24/2012 03:39 PM, David T. Grayston wrote: > > Just following up to add that I’ve fixed this issue – definitely > > self-inflicted by previously editing the database directly . Prior to > > officially deploying for use I’d wanted to keep all of the queues, > > users, scrips, and templates that had been setup but wanted to remove > > all of the testing tickets and re-set the ticket count to #1. I missed > > fully purging the Groups table entries that make associations between > > ticket and the different roles/groups that are part of the ticket. > > Removing the remaining orphaned entries (for ticket numbers not-yet > > created) seems to have cured this issue. > > You'll probably want to run rt-validator now to see what other cruft is > hanging around the database. > > For future reference, rt-shredder is what you should be using to delete data > from the database, not SQL.
