Error HM5032 "Incorrect String Value"
Posted: 2012-09-26 17:43
Recently upgraded to 5.3.3. System is running mostly fine, but email clients periodically stop showing new messages. The client must be closed and reopened to show new messages. The problem is occurring in Outlook and Thunderbird. Going through the logs I see the following line repeated about 12 times during the day, but can not find a way to fix it.
"ERROR" 1384 "2012-09-26 11:16:14.107" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:17:34.166" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:18:54.086" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:20:15.740" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:21:37.269" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:22:59.345" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:24:19.000" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:25:38.841" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:26:58.777" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:28:18.525" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:29:38.851" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:30:58.974" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:32:21.206" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:33:41.167" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:35:01.852" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:36:22.272" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:37:41.848" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty
Windows 2003, Xeon 1.8GHz, 4GB RAM, 100GB HD avail
"ERROR" 1384 "2012-09-26 11:16:14.107" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:17:34.166" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:18:54.086" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:20:15.740" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:21:37.269" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:22:59.345" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:24:19.000" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:25:38.841" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:26:58.777" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:28:18.525" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:29:38.851" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:30:58.974" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:32:21.206" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:33:41.167" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:35:01.852" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:36:22.272" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty "ERROR" 1384 "2012-09-26 11:37:41.848" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\x99 <...' for column 'metadata_cc' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (359, 2652, 8498400, '2012-04-19 15:27:00', 'someother user <someuser@notmydomain.com>', 'Re: Sales ticket #222212', '"user@mydomain.com" <user@mydomain.com>', 'Patty
Windows 2003, Xeon 1.8GHz, 4GB RAM, 100GB HD avail