I've been struggling with this problem for days now, tried everything possible, and googled more than anyone could ever google :)
What is the problem?
Someone tries to send an email to [email]firstname.lastname@example.org[/email] with an Arabic subject, when osTicket tries to fetch the message, the following error is sent to my admin email:
[INSERT INTO ost_ticket SET created=NOW() ,ticketID=162903,dept_id=4,topic_id='0',priority_id=2,email='xxxxxxx',name='xxxxxxxxxx',subject='���� �� ��� �����!!',helptopic='',phone="",phone_ext='',ip_address='xxxxxxxxxx',source='Email']
Incorrect string value: 'xD4xDFxE6xEC xE3...' for column 'subject' at row 1
While xxx are good data I changed for privacy concerns.
What version am I using?
Latest, the one got posted last month.
Also updated, checked to have the UTF support.. Edit manually to test, no problem!
More tests to make sure 100% it's only when sent from an email?
1. Tried to create a ticket using the form, with an Arabic subject, no problem at all.
2. Tried to send an email with an English subject, and Arabic body, also NO problem.
All.. I've tried gmail, hotmail.. same same!
This problem only presitst when the sender's subject is in Arabic.
Would appreciate any help.