Kevin, I also noticed, while perusing the DB, that there are a lot of gaps in ticket numbers and the create dates are in the evening when no one is around in the building, usually around midnight (TICKETS sorted in ID sequence).
Kenn LBNL On Tue, Jun 21, 2011 at 12:39 PM, Kenneth Crocker <[email protected]> wrote: > Kevin, > > What is rt-validator? > > Kenn > LBNL > > On Tue, Jun 21, 2011 at 12:14 PM, Kevin Falcone <[email protected] > > wrote: > >> On Tue, Jun 21, 2011 at 12:10:02PM -0700, Kenneth Crocker wrote: >> > I'm looking thru a bunch of tickets (created back when we upgraded to >> 3.8.7) and I noticed >> > there were no requestors for those tickets. I went into each of those >> tickets to add a >> > Requestor and Viola' I got an error saying the group couldn't be >> found. Sure enough, there are >> > a WHOLE SERIES of tickets that have no requestors and no groups >> (AdminCc, Cc, Requestors, >> > Owners). Soooo, I was wondering if anyone had any SQL or code to >> correct this situation. >> > >> > I'm thinking if I just add the Groups using SQL, then I could just do >> a bulk update within RT >> > to get Requestors in those tickets. By going at it that way, I should >> have to worry about the >> > ACL, etc. >> >> How exactly did you lose the groups? >> >> I suggest seeing what rt-validator has to say about your dataset. >> >> -kevin >> >> >> -------- >> 2011 Training: http://bestpractical.com/services/training.html >> > >
-------- 2011 Training: http://bestpractical.com/services/training.html
