DB error when insert to ost_ticket_message

eteract

Hi,

I am using the cron job (e.g. cron.php) to retrieve support email.

However, I noticed some of the emails will cause DB error when cron.php is trying to insert email content to ost_ticket_message table.

Error Msg: "Incorrect string value when insert to ost_ticket_message"

I have pasted the following DB error:

Incorrect string value: 'xA0x0Ax0Ax0AEm...' for column 'message' at row 1

Kelli

Change your DB table to UTF8. You're trying to insert a character that the current table's character set cannot support.

mrceolla

Hi,

I am having this same problem with tickets created from emails. I get:

Incorrect string value: 'xC2x0AAlso...' for column 'message' at row 1

But those characters are not there. I have tried changing my table to UTF8 but that did not help. The error still occurs on certain emails.

Any other suggestions?

Any help is greatly appreciated. Thank you.

Mike

________

(BMW V5 history)

mrceolla

Bump.

I continue to get this error message. I have changed my DB to utf8_general_ci but this has not stopped these errors.

Does anyone have any other suggestions?

Mike

________

(EV Plus)

mrceolla

It seems like messages from Yahoo always have this problem.

Please, someone, tell me how to fix this. It is very annoying and shouldn't be that hard to resolve. I just don't have a firm understanding of all this character set BS.

Is Yahoo using a different type of encoding? Can I convert it before trying to insert it into the DB, or eliminate the problem characters?

This sucks!!!!!!!

________

(sauteing)

mrceolla

Am I the only one having this problem still????????

Does no one have any suggestions or advice?????

This is a huge problem for us and it needs to get fixed ASAP.

Some one...anyone...please HELP!

Mike

________

(magic flight launch box)

mrceolla

I believe I have located the problem character.

=A0

At the bottom of the DB error email it states:

Incorrect string value: 'xA0our w...' for column 'message' at row 1

I viewed the source on the DB error emails and did a search on "our w" and sure enough, saw this:

change to=A0our website

So, my question is, what is this character and how do I get rid of it? Will a simple replace work on those 3 characters "=", "A", "0". Or are those 3 characters a representation of a single character. If the later, what is that character code?

Someone, pretty please, help us out here.

Thanks,

Mike

________

(Toyota Succeed)

mrceolla

Sorry to keep posting but I'm getting close...I think. Found this:

? %A0 Non-breaking space

So is my =A0 a non-breaking space?

How do I do a replace on that character and what file should I do that in?

Thanks,

Mike

________

(swed)

mrceolla

Damn...little to no help on these forums, huh?

Anyway, hopefully this will help someone else out. Here's what I did to stop these SQL errors:

File: class.ticket.php

Line: around 613 in v1.6 Stable

Action: change the "message=" line to something like this

',message='.db_input(Format:(preg_replace("/\xa0/"," ",preg_replace("/\s/"," ",str_ireplace("\xA0"," ",str_ireplace("=A0"," ",str_replace(chr(160)," ",$msg))))))). //Tags/code stripped...meaning client can not send in code..etc

I'm sure there's a better way to solve this problem and I hope the developers figure it out before the next release.

________

(volcano vaporizer)