My server is kind of stuck in a retrial loop for some older messages.
I use: hMailServer 5.6.7-B2425 (db version 5601), MySql Server 5.7, Windows 10 - x64
While the messages are present in table hm_messages (and in .eml data files) but when it tries to insert them in hm_message_metadata it gets error :
(I have got ~200MB of hMailServer logs with this message(s), since 2017-05-30)
Code: Select all
"2018-04-27 23:52:11.669" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x8C\xA1Ce...' 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 (1, 1, 449, '2017-07-21 10:19:48', 'Domino''s Pizza <office@dominos-pizza.ro>', '"ERROR" 4160
"2018-04-27 23:49:04.582" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x93\x88 \xC3...' 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 (1, 1, 501, '2017-08-28 07:16:44', 'Domino''s Pizza <office@dominos-pizza.ro>', '"ERROR" 4160
"2018-04-27 23:42:50.395" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x8E\x89 \xC3...' 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 (1, 1, 540, '2017-10-02 09:08:51', 'Domino''s Pizza <office@dominos-pizza.ro>', '"ERROR" 4160
"2018-04-27 23:14:46.571" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x8E\x81 D...' 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 (1, 1, 515, '2017-09-04 07:58:41', 'Domino''s Pizza <office@dominos-pizza.ro>', '"ERROR" 4160
Etc,
Thx !
PS: in the end, meaning today (2018-04-28) i have deleted the messages manually from DB/data files