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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Cell: 484-269-6381 Home Office: 610-621-2484 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Speicher, Joshua (TekSecure Labs) Sent: Thursday, January 31, 2008 9:47 AM To: [email protected] 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: [EMAIL PROTECTED] 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. ------------------------------------------------------------------------
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
