[rt-users] CC's not working.

Vicki Stanfield vicki at progeny.com
Thu May 26 10:45:59 EDT 2005


I have seen other posts concerning CC's not working in RT, but a google 
search produced nothing that looked like the problem I am having. CC's 
on my system just don't work - in creation, comment, or replies. 
Incidently, some of my users claim that this feature worked up until 
yesterday morning. I think that the only config change with regard to RT 
was a change in RT_SiteConfig.pm as follows:

#Set($RTAddressRegexp , '^rt\@progeny.com$');
Set($RTAddressRegexp , '^tickets\@progeny.com$');

which I assume is necessary since the RT instance is referred to by 
http://tickets.progeny.com.

I get this in my mail logs on my RT system:

May 25 17:30:31 moe RT: 
<rt-3.4.1-10747-53934-3.16.8177927024377 at progeny.com> #10747/53934 - 
Scrip 3 (/opt/rt3/lib/RT/Action/SendEmail.pm:235)
May 25 17:30:31 moe RT: 
<rt-3.4.1-10747-53934-3.16.8177927024377 at progeny.com> sent To: Cc: Bcc: 
vicki at progeny.com (/opt/rt3/lib/RT/Action/SendEmail.pm:295)
May 25 17:30:31 moe RT: 
<rt-3.4.1-10747-53934-15.7.98929864261133 at progeny.com> #10747/53934 - 
Scrip 15 (/opt/rt3/lib/RT/Action/SendEmail.pm:235)
May 25 17:30:31 moe RT: 
<rt-3.4.1-10747-53934-15.7.98929864261133 at progeny.com> No recipients 
found. Not sending. (/opt/rt3/lib/RT/Action/SendEmail.pm:247)
May 25 17:30:31 moe RT: 
<rt-3.4.1-10747-53934-31.17.6632343304242 at progeny.com> #10747/53934 - 
Scrip 31 (/opt/rt3/lib/RT/Action/SendEmail.pm:235)
May 25 17:30:31 moe RT: 
<rt-3.4.1-10747-53934-31.17.6632343304242 at progeny.com> sent To: 
hoeferbe at progeny.com Cc: Bcc:(/opt/rt3/lib/RT/Action/SendEmail.pm:295)
May 25 17:30:31 moe RT: Ticket 10747 created in queue 'System 
Administration' by hoeferbe (/opt/rt3/lib/RT/Ticket_Overlay.pm:730)
May 25 17:30:31 moe RT: DBD::mysql::st execute failed: Unknown column 
'main.LookupType' in 'where clause' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480. 
(/opt/rt3/lib/RT.pm:277)
May 25 17:30:31 moe RT: RT::Handle=HASH(0x552d18a390) couldn't execute 
the query 'SELECT main.* FROM CustomFields main , ObjectCustomFields 
ObjectCustomFields_1 WHERE ((ObjectCustomFields_1.ObjectId = 
'8')OR(ObjectCustomFields_1.ObjectId = '0')) AND ((main.Disabled = '0')) 
AND ((main.LookupType = 'RT::Queue-RT::Ticket')) AND ((main.id = 
ObjectCustomFields_1.CustomField)) ORDER BY 
ObjectCustomFields_1.ObjectId ASC, ObjectCustomFields_1.SortOrder ASC' 
at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494. 
(/opt/rt3/lib/RT.pm:277)
May 25 17:30:31 moe RT: DBD::mysql::st execute failed: Unknown column 
'main.LookupType' in 'where clause' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480. 
(/opt/rt3/lib/RT.pm:277)
May 25 17:30:31 moe RT: RT::Handle=HASH(0x552d18a390) couldn't execute 
the query 'SELECT main.* FROM CustomFields main , ObjectCustomFields 
ObjectCustomFields_1 WHERE ((ObjectCustomFields_1.ObjectId = 
'8')OR(ObjectCustomFields_1.ObjectId = '0')) AND ((main.Disabled = '0')) 
AND ((main.LookupType = 'RT::Queue-RT::Ticket-RT::Transaction')) AND 
((main.Name = NULL)) AND ((main.id = ObjectCustomFields_1.CustomField)) 
ORDER BY ObjectCustomFields_1.ObjectId ASC, 
ObjectCustomFields_1.SortOrder ASC' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494. 
(/opt/rt3/lib/RT.pm:277)
May 25 17:30:31 moe RT: DBD::mysql::st execute failed: Unknown column 
'main.LookupType' in 'where clause' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480. 
(/opt/rt3/lib/RT.pm:277)
May 25 17:30:31 moe RT: RT::Handle=HASH(0x552d18a390) couldn't execute 
the query 'SELECT main.* FROM CustomFields main , ObjectCustomFields 
ObjectCustomFields_1 WHERE ((ObjectCustomFields_1.ObjectId = 
'8')OR(ObjectCustomFields_1.ObjectId = '0')) AND ((main.Disabled = '0')) 
AND ((main.LookupType = 'RT::Queue-RT::Ticket-RT::Transaction')) AND 
((main.Name = NULL)) AND ((main.id = ObjectCustomFields_1.CustomField)) 
ORDER BY ObjectCustomFields_1.ObjectId ASC, 
ObjectCustomFields_1.SortOrder ASC' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494. 
(/opt/rt3/lib/RT.pm:277)
May 25 17:30:31 moe RT: DBD::mysql::st execute failed: Unknown column 
'main.LookupType' in 'where clause' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480. 
(/opt/rt3/lib/RT.pm:277)
May 25 17:30:31 moe RT: RT::Handle=HASH(0x552d18a390) couldn't execute 
the query 'SELECT main.* FROM CustomFields main , ObjectCustomFields 
ObjectCustomFields_1 WHERE ((ObjectCustomFields_1.ObjectId = 
'8')OR(ObjectCustomFields_1.ObjectId = '0')) AND ((main.Disabled = '0')) 
AND ((main.LookupType = 'RT::Queue-RT::Ticket-RT::Transaction')) AND 
((main.Name = NULL)) AND ((main.id = ObjectCustomFields_1.CustomField)) 
ORDER BY ObjectCustomFields_1.ObjectId ASC, 
ObjectCustomFields_1.SortOrder ASC' at 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494. 
(/opt/rt3/lib/RT.pm:277)

Any hints would be appreciated.

Vicki



More information about the rt-users mailing list