RT3.0.8 on RHFC1 "Couldn't prepare Open Tickets"

hi everyone !

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@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@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@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@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@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@sbm.net.sa

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@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@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@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@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@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@sbm.net.sa


rt-users mailing list
rt-users@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.