[rt-users] Error in viewing one ticket

[Ken Crocker]

Scott,

Every ticket will try to show it's history. In your case, it died trying 
to find a UserID on the USERS table that was identified in the 
transaction record. I recommend the following:

1) Get into the DataBase and find that Transaction (usually, I look at 
the history in that ticket and see where it stops. That gives me an idea 
of what to look for in terms of action)
2) Get the UserId identified in that transaction record and see if it is 
in the USERS table.
3) If not in the Users table, you have a couple of options on how to fix 
it, one being using SQL to change the UserID on that transaction record 
to a Users Id that already exist and will suffice as a replacement. This 
type of action would NOT meet the approval of Audit, but it WILL fix the 
error situation.

I have a set of SQL commands I have used in the past to resolve these 
types of problems. Let m eknow if you want them.

Kenn
LBNL

On 10/8/2009 8:59 AM, Lander, Scott wrote:
> I have one ticket that, when I go to view it, it displays about a half 
> of the details and then give the following error:
>  
> Can't call method "Name" on an undefined value at 
> /opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 700.
>  
>  
> Any one have any idea what could cause this?
>  
>  
>  
> ------------------------------------------------------------------------------------
> This e-mail message is intended only for the personal use of the recipient(s) named above. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the Hearst Service Center (cadmin at hearstsc.com) immediately by email and delete the original message.
> ------------------------------------------------------------------------------------
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091008/79d6388e/attachment.htm>