Thanks so much for the response! It is very much appreciated. How did it end up there was no record in CachedGroupMembers? To be honest, I don't know. I inherited this RT database from someone else, and I believe they made a number of changes blindly via SQL.
I sincerely appreciate your help. I apologize for the multiple posts -- my messages weren't appearing in the list archive, so I assumed they weren't going out to the list. If list members received multiples, I apologize profusely! Hopefully this will help others should they find CachedGroupMembers missing records. On Wed, Sep 10, 2008 at 11:28 AM, Ruslan Zakirov <[EMAIL PROTECTED]>wrote: > And now you should do: > UPDATE CachedGroupMembers SET Via = 81550 WHERE id = 81550; > > But major question is "how did it happen that there is no this record > in CachedGroupMembers table?" > > On Wed, Sep 10, 2008 at 8:00 PM, RT <[EMAIL PROTECTED]> wrote: > > All - > > > > I would like to get opinions on repairing my database using SQL. If > > there is a more graceful way to accomplish this using the RT perl > > modules (RT::CachedGroupMembers, etc) any help is appreciated. > > > > From the "RT Essentials" book (http://is.gd/2rG6), we find that in > > CachedGroupMembers: > > > > id == any incremental value > > GroupId == requestor group id > > MemberId == MemberId in question (requestor) > > Via == usually equal to the CachedGroupMembers id > > ImmediateParentId == requestor group id > > Disabled == 0 > > > > I'm going to work from the values in Ticket #1 (see previous message). > > > > insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); > > > > ** And Voila! ** The requestor appears in the regular Search as > > expected, and is searchable by requestor in Query Builder. > > > > And here is what it looks like in the end: > > > > mysql> select * from CachedGroupMembers where GroupId='52' and > > MemberId='34' and ImmediateParentId='52'; > > +-------+---------+----------+------+-------------------+----------+ > > | id | GroupId | MemberId | Via | ImmediateParentId | Disabled | > > +-------+---------+----------+------+-------------------+----------+ > > | 81550 | 52 | 34 | 0 | 52 | 0 | > > +-------+---------+----------+------+-------------------+----------+ > > > > Should the Disabled status be pulled from Principals? (select Disabled > > from Principals where id = '34') > > > > Any opinions on making these modifications is appreciated. > > > > On Wed, Sep 10, 2008 at 10:08 AM, RT <[EMAIL PROTECTED]> wrote: > >> RT Users - > >> > >> After some digging, I believe I've discovered why some tickets do not > >> appear when searched by Requestor. It appears that some records are > >> missing from CachedGroupMembers. > >> > >> Can anyone recommend a way of querying for the requestor from > >> GroupMembers and using that to populate CachedGroupMembers? > >> GroupMembers contains the correct requestors -- but that doesn't seem > >> to apply to the standard Search functions. >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
