Re: Data too long for column 'envelope'

It's a text field - that's why i asked to bounce at lmtp level :-) 


-------- Ursprüngliche Nachricht --------
Von: Paul J Stevens <[email protected]>
Gesendet: 28. Dezember 2014 12:26:25 MEZ
An: DBMail mailinglist <[email protected]>
Betreff: Re: [Dbmail] Data too long for column 'envelope'

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Harry,

did you change that column? It should be a TEXT column which means
it's width is 64KB.

If you didn't, it might be an idea to reject messages whose envelope
exceeds a certain length.

On 28-11-14 22:38, Reindl Harald wrote:
> can this please get fixed by just truncate the envelope data to
> the filed length or bounce that damned messages at LMTP level? :-(
> 
> Nov 28 22:35:34 mail dbmail/maintenance[1862]: Error:[message] 
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:34 mail
> dbmail/maintenance[1862]: Error:[message] 
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:35 mail
> dbmail/maintenance[1875]: Error:[message] 
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:35 mail
> dbmail/maintenance[1875]: Error:[message] 
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:37 mail
> dbmail/maintenance[1879]: Error:[message] 
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:37 mail
> dbmail/maintenance[1879]: Error:[message] 
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:41 mail
> dbmail/maintenance[1896]: Error:[message] 
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:41 mail
> dbmail/maintenance[1896]: Error:[message] 
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:43 mail
> dbmail/maintenance[1899]: Error:[message] 
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:43 mail
> dbmail/maintenance[1899]: Error:[message] 
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:44 mail
> dbmail/maintenance[1902]: Error:[message] 
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:44 mail
> dbmail/maintenance[1902]: Error:[message] 
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline -
> 
> 
> 
> _______________________________________________ DBmail mailing
> list [email protected] 
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> 

- -- 
________________________________________________________________
Paul J Stevens       pjstevns @ gmail, twitter, github, linkedin
           www.nfg.nl/[email protected]/+31.85.877.99.97
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlSf6OEACgkQ8iITvBH4zTFcLgCdEW47vaj7nktEhWQxXgTPHlye
cI8An3mg0cLukBczhc52roqaSxM9ndVa
=Sq6j
-----END PGP SIGNATURE-----
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


--

Reindl Harald (mobile)
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / CISO / Software-Development
+43 (676) 40 221 40
http://www.thelounge.net
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail