<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.16.3">
</HEAD>
<BODY>
<BR>
(apologies for the html email, but I wanted to paste an html table)<BR>
<BR>
On Tue, 2008-02-19 at 10:59 -0800, Kenneth Crocker wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Tom,</FONT>
<FONT COLOR="#000000"> Would you mind listing for me any scrips you have relating to a status </FONT>
<FONT COLOR="#000000">change and emails as a result of said change? What kind of action </FONT>
<FONT COLOR="#000000">precipitated the initial scrip being triggered? Could be that an email </FONT>
<FONT COLOR="#000000">notification scrip is looking for a template that you modified or </FONT>
<FONT COLOR="#000000">misnamed (capitol letters?, etc.) and can't find it. Anyway, that list </FONT>
<FONT COLOR="#000000">and their contents will help the debugging process.</FONT>
</PRE>
</BLOCKQUOTE>
<BR>
It seems to hang for example when changing the ticket status from "resolves" to "open", the last line in the log is;<BR>
<BR>
[Wed Feb 20 17:06:11 2008] [debug]: About to commit scrips for <BR>
transaction #6464 (/opt/rt3/lib/RT/Transaction_Overlay.pm:180)<BR>
<BR>
I checked out transaction id #6464 and its just this;<BR>
<BR>
<B><FONT SIZE="6">SELECT * FROM Transactions T where id = '6464' LIMIT 0,10000</FONT></B><BR>
<TABLE CELLSPACING="1" CELLPADDING="0" BORDER="1">
<TR>
<TH ALIGN="center">
<B>id</B>
</TH>
<TH ALIGN="center">
<B>ObjectType</B>
</TH>
<TH ALIGN="center">
<B>ObjectId</B>
</TH>
<TH ALIGN="center">
<B>TimeTaken</B>
</TH>
<TH ALIGN="center">
<B>Type</B>
</TH>
<TH ALIGN="center">
<B>Field</B>
</TH>
<TH ALIGN="center">
<B>OldValue</B>
</TH>
<TH ALIGN="center">
<B>NewValue</B>
</TH>
<TH ALIGN="center">
<B>ReferenceType</B>
</TH>
<TH ALIGN="center">
<B>OldReference</B>
</TH>
<TH ALIGN="center">
<B>NewReference</B>
</TH>
<TH ALIGN="center">
<B>Data</B>
</TH>
<TH ALIGN="center">
<B>Creator</B>
</TH>
<TH ALIGN="center">
<B>Created</B>
</TH>
</TR>
<TR>
<TD>
6464
</TD>
<TD>
RT::Ticket
</TD>
<TD>
545
</TD>
<TD>
0
</TD>
<TD>
Status
</TD>
<TD>
Status
</TD>
<TD>
resolved
</TD>
<TD>
open
</TD>
<TD>
<BR>
</TD>
<TD>
<BR>
</TD>
<TD>
<BR>
</TD>
<TD>
<BR>
</TD>
<TD>
22
</TD>
<TD>
2008-02-20 17:06:10
</TD>
</TR>
</TABLE>
<BR>
there are no logs, in the apache error_log or fastcgi log<BR>
<BR>
Tom<BR>
<BR>
<BR>
</BODY>
</HTML>