<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>I just upgraded our development RT from 3.6.5 to
3.6.6. In the process SearchBuilder was upgraded to 1.51. And
reapplied the priority-labels patch from the Wiki. Everything seems to be
working correctly except for creating a ticket using the web interface.
The error I’m seeing is as follows:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>[Wed
Jan 30 17:01:12 2008] [crit]: Couldn't create a ticket: Internal Error:
Couldn't execute the query 'INSERT INTO Tickets (Status, Queue, Started, Type,
InitialPriority, Starts, LastUpdated, Subject, FinalPriority, Creator, Owner,
LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?)' (/opt/rt3/lib/RT/Ticket_Overlay.pm:602)<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I’m not sure how or why this is happening. First
I checked what the Priority Labels patch changed, and from what I can tell it shouldn’t
affect the insert values being ‘?’. I tracked the process to
insert a ticket and saw the following in SearchBuilder/Handle.pm.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>sub
InsertQueryString {<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
my($self, $table, @pairs) = @_;<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
my(@cols, @vals, @bind);<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
while ( my $key = shift @pairs ) {<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
push @cols, $key;<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
push @vals, '?';<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
push @bind, shift @pairs;<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
}<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
my $QueryString = "INSERT INTO $table";<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
$QueryString .= " (". join(", ", @cols) .")";<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
$QueryString .= " VALUES (". join(", ", @vals).
")";<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>
return ($QueryString, @bind);<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial","sans-serif"'>}<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Now I’m no Perl expert, but wouldn’t pushing ‘?’
result in all the @vals being ‘?’… or am I just going crazy
from staring at code for too long?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Any ideas on how to fix this error, or at least help me
figure out what I broke.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><b><span style='font-family:"Cambria","serif"'>Joshua P
Speicher<o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Cambria","serif"'>Web
Developer/Security Engineer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt'>TekSecure Labs (sm)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt'>(a division of Tekmark Global
Solutions)<o:p></o:p></span></p>
</div>
------------------------------------------------------------------------
<br>
This message is for the designated recipient only and it, as well as any attachments, may contain privileged, proprietary or confidential information. If you are not the intended recipient, do not read, copy or distribute it. Please notify the sender immediately and delete the original at once. Any other use of the email by you is prohibited. Thank you.
<br>
------------------------------------------------------------------------
</body>
</html>