[rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?

[Ruslan Zakirov]

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 <rt at ragweed.net> 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 <rt at ragweed.net> 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.



-- 
Best regards, Ruslan.