Re: [rt-users] missing peoples problem

2009-12-17 Thread Jerrad Pierce
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

[rt-users] missing peoples problem

2009-12-08 Thread Jerrad Pierce
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

Re: [rt-users] missing peoples problem

2009-12-08 Thread 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

Re: [rt-users] missing peoples problem

2009-12-08 Thread Jerrad Pierce
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. Nope, we actually have several tickets in that state, where part way through the display of transaction

Re: [rt-users] missing peoples problem

2009-12-08 Thread Ken Crocker
Jerrad, It looks to me as though the actual User record is missing from the USER Table. The reason the history croaks is because RT is walking thru the ticket history and there is a reference to a UserID that no longer exists. You need to look at the Transaction history to determine what is