All-
I am trying to build a query that searches a queue for any activity on a
certain day. Basically show me any ticket in queue IT.HELP that had
activity (Updated) on day.
Query =
Queue = ‘IT.Help’ AND Updated = ‘Mon Aug 01’
It bombs with the following (see end of email) errors in the log:
Has anyone seen this or know a resolution?
Tia-
Jason Maderios
Errors:
Aug 5 13:37:51 bigbro RT: at /opt/rt3/lib/RT/Date.pm line 192
RT:
:Set(‘RT::Date=HASH(0xc136c8c)’, ‘Format’, ‘ISO’, ‘Value’, ‘Mon Aug
01’) called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 588
RT:
:_TransDateLimit(‘RT::Tickets=HASH(0xc185cd4)’, ‘Updated’, ‘=’,
‘Mon Aug 01’, ‘SUBCLAUSE’, ‘’, ‘ENTRYAGGREGATOR’, ‘’, ‘SUBKEY’, …) called
at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 328
RT::_parser(‘RT::Tickets=HASH(0xc185cd4)’, ’ Updated = 'Mon Aug
01' AND Queue = 'IT.Help' ') called at
/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 480 eval {…} called at
/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 480
RT::FromSQL(‘RT::Tickets=HASH(0xc185cd4)’, ’ Updated = 'Mon Aug
01' AND Queue = 'IT.Help' ') called at
/opt/rt3/share/html/Search/Results.html line 91
HTML::Mason::Commands::ANON(‘Query’, ’ Updated = 'Mon Aug 01' AND
Queue = 'IT.Help' ', ‘Format’, ‘' id</…’, ‘Order’, ‘ASC’,
‘OrderBy’, ‘id’, ‘Rows’, …) called at /us
Aug 5 13:37:51 bigbro RT: DBD::mysql::st execute failed: Table ‘rt3._3’
doesn’t exist at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 480. (/opt/rt3/lib/RT.pm:277)
Aug 5 13:37:51 bigbro RT: RT::Handle=HASH(0xb471fa4) couldn’t execute the
query 'SELECT COUNT(DISTINCT main.id) FROM (Tickets main JOIN _3 ON (
_3.id = Attachments_2.TransactionId)) , Transactions Transactions_1,
Attachments Attachments_2 WHERE ((Transactions_1.ObjectType =
‘RT::Ticket’)) AND ((main.EffectiveId = main.id)) AND ((main.Status !=
‘deleted’)) AND ((main.Type = ‘ticket’)) AND ( ( (Attachments_2.Created =
‘Mon Aug 01’)AND(main.id = Transactions_1.ObjectId) ) AND(main.Queue = ‘3’))
’ at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
Aug 5 13:37:51 bigbro RT: DBD::mysql::st execute failed: Table ‘rt3._3’
doesn’t exist at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 480. (/opt/rt3/lib/RT.pm:277)
Aug 5 13:37:51 bigbro RT: RT::Handle=HASH(0xb471fa4) couldn’t execute the
query 'SELECT COUNT(DISTINCT main.id) FROM (Tickets main JOIN _3 ON (
_3.id = Attachments_2.TransactionId)) , Transactions Transactions_1,
Attachments Attachments_2 WHERE ((Transactions_1.ObjectType =
‘RT::Ticket’)) AND ((main.EffectiveId = main.id)) AND ((main.Status !=
‘deleted’)) AND ((main.Type = ‘ticket’)) AND ( ( (Attachments_2.Created =
‘Mon Aug 01’)AND(main.id = Transactions_1.ObjectId) ) AND(main.Queue = ‘3’))
’ at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
Aug 5 13:37:51 bigbro RT: at /opt/rt3/lib/RT/Date.pm line 192
RT::Set(‘RT::Date=HASH(0xc101ab8)’, ‘Format’, ‘ISO’, ‘Value’, ‘Mon Aug
01’) called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 588
RT::_TransDateLimit(‘RT::Tickets=HASH(0xc160194)’, ‘Updated’, ‘=’,
‘Mon Aug 01’, ‘SUBCLAUSE’, ‘’, ‘ENTRYAGGREGATOR’, ‘’, ‘SUBKEY’, …) called
at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 328
RT::_parser(‘RT::Tickets=HASH(0xc160194)’, ’ Updated = 'Mon Aug
01' AND Queue = 'IT.Help' ') called at
/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 480 eval {…} called at
/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 480
RT::FromSQL(‘RT::Tickets=HASH(0xc160194)’, ’ Updated = 'Mon Aug
01' AND Queue = 'IT.Help' ') called at
/opt/rt3/share/html/Elements/TicketList line 117
HTML::Mason::Commands::ANON(‘Query’, ’ Updated = 'Mon Aug 01' AND
Queue = 'IT.Help' ', ‘AllowSorting’, 1, ‘OrderBy’, ‘id’, ‘Order’, ‘ASC’,
‘Rows’, …) called at
/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 1
Aug 5 13:37:51 bigbro RT: DBD::mysql::st execute failed: Table ‘rt3._3’
doesn’t exist at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 480. (/opt/rt3/lib/RT.pm:277)
Aug 5 13:37:51 bigbro RT: RT::Handle=HASH(0xb471fa4) couldn’t execute the
query 'SELECT COUNT(DISTINCT main.id) FROM (Tickets main JOIN _3 ON (
_3.id = Attachments_2.TransactionId)) , Transactions Transactions_1,
Attachments Attachments_2 WHERE ((Transactions_1.ObjectType =
‘RT::Ticket’)) AND ((main.EffectiveId = main.id)) AND ((main.Status !=
‘deleted’)) AND ((main.Type = ‘ticket’)) AND ( ( (Attachments_2.Created =
‘Mon Aug 01’)AND(main.id = Transactions_1.ObjectId) ) AND(main.Queue = ‘3’))
’ at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)
Aug 5 13:37:51 bigbro RT: DBD::mysql::st execute failed: Table ‘rt3._3’
doesn’t exist at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
line 480. (/opt/rt3/lib/RT.pm:277)
Aug 5 13:37:52 bigbro RT: RT::Handle=HASH(0xb471fa4) couldn’t execute the
query ‘SELECT DISTINCT main.* FROM (Tickets main JOIN _3 ON ( _3.id =
Attachments_2.TransactionId)) , Transactions Transactions_1, Attachments
Attachments_2 WHERE ((Transactions_1.ObjectType = ‘RT::Ticket’)) AND
((main.EffectiveId = main.id)) AND ((main.Status != ‘deleted’)) AND
((main.Type = ‘ticket’)) AND ( ( (Attachments_2.Created = ‘Mon Aug
01’)AND(main.id = Transactions_1.ObjectId) ) AND(main.Queue = ‘3’)) ORDER BY
main.id ASC LIMIT 50’ at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.
(/opt/rt3/lib/RT.pm:277)