<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Horst;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You can also see the sql generated from QueryBuilder by setting
the DBIx log in your RT_SiteConfig:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>#DBIx-SearchBuilder 1.31_1 or higher; simply set
C<$StatementLog> to be<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>#the level that you wish SQL statements to be logged at.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Set($StatementLog,’debug’);<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Restart apache/web server and then you should be able to see the
statements in your rt.log file<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Regards;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Roy<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Kenneth
Crocker<br>
<b>Sent:</b> 06 July 2010 16:57<br>
<b>To:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> Re: [rt-users] Rép. : Re: R??p. : Re: Query Builder froze<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Horst,<br>
<br>
Depending on how much SQL you want to see, you can see most of the select and
display SQL when you click "Advanced" at the top.<br>
<br>
Kenn<o:p></o:p></p>
<div>
<p class=MsoNormal>On Tue, Jul 6, 2010 at 6:21 AM, Horst Kriegers <<a
href="mailto:Horst.Kriegers@loro.ch">Horst.Kriegers@loro.ch</a>> wrote:<o:p></o:p></p>
<div style='margin-left:3.0pt;margin-top:3.0pt;margin-right:3.0pt;margin-bottom:
.75pt'>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>Hi Kenn,<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>thanks for your answer.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>How can I see the QueryBuilder's executed query ?<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>Regards,<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'>Horst<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'><br>
>>> Le Mardi, 6. Juillet 2010 à 14:57, Kenneth Marshall <<a
href="mailto:ktm@rice.edu" target="_blank">ktm@rice.edu</a>> a écrit :<o:p></o:p></span></p>
</div>
<div style='border:none;border-left:solid #050505 1.0pt;padding:0cm 0cm 0cm 5.0pt;
margin-left:11.25pt'>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:black'>Hi Horst,<br>
<br>
Is the query hitting the DB the same with the CLI versus<br>
QueryBuilder? Maybe you are hitting a resource limit when<br>
the request goes through the web server. Try checking the<br>
system and web server logs to see if there is any more<br>
information. If it is not generating the same query, then<br>
that will give you a place to look for a problem. Good<br>
luck. At least, there is a good consulting group available<br>
should you need some expert assistance.<br>
<br>
Regards,<br>
Ken<br>
<br>
On Mon, Jul 05, 2010 at 11:20:42AM +0200, Horst Kriegers wrote:<br>
> I've tried in CLI mode and have no problem.<br>
> The execution of request is quick.<br>
> <br>
> Horst<br>
> <br>
> >>> Le Lundi, 5. Juillet 2010 ?? 08:58, "Horst
Kriegers"<br>
> <<a href="mailto:Horst.Kriegers@loro.ch" target="_blank">Horst.Kriegers@loro.ch</a>>
a ??crit :<br>
> Hi and tanks Kenn for your answer.<br>
> <br>
> <br>
> RT_Config : Identical (not modified)<br>
> <br>
> RT_SiteConfig - Differences are minimal : <br>
> - $rtname<br>
> - $DatabasePort<br>
> - $DatabaseUser<br>
> - $DatabaseName<br>
> - $ParseNewMessageForTicketCcs<br>
> - $LogToFileNamed<br>
> - $WebPort<br>
> <br>
> And log files contains nothings special<br>
> <br>
> <br>
> This behavior seem to appear by inserting Custom Fields in the query.<br>
> <br>
> <br>
> <br>
> Any idea where can I investigate to resolve this problem ?<br>
> <br>
> <br>
> Horst<br>
> <br>
> >>> Le Mercredi, 30. Juin 2010 ?? 16:53, Kenneth Crocker<br>
> <<a href="mailto:kfcrocker@lbl.gov" target="_blank">kfcrocker@lbl.gov</a>>
a ??crit :<br>
> Horst,<br>
> <br>
> What are the differences in you RT_Config and RT_SiteConfig.pm files?<br>
> <br>
> Kenn<br>
> LBNL<br>
> <br>
> On Wed, Jun 30, 2010 at 7:32 AM, Horst Kriegers<br>
> <<a href="mailto:Horst.Kriegers@loro.ch" target="_blank">Horst.Kriegers@loro.ch</a>>
wrote:<br>
> <br>
> <br>
> Hi,<br>
> Suze Linux 2.6.16<br>
> RT 3.6.6<br>
> Apache 2.2.6<br>
> MySQL 5.1.45<br>
> We have 2 instances of RT:<br>
> - DEV for development<br>
> - PRD for production<br>
> A query created in RT's Query Builder on the DEV environment works<br>
> fine.<br>
> By creating the same query on the PRD environment froze until timeout<br>
> appear.<br>
> I've tried to connect the RT DEV to MySQL PRD, all works fine.<br>
> I've tried to connect the RT PRD to MySQL DEV, it froze.<br>
> I've tried to compare the both RT's directory content, all seems to be<br>
> identical.<br>
> How can I solve this probl??m ?<br>
> Many thanks in advance.<br>
> Horst<br>
> <br>
> <br>
> _______________________________________________________________________<br>
> <br>
> Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou<br>
> l'organisme ?? qui il est destin??. Si vous n'??tes pas le destinataire<br>
> pr??vu, veuillez nous en informer au plus vite et d??truire le pr??sent<br>
> courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel,<br>
> de le distribuer ou de l'utiliser de quelque mani??re que ce soit. <br>
> _______________________________________________________________________<br>
> <br>
> The content of this e-mail is intended only and solely for the use of<br>
> the named recipient or organisation. If you are not the named recipient,<br>
> please inform us immediately and delete the present e-mail. In this<br>
> case, you are nor allowed to copy, distribute or use this e-mail in any<br>
> way. <br>
> _______________________________________________________________________<br>
> <br>
> <br>
> <br>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
> Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a>
<br>
> <br>
> <br>
> <br>
> <br>
> _______________________________________________________________________<br>
> <br>
> Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou<br>
> l'organisme ?? qui il est destin??. Si vous n'??tes pas le destinataire<br>
> pr??vu, veuillez nous en informer au plus vite et d??truire le pr??sent<br>
> courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel,<br>
> de le distribuer ou de l'utiliser de quelque mani??re que ce soit. <br>
> _______________________________________________________________________<br>
> <br>
> The content of this e-mail is intended only and solely for the use of<br>
> the named recipient or organisation. If you are not the named recipient,<br>
> please inform us immediately and delete the present e-mail. In this<br>
> case, you are nor allowed to copy, distribute or use this e-mail in any<br>
> way. <br>
> _______________________________________________________________________<br>
> <br>
> <br>
> ___________________________________________________________<br>
> Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou <br>
> l'organisme ?? qui il est destin??. Si vous n'??tes pas le destinataire<br>
> pr??vu, veuillez nous en informer au plus vite et d??truire le pr??sent<br>
> courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel,<br>
> de le distribuer ou de l'utiliser de quelque mani??re que ce soit.<br>
> <br>
> The content of this e-mail is intended only and solely for the use <br>
> of the named recipient or organisation. If you are not the named <br>
> recipient, please inform us immediately and delete the present e-mail. <br>
> In this case, you are nor allowed to copy, distribute or use this <br>
> e-mail in any way.<br>
> ___________________________________________________________<br>
<br>
> <br>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
> Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'><o:p> </o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>_______________________________________________________________________
</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'><o:p></o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>Le
contenu de ce courriel est uniquement réservé à la personne ou l'organisme à
qui il est destiné. Si vous n'êtes pas le destinataire prévu, veuillez nous en
informer au plus vite et détruire le présent courriel. Dans ce cas, il ne vous
est pas permis de copier ce courriel, de le distribuer ou de l'utiliser de
quelque manière que ce soit. </span><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:black'><o:p></o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>_______________________________________________________________________
</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'><o:p></o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>The
content of this e-mail is intended only and solely for the use of the named
recipient or organisation. If you are not the named recipient, please inform us
immediately and delete the present e-mail. In this case, you are nor allowed to
copy, distribute or use this e-mail in any way. </span><span style='font-size:
10.0pt;font-family:"Tahoma","sans-serif";color:black'><o:p></o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>_______________________________________________________________________
</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:black'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</body>
</html>