There seems to be an issue with responding to tickets. I have a ticket which is now overdue and I am wanting to respond to it but there is no text area to type in my response. I have been able to respond to ticket previously but all I get now is a header summary. See attached fileThanksDanny
Please read and follow this thread: Please read before requesting assistance. Thank you.
The issue is occurring on the admin side of the site. I enter the ticket to answer but there is not text field to answer the ticket.I am setup with one team - Level 1 SupportI am setup with one group - FFI SupportI am setup with one department - SupportI am assigned to each of those.I simply can't respond to the ticketRegardsDannyWhen the ticket is created by the client it's assigned to Level 1 Support
based on the fact that it isn't finishing displaying the form, I'm guessing that there is an error some where. Please consult your PHP and Webserver logs and post any errors taht you may find here.
Hi here is the error that we are getting from osticketFatal
error: Uncaught exception
'OrmException' with message 'Unable to execute query: Incorrect
arguments to mysql_stmt_execute' in
/home/ffisuppo/public_html/ticket/include/class.orm.php:1002 Stack
trace: #0 /home/ffisuppo/public_html/ticket/include/class.orm.php(990):
MysqlExecutor->execute() #1
/home/ffisuppo/public_html/ticket/include/class.orm.php(1057):
MysqlExecutor->_prepare() #2
/home/ffisuppo/public_html/ticket/include/class.orm.php(440):
MysqlExecutor->getArray() #3
/home/ffisuppo/public_html/ticket/include/class.orm.php(451):
ModelInstanceIterator->fillTo(9223372036854775807) #4
/home/ffisuppo/public_html/ticket/include/class.orm.php(334):
ModelInstanceIterator->asArray() #5
/home/ffisuppo/public_html/ticket/include/class.user.php(284):
QuerySet->all() #6
/home/ffisuppo/public_html/ticket/include/class.user.php(217):
User->getDynamicData() #7 :
User->getPhoneNumber() #8
/home/ffisuppo/public_html/ticket/include/class.client.php(203):
call_user_func(Array) #9 : EndUser->__c in/home/ffisuppo/public_html/ticket/include/class.orm.phpon line 1002
Upgrade to PHP 5.5+ Below is my system information. Also since V1.9.2 is out, you may want to consider upgrading your osticket system too.Let me know how it goes!
Ok thank you will give it a go
Now that you have posted an error I will point this thread out to the devs to take a look.
All of a sudden I do get following error when I try to see details of an open ticket - urgent help requested, thank youFatal error: Uncaught exception 'Exception' with message 'ArrayIncorrect arguments to mysqld_stmt_execute' in /homepages/13/d247396827/htdocs/RPART/osticket/include/class.orm.php Stack trace: #0 /homepages/13/d247396827/htdocs/RPART/osticket/include/class.orm.php(937): MysqlExecutor->next() #1 /homepages/13/d247396827/htdocs/RPART/osticket/include/class.orm.php(373): MysqlExecutor->getArray() #2 /homepages/13/d247396827/htdocs/RPART/osticket/include/class.orm.php(403): ModelInstanceIterator->fillTo(0) #3 /homepages/13/d247396827/htdocs/RPART/osticket/include/class.ticket.php(106): ModelInstanceIterator->valid() #4 /homepages/13/d247396827/htdocs/RPART/osticket/include/class.ticket.php(88): Ticket->loadDynamicData() #5 /homepages/13/d247396827/htdocs/RPART/osticket/include/class.ticket.php(56): Ticket->load('765') #6 /homepages/13/d247396827/htdocs/RPART/osticket/include/class.ticket.php(1790): Ticket->Ticket('765') #7 /homepages/13/d247396827/htdocs/RPART/osticket/scp/tickets.php(30): Ticket:('765') #8 {main} in/homepages/13/d247396827/htdocs/RPART/osticket/include/class.orm.php on line 918
Sorry - missed to add information on system as per attached image now
I am also getting the same problem. Just started this morning.Fatal error: Uncaught exception 'Exception' with message 'ArrayIncorrect arguments to mysqld_stmt_execute' in /homepages/4/d179938047/htdocs/cp/osticket/include/class.orm.php Stack trace: #0 /homepages/4/d179938047/htdocs/cp/osticket/include/class.orm.php(937): MysqlExecutor->next() #1 /homepages/4/d179938047/htdocs/cp/osticket/include/class.orm.php(373): MysqlExecutor->getArray() #2 /homepages/4/d179938047/htdocs/cp/osticket/include/class.orm.php(403): ModelInstanceIterator->fillTo(0) #3 /homepages/4/d179938047/htdocs/cp/osticket/include/class.ticket.php(106): ModelInstanceIterator->valid() #4 /homepages/4/d179938047/htdocs/cp/osticket/include/class.ticket.php(88): Ticket->loadDynamicData() #5 /homepages/4/d179938047/htdocs/cp/osticket/include/class.ticket.php(56): Ticket->load('15098') #6 /homepages/4/d179938047/htdocs/cp/osticket/include/class.ticket.php(1790): Ticket->Ticket('15098') #7 /homepages/4/d179938047/htdocs/cp/osticket/scp/tickets.php(30): Ticket:('15098') #8 {main} thrown in/homepages/4/d179938047/htdocs/cp/osticket/include/class.orm.php on line 918Server InformationosTicket Version v1.8.0.2Server Software ApachePHP Version 5.4.30MySQL Version 5.1.73
Hi jtaubmann,did you answer a ticket without closing it yesterday? I assume that my problem came up after doing that before the problem started.I did upgrade to 1.8.4 successfully - now the error does not appear anymore but all tickets blank when clicking on it. Database still filled with text so i assume that there is a sql error not retrieving information.
Are you using 1&1 for hosting? Seems strange we both got the same error in a short time of each other
Yes, 1&1, assumed this with you as well looking at your error message ... but as this topic mentions "responding to open ticket" I had thissuspicion ... will try to recover from last week backup to find out if this works ... furthermore I cannot add new tickets ... the subject line will not written into database ... frustrating .... lot of unnecessary work
Hi,same problem with 1&1. After long search i found the solution.Go to you 1&1 Account and set at Hosting the PHP to Version 5.5. Then it works again. :)Sry for my bad english.Cya
Hi overtaked,+2 to you - you are the man ... bloody hell 1&1 ... Updated meanwhile to 1.9.2 and tested new ticketeverything fine, cheers and germany to win tonight :-)
Thanks all, I have mine working now. 1&1 swear they did not change anything, BUT the build date on the 5.4 PHP is the 2nd July 2014!
I have 5.3 by default and no way to change this.It just started happening today. Host For Web is the provider.Any additional advice?P.
@[deleted] My advice would be to have you please start your own thread, and provide information about your setup.see thread: Please Read Before Requesting assistance
