Im doing some import of Facebook Post the Feeds module.

Im running into troubles with some mysql-error saying: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF3\xBE\x8C\xA7 M...' for column 'field_message_value' at row 1

I have located a post causing this issue:

https://graph.facebook.com/20446254070_10151404646659071?access_token= (From page facebook.com/businessinsider)

..- with the message-content:

"This flawless 101-carat diamond just sold for $26.7 million — http://read.bi/107CfXZ
Are you amazed more by the diamond or the hefty price tag?
(Photo: Christie's)"

Is it the dollar-sign causing some funky behaviour, or is it my databse which is weird.

My mysql is configures to default to utf8-character set all over.

I have tried to look what format the json sents the message with with mb_detect_encoding($entry->message), which just list ASCII and UTF-8 results.

Can any one point me in the direction of a solution for my issue?

Comments

Jooblay.net’s picture

[reˈpuβlika ðel ekwaˈðor] Republic of Ecuador from the wikipedia page was causing this error through ckeditor.

The quick fix for us was just remove the characters.

megachriz’s picture

Issue summary: View changes
Status: Active » Closed (duplicate)