Page 1 of 1

MySQL error when editing a ticket

Posted: Tue Jun 19, 2012 12:16 am
by Tangentwizard
I am getting the following error when editing a ticket message -

Can't execute SQL: UPDATE `hesk_replies` SET `message`='Hi Andrew,
\r\n
\r\nHave you another USB Cable? if so could you test it with that has it could be the USB Cable. Looking through our Support DB we have found two other incidences with Battery Chargers and on both occasions it was the USB Cable. If this is the case we will just send you a new USB Cable. If not will have to raise a RMA so as you can send it back for a replacement.
\r\n
\r\nCould you also supply us with the item code/sku
\r\n
\r\nBest regards,
\r\n
\r\nLeon Kaine
\r\nchinaTronics
\r\nhttp://www.chinatronics.com.au
\r\n ' WHERE `id`=70 AND `replyto`='9' LIMIT 1

MySQL said:
Incorrect string value: '\xA0' for column 'message' at row 1

Re: MySQL error when editing a ticket

Posted: Tue Jun 19, 2012 4:28 pm
by Klemen
That usually happens when your database charset isn't the same as the connection and/or page charset.

Can you let me know what version of PHP and MySQL you are using (sometimes upgrading to latest fixes this)?
What is your database charset and collation set to?