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.