[rt-users] Rebuild Groups Table

[Kenneth Crocker]

Kevin,

What is rt-validator?

Kenn
LBNL

On Tue, Jun 21, 2011 at 12:14 PM, Kevin Falcone
<falcone at bestpractical.com>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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110621/a60d4bd9/attachment.htm>