PHPJunkyard support forum

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.

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.

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.

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.