[rt-users] RT3.0.8 on RHFC1 "Couldn't prepare Open Tickets"

[Jesse Vincent]

On Sat, Jan 03, 2004 at 09:47:53PM +0300, Fabrice LABORIE wrote:
> hi everyone !
> 

I believe that it's working correctly and should only fire when
correspondence happens on a new stalled or resolved ticket.

FWIW, Mysql 3.23 is unsupported. You really don't want to be running RT
with it.

> 
> I am running into a problem on a fresh install of RT 3.0.8 on RedHat Fedora 
> Core 1
> ( httpd-2.0.47-10 /  mysql-3.23.58-4 / mod_perl-1.99_09-10 / 
> DBIx::SearchBuilder 0.96  )
> 
> 
> the Owner is not getting notified of events:
> 
> I do see that the default scrips are supposed to be run:
> "
> Scrips which apply to all queues
> On Correspond Open Tickets with template Blank
> On Create Autoreply To Requestors with template Autoreply
> On Create Notify AdminCcs with template Transaction
> On Correspond Notify AdminCcs with template Admin Correspondence
> On Correspond Notify Requestors and Ccs with template Correspondence
> On Correspond Notify Other Recipients with template Correspondence
> On Comment Notify AdminCcs as Comment with template Admin Comment
> On Comment Notify Other Recipients as Comment with template Correspondence
> On Resolve Notify Requestors with template Resolved
> "
> 
> but it seems that rt is choking on something "Couldn't prepare Open Tickets 
> (/opt/rt3/lib/RT/Scrip_Overlay.pm:346)"
> so the recipient is not set for the scrips.
> 
> in the archive I saw a few "Couldn't prepare Open Tickets" posts, but 
> nothing really helpful.
> 
> 
> this is the log extract....
> 
> any idea ?
> 
> thank you for your help.
> 
> Fabrice.
> 
> 
> 
> [Sat Jan  3 18:23:05 2004] [debug]: Converting 'us-ascii' to 'utf-8' for 
> text/plain - Re: [SBM #8] AutoReply: abuse case 8
>  (/opt/rt3/lib/RT/I18N.pm:200)
> [Sat Jan  3 18:23:05 2004] [debug]: Found a ticket ID. It's 8 
> (/opt/rt3/lib/RT/EmailParser.pm:288)
> [Sat Jan  3 18:23:06 2004] [info]: RT::Scrip=HASH(0xa9e86b0): Couldn't 
> prepare Open Tickets (/opt/rt3/lib/RT/Scrip_Overlay.pm:346)
> [Sat Jan  3 18:23:07 2004] [info]: 
> <rt-3.0.8-8-31.13.8295961997175 at sbm.net.sa> #8/31 - Scrip 
> 4  (/opt/rt3/lib/RT/Action/SendEmail.pm:92)
> [Sat Jan  3 18:23:07 2004] [info]: 
> <rt-3.0.8-8-31.13.8295961997175 at sbm.net.sa>
>  No recipients found. Not sending.
>  (/opt/rt3/lib/RT/Action/SendEmail.pm:257)
> [Sat Jan  3 18:23:08 2004] [info]: 
> <rt-3.0.8-8-31.4.88654039683524 at sbm.net.sa> #8/31 - Scrip 
> 5  (/opt/rt3/lib/RT/Action/SendEmail.pm:92)
> [Sat Jan  3 18:23:08 2004] [info]: 
> <rt-3.0.8-8-31.4.88654039683524 at sbm.net.sa>
>  No recipients found. Not sending.
>  (/opt/rt3/lib/RT/Action/SendEmail.pm:257)
> [Sat Jan  3 18:23:09 2004] [info]: 
> <rt-3.0.8-8-31.14.6789159823587 at sbm.net.sa> #8/31 - Scrip 
> 6  (/opt/rt3/lib/RT/Action/SendEmail.pm:92)
> [Sat Jan  3 18:23:09 2004] [info]: 
> <rt-3.0.8-8-31.14.6789159823587 at sbm.net.sa>
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.