MySQL error when editing a ticket
Posted: Tue Jun 19, 2012 12:16 am
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
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