Message kill MailWatch SQL Loggin

[L.P.H. van Belle]

hai, 
 
You can try the following,
Make a backup, test your backup. 
Now try the following. 
 
set your mysql column's charset to utf8mb4 and Collation to utf8mb4_general_ci
set your connection string of charset to utf8mb4 like charset=utf8mb4
 
If there are emoije in the subject, then above might fix it. 
 
 
Greetz, 
 
Louis
 
 

Van: MailScanner [mailto:mailscanner-bounces+belle=bazuin.nl at lists.mailscanner.info] Namens DobriL Dobrilov
Verzonden: woensdag 8 augustus 2018 17:40
Aan: 'MailScanner Discussion'
Onderwerp: Message kill MailWatch SQL Loggin




I just saw there are no any processed emails for last 2 hours in MailWatch panel. In same there received messages emails and on each received I can see usual MailScanner[9303]: MailWatch: Logging message 804C46217E.A23FB to SQL…

 

Then I find this in the logs, after no more messages in Database.

 

Aug  8 16:32:08 mail MailScanner[5960]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging, it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st execute failed: Incorrect string value: '\xF0\x9F\x92\xB2\xF0\x9F...' for column 'subject' at row 1 at /usr/share/MailScanner/perl/custom/MailWatch.pm line 221, <CLIENT> line 7931.

 

MailScanner restart and it’s working again , but somehow the some message kill it.

 

 

Dobril Dobrilov

IT Manager

dobril at stanga.net



43, Cherni Vrah Blvd. | 1407 Sofia - Bulgaria
Phone: +359 2 81 960 69 Fax: +359 2 81 960 70
Mobile: +359 878 749 387

 


	
We shape Digital www.stanga.net


	
We re-invent Video www.bsbvision.com


	
We build Apps www.shanga.co


	
We support Start-Ups www.mysbar.net



 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180810/9ccb5495/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3762 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180810/9ccb5495/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1151 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180810/9ccb5495/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 853 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180810/9ccb5495/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 1286 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180810/9ccb5495/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 930 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180810/9ccb5495/attachment-0003.jpg>