[prev in list] [next in list] [prev in thread] [next in thread]
List: rt-users
Subject: Re: [rt-users] Create Ticker Error
From: "Speicher, Joshua (TekSecure Labs)" <JSpeicher () teksecurelabs ! com>
Date: 2008-01-31 16:12:00
Message-ID: AF5261A75EF9CB4E9E21860CADEDA506513084 () spike ! tekmarkinc ! com
[Download RAW message or body]
--===============2134819133==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C86423.F504FF3C"
This is a multi-part message in MIME format.
After more investigation, I've found the problem is with the
Priority-Labels patch. For some reason the priorities aren't being
translated back into their integer form. For example when updating a
ticket's priority I get an error:
Ticket 594: FinalPriority could not be set to ARRAY(0xad8bbfc).
Any ideas on where I should look to see why that array isn't being
properly translated into the Priority integer?
Joshua P Speicher
Web Developer/Security Engineer
TekSecure Labs (sm)
(a division of Tekmark Global Solutions)
E-Mail: jspeicher@teksecurelabs.com <mailto:jspeicher@teksecurelabs.com>
Cell: 484-269-6381
Home Office: 610-621-2484
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Speicher,
Joshua (TekSecure Labs)
Sent: Thursday, January 31, 2008 9:47 AM
To: RT-Users@lists.bestpractical.com
Subject: [rt-users] Create Ticker Error
I just upgraded our development RT from 3.6.5 to 3.6.6. In the process
SearchBuilder was upgraded to 1.51. In the process I 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:
[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)
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 '?'. From what I understand the '?'
should be replaced by the array of values passed to
SearchBuilder/Handle.pm.
Any ideas on how to fix this error, or at least help me figure out what
I broke.
Joshua P Speicher
Web Developer/Security Engineer
TekSecure Labs (sm)
(a division of Tekmark Global Solutions)
E-Mail: jspeicher@teksecurelabs.com
Cell: 484-269-6381
Home Office: 610-621-2484
------------------------------------------------------------------------
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.
------------------------------------------------------------------------
------------------------------------------------------------------------
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.
------------------------------------------------------------------------
[Attachment #3 (text/html)]
<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;}
@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: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;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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><span style='color:#1F497D'>After more investigation, I’ve
found the problem is with the Priority-Labels patch. For some reason the
priorities aren’t being translated back into their integer form. For \
example when updating a ticket’s priority I get an error: \
<o:p></o:p></span></p>
<p class=MsoNormal style='text-indent:.5in'><span style='color:#1F497D'>Ticket
594: FinalPriority could not be set to ARRAY(0xad8bbfc).<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Any ideas on where I should look
to see why that array isn’t being properly translated into the Priority \
integer?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><b><span \
style='font-family:"Cambria","serif";color:#1F497D'>Joshua P \
Speicher<o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Cambria","serif";
color:#1F497D'>Web Developer/Security Engineer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#1F497D'>TekSecure Labs
(sm)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#1F497D'>(a division of
Tekmark Global Solutions)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>E-Mail: <a
href="mailto:jspeicher@teksecurelabs.com"><span \
style='color:blue'>jspeicher@teksecurelabs.com</span></a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>Cell:
484-269-6381<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>Home Office:
610-621-2484<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span \
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span \
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>Speicher, \
Joshua (TekSecure Labs)<br> <b>Sent:</b> Thursday, January 31, 2008 9:47 AM<br>
<b>To:</b> RT-Users@lists.bestpractical.com<br>
<b>Subject:</b> [rt-users] Create Ticker Error<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<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. In the
process I 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 ‘?’. From what I \
understand the ‘?’ should be replaced by the array of values passed to \
SearchBuilder/Handle.pm.<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><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>
<p class=MsoNormal><span style='font-size:10.0pt'>E-Mail: <a
href="mailto:jspeicher@teksecurelabs.com">jspeicher@teksecurelabs.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>Cell: \
484-269-6381<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt'>Home Office: \
610-621-2484<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New \
Roman","serif"'>------------------------------------------------------------------------
<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>
------------------------------------------------------------------------ \
<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>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
--===============2134819133==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic