<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>All-<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Query =<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Queue = 'IT.Help' AND Updated = 'Mon Aug 01'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>It bombs with the following (see end of email) errors in the
log:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Has anyone seen this or know a resolution?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Tia-<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Jason Maderios<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Errors:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>