<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.28">
<TITLE>rt-remind and rt-escalate</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Has anyone had success in getting the scripts rt-remind and rt-escalate to</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Arial">work? I have a Fedora Core 3 system running and have not been able to get</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> </SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">either to work. The error messages that I am seeing in the /var/log/messages file are the following: </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 868. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1 at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 493. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: RT::Handle=HASH(0x9d6bc28) couldn't execute the query 'SELECT count(main.id) FROM GroupMembers main WHERE ((main.GroupId = )) ' at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 506 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9d6bc28)', 'SELECT count(main.id) FROM GroupMembers main WHERE ((main.G...') called at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 243 DBIx::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0xa569090)') called at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 1333 DBIx::SearchBuilder::Count('RT::GroupMembers=HASH(0xa569090)') called at ./rt-remind line 195 RT::getGroupMemberAddresses('Helpdesk-owners') called at ./rt-remind line 231 RT::getContacts('RT::Ticket=HASH(0xa56b28c)', 'RT::User=HASH(0xa5634e8)', 'Helpdesk') called at ./rt-remind line 171 (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: Use of uninitialized value in numeric ne (!=) at ./rt-remind line 195. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 868. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1 at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 493. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: RT::Handle=HASH(0x9d6bc28) couldn't execute the query 'SELECT count(main.id) FROM GroupMembers main WHERE ((main.GroupId = )) ' at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 506 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9d6bc28)', 'SELECT count(main.id) FROM GroupMembers main WHERE ((main.G...') called at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 243 DBIx::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0xa57ce74)') called at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 1333 DBIx::SearchBuilder::Count('RT::GroupMembers=HASH(0xa57ce74)') called at ./rt-remind line 195 RT::getGroupMemberAddresses('Helpdesk-owners') called at ./rt-remind line 231 RT::getContacts('RT::Ticket=HASH(0xa576e98)', 'RT::User=HASH(0xa5634e8)', 'Helpdesk') called at ./rt-remind line 171 (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: Use of uninitialized value in numeric ne (!=) at ./rt-remind line 195. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 868. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1 at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 493. (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: RT::Handle=HASH(0x9d6bc28) couldn't execute the query 'SELECT count(main.id) FROM GroupMembers main WHERE ((main.GroupId = )) ' at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 506 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9d6bc28)', 'SELECT count(main.id) FROM GroupMembers main WHERE ((main.G...') called at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 243 DBIx::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0xa58edfc)') called at /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 1333 DBIx::SearchBuilder::Count('RT::GroupMembers=HASH(0xa58edfc)') called at ./rt-remind line 195 RT::getGroupMemberAddresses('Helpdesk-owners') called at ./rt-remind line 231 RT::getContacts('RT::Ticket=HASH(0xa576c7c)', 'RT::User=HASH(0xa5634e8)', 'Helpdesk') called at ./rt-remind line 171 (/opt/rt3/lib/RT.pm:287) </FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Oct 5 16:09:18 rohelpdesk RT: Use of uninitialized value in numeric ne (!=) at ./rt-remind line 195. (/opt/rt3/lib/RT.pm:287)</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> </SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">Any help would be appreciated.</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> </SPAN></P>
</BODY>
</HTML>