[rt-users] Rebuild Groups Table

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110621/9bcc446c/attachment.sig>