[rt-users] rt-remind and rt-escalate

[Kaplan, Andrew H.]

Has anyone had success in getting the scripts rt-remind and rt-escalate to work?
I have a Fedora Core 3 system running and have not been able to get 
either to work. The error messages that I am seeing in the /var/log/messages
file are the following: 

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)  
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)  
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)  
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)  
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)  
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)  
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)  
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)  
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)  
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)  
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)  
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) 

Any help would be appreciated.  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051005/9b68e6db/attachment.htm>