Error Can't execute SQL: INSERT INTO `hesk_notes` (`ticket`,

[techuser]

Script URL: When updating a ticket.
Version of script: 2.3 latest updates.
Hosting company: Self-Hosted in IIS 7.5 Windows 2008 Server R2 with PHP.
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

I am getting this problem when I try to copy and paste from an email message. I will copy and paste the message into notepad to ensure that everything has been stripped. I will re-edit the message and try to eliminate spaces and still having the problem. It was not doing this until I moved the server to IIS 7.5 with PHP. Can someone please advise on how to remedy this problem?

Error:

Can't execute SQL: INSERT INTO `hesk_notes` (`ticket`,`who`,`dt`,`message`) VALUES ( '143', '2', NOW(), 'The customer was connected to VPN and getting a "172.XX.XX" address and couldn’t ping the Dell Wireless Projector. Once he disconnected from his VPN connection and went back to a "192.168.2.X" address he was able to ping the Dell Wireless Projector, install the Dell application, and is not presenting his laptop over the wireless connection.')

MySQL said:
Incorrect string value: '\x92t pin...' for column 'message' at row 1



WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

[Klemen]

This is probably an encoding inconsistency (between HESK and database).

If you remove apostrophe from couldn’t does it submit?


Also, version 2.4 has been released about 2 hours ago, you might want to upgrade to that. It should handle encoding better because it forces use of utf-8 for both Hesk and the database.

[techuser]

Yeah, I am getting this error every time I go to copy and paste content from Outlook emails to HESK, even when I choose the chrome option to paste as plain text..it seems to keep giving me this error.

MySQL said:
Incorrect string value: '\x92t get...' for column 'message' at row 1

I will try upgrading to the latest version of HESK and see if that resolves the issue, plus it looks like this version has auto-email feature that might work better to my work flow anyway.

thanks will let you know if it works.

[techuser]

Upgraded to HESK 2.4, by the way I had to restart IIS completely for the "delete install folder" to clear. For some reason I deleted the install folder, and it was still holding onto it.

It seems upgrading to the latest version has resolved the error that I was getting with mysql.

I am going to investigate this new email piping feature. It looks like it would be extremely helpful in my environment.