[rt-users] Extra requestor being added

[David T. Grayston]

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: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
> bounces at lists.bestpractical.com] On Behalf Of Thomas Sibley
> Sent: Friday, August 24, 2012 3:57 PM
> To: rt-users at lists.bestpractical.com
> 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.