[rt-users] missing peoples problem

[Ken Crocker]

Jerrad,

I suspect that the ticket history for any tickets with these users as 
requestors will error out. This has happened to me before. I can show 
you how to fix it, but I will need some info.
First, get the UserID for each of these missing Requestors. Once we have 
those, we will have to run a series of SQL commands to find out just who 
is missing and what tickets are affected, including closed tickets. I 
hope you are familiar with SQL. What Database are you using? We're on 
Oracle, but the sequence of events should still be the same.

Kenn
LBNL

On 12/8/2009 1:34 PM, Jerrad Pierce wrote:
> Shredder overzealously wiped some information a few months back when I
> was cleaning
> out spam, and I'm just now discovering a very odd problem. I have a
> ticket whose requestor
> was in an odd state. Search results and the ticket display page showed
> no requestor,
> but the people page listed the requestor correctly. I removed the
> requestor in the hopes
> that adding him back would fix things, but this requestor does not
> show up when I search
> for him by name, email or id. I tried creating another user to use as
> the requestor, but
> this user also does not show up when searching, althouh plenty of
> other valid matches
> do.
>
> I've since gone back, found the removed entries from Principals &
> (Cached)GroupMembers
> to no avail.
>
> Any ideas what might be wrong and how to fix it?
>