[rt-users] Query problem when using Updated.

[Maderios, Jason]

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::Date::Set('RT::Date=HASH(0xc136c8c)', 'Format', 'ISO', 'Value', 'Mon Aug
01') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 588
RT::Tickets::_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::Tickets::_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::Tickets::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', '\'   <b><a
href="/Ticket/Display.html?id=__id__">__id__</a></...', '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::Date::Set('RT::Date=HASH(0xc101ab8)', 'Format', 'ISO', 'Value', 'Mon Aug
01') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 588
RT::Tickets::_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::Tickets::_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::Tickets::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)  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050805/57c1c682/attachment.htm>