Well reporting in, I adjusted MySQL my.ini file to adjust the collation to utf8mb4_general_ci to make it the default character set, changed the hmailserver database default collation to utf8mb4_general_ci, changed the hm_message_metadada table and the metadata_subject to utf8mb4_general_ci.
Restarted MySQL, and hmailserver.
Disabled message indexing, and cleared, saved, and enabled and saved. 53,000 messages in... and I'm hit with "HM5032" ... Well now I'm getting a different error.
What's more interesting, is even hmailserver, upon hitting these errors, cannot even log correctly, and the log entry line is truncated and doesn't contain a <CR> or <LF> at the end.. and the next error just gets added... I ended up with this on one line
Code: Select all
"ERROR" 3156 "2014-08-28 19:08:50.546" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC G... ' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_fro m, metadata_subject, metadata_to, metadata_cc) VALUES (215, 332, 191497, '2014-08-22 15:20:26', '"Salary.com" <no-reply@jobs.salary.com>', '"ERROR" 4056 "2014-08-28 19:13:32.792" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 192381, '2014-08-25 13:26:45', '"Salary.com" <no-reply@jobs.salary.com>', ' "ERROR" 536 "2014-08-28 19:18:12.534" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 192381, '2014-08-25 13:26:45', '"Salary.com" <no-reply@jobs.salary.com>', ' "ERROR" 2956 "2014-08-28 19:22:38.647" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '"ERROR" 2692 "2014-08-28 19:23:38.403" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', ' "ERROR" 3280 "2014-08-28 19:24:00.214" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', ' "ERROR" 3540 "2014-08-28 19:24:11.200" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '"ERROR" 3648 "2014-08-28 19:24:21.275" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '"ERROR" 3400 "2014-08-28 19:24:31.449" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '"ERROR" 2996 "2014-08-28 19:24:47.352" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', ' "ERROR" 2676 "2014-08-28 19:25:13.700" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', '
Beautiful isn't it?
Fixed:
Code: Select all
"ERROR" 3156 "2014-08-28 19:08:50.546" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC G... ' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_fro m, metadata_subject, metadata_to, metadata_cc) VALUES (215, 332, 191497, '2014-08-22 15:20:26', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 4056 "2014-08-28 19:13:32.792" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 192381, '2014-08-25 13:26:45', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 536 "2014-08-28 19:18:12.534" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 192381, '2014-08-25 13:26:45', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 2956 "2014-08-28 19:22:38.647" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 2692 "2014-08-28 19:23:38.403" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 3280 "2014-08-28 19:24:00.214" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 3540 "2014-08-28 19:24:11.200" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 3648 "2014-08-28 19:24:21.275" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 3400 "2014-08-28 19:24:31.449" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC S...' for column 'metadata_subject' 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 (215, 332, 191943, '2014-08-23 14:58:39', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 2996 "2014-08-28 19:24:47.352" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', '
"ERROR" 2676 "2014-08-28 19:25:13.700" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x92\xBC M...' for column 'metadata_subject' 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 (215, 332, 191226, '2014-08-21 14:31:57', '"Salary.com" <no-reply@jobs.salary.com>', '
I realize salary.com look fairly suspicious, however at this point in time, it's the only active offender, but there are other's out there causing these errors.
Thanks Soren for your help, and this was most certainly worth a shot ... and I was hopeful, but alas the solution eludes me still.
If there's something else I can do to aid in getting to the bottom of this, lemme know!
-DieselDon
When life hands you lemons, make lemonade; when life hands you melons, you're dyslexic.