{"action":"created","issue":{"url":"https://api.github.com/repos/warmshowers/Warmshowers.org/issues/881","labels_url":"https://api.github.com/repos/warmshowers/Warmshowers.org/issues/881/labels{/name}","comments_url":"https://api.github.com/repos/warmshowers/Warmshowers.org/issues/881/comments","events_url":"https://api.github.com/repos/warmshowers/Warmshowers.org/issues/881/events","html_url":"https://github.com/warmshowers/Warmshowers.org/issues/881","id":111312497,"number":881,"title":"PDO failure on message blocks all following with 500 error","user":{"login":"rfay","id":112444,"avatar_url":"https://avatars.githubusercontent.com/u/112444?v=3","gravatar_id":"","url":"https://api.github.com/users/rfay","html_url":"https://github.com/rfay","followers_url":"https://api.github.com/users/rfay/followers","following_url":"https://api.github.com/users/rfay/following{/other_user}","gists_url":"https://api.github.com/users/rfay/gists{/gist_id}","starred_url":"https://api.github.com/users/rfay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfay/subscriptions","organizations_url":"https://api.github.com/users/rfay/orgs","repos_url":"https://api.github.com/users/rfay/repos","events_url":"https://api.github.com/users/rfay/events{/privacy}","received_events_url":"https://api.github.com/users/rfay/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/warmshowers/Warmshowers.org/labels/Critical","name":"Critical","color":"e10c02"},{"url":"https://api.github.com/repos/warmshowers/Warmshowers.org/labels/D7%20Upgrade","name":"D7 Upgrade","color":"fef2c0"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-10-14T03:09:52Z","updated_at":"2015-10-14T17:30:46Z","closed_at":null,"body":"https://www.warmshowers.org/admin/reports/event/23309584\r\n\r\n`PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xF0\\x9F\\x98\\x83\\x0A\\x0A...' for column 'body' at row 1: INSERT INTO {pm_message} (subject, author, body, format, timestamp, has_tokens) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => Request for accommodation - Saturday 10th October [:db_insert_placeholder_1] => 71577 [:db_insert_placeholder_2] => Hi Richard I'm in Stratford upon Avon on business and just found the Stratford ale house. I looked it up on your blog and its one you have visited so I felt obliged to call in for a pint. The good news is they remember you well and there is approximately £80 behind the bar for you. The bad news is there are 25 more micropubs opened since you started out. The guys in the bar think you should carry on 😃 Mike [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1444791895 [:db_insert_placeholder_5] => 0 ) in _privatemsg_send() (line 1935 of /var/www/warmshowers.org/docroot/sites/all/modules/patched/privatemsg/privatemsg.module).`\r\n\r\nAnother example:\r\n`PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xF0\\x9F\\x98\\x8A. ...' for column 'body' at row 1: INSERT INTO {pm_message} (subject, author, body, format, timestamp, has_tokens) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => warm showers [:db_insert_placeholder_1] => 72645 [:db_insert_placeholder_2] => Hi we are an aussie couple on our way to port Macquarie and would like to make contact with you. We are staying night at Batemans Bay and would be at your place in 2 days, all being well😊. Cheers Gary n Marilyn. [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1444790421 [:db_insert_placeholder_5] => 0 ) in _privatemsg_send() (line 1935 of /var/www/warmshowers.org/docroot/sites/all/modules/patched/privatemsg/privatemsg.module).`"},"comment":{"url":"https://api.github.com/repos/warmshowers/Warmshowers.org/issues/comments/148126723","html_url":"https://github.com/warmshowers/Warmshowers.org/issues/881#issuecomment-148126723","issue_url":"https://api.github.com/repos/warmshowers/Warmshowers.org/issues/881","id":148126723,"user":{"login":"rfay","id":112444,"avatar_url":"https://avatars.githubusercontent.com/u/112444?v=3","gravatar_id":"","url":"https://api.github.com/users/rfay","html_url":"https://github.com/rfay","followers_url":"https://api.github.com/users/rfay/followers","following_url":"https://api.github.com/users/rfay/following{/other_user}","gists_url":"https://api.github.com/users/rfay/gists{/gist_id}","starred_url":"https://api.github.com/users/rfay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfay/subscriptions","organizations_url":"https://api.github.com/users/rfay/orgs","repos_url":"https://api.github.com/users/rfay/repos","events_url":"https://api.github.com/users/rfay/events{/privacy}","received_events_url":"https://api.github.com/users/rfay/received_events","type":"User","site_admin":false},"created_at":"2015-10-14T17:30:46Z","updated_at":"2015-10-14T17:30:46Z","body":"Actually, the full message that can cause the problem was\r\n\r\n`\r\nHi Richard\r\nI'm in Stratford upon Avon on business and just found the Stratford ale house. I looked it up on your blog and its one you have visited so I felt obliged to call in for a pint.\r\nThe good news is they remember you well and there is approximately £80 behind the bar for you. The bad news is there are 25 more micropubs opened since you started out. The guys in the bar think you should carry on 😃\r\n`\r\n\r\nAnd that message causes havoc when sending an email directly via privatemsg. So I think this should be worked around in a privatemsg hook, not in the mail handling."}}