If you are getting this error:
An internal error occurred while sending this message. This message will be retried automatically.
Mysql2::Error: Data too long for column 'description' at row 2
maybe you are getting these messages from spamd or spamassassin:
URIBL_DBL_BLOCKED_OPENDNS | ADMINISTRATOR NOTICE: The query to dbl.spamhaus.org was blocked due to usage of an open resolver. See https://www.spamhaus.org/returnc/pub/ [URI: fonts.googleapis.com] [URI: email.brio.co.in] [URI: briotech.com] [URI: bf06x.hubspotemail.net]They easily exceed 255 character limit on table spam_checks.description.
It makes sense to disable calls to spamhaus entirely - they are automatically blocked, and there is no sane reason to switch away from an open resolver. (As if this is not complicated enough, spamhaus wants me to own a resolver? I thought spamhause would prevent spam, but all they do is prevent usage.)
I fixed this error by modifying the mysql db that postal uses:
ALTER TABLE spam_checks
-> MODIFY description VARCHAR(500);Voila! Problem solved.
.
