Hello Harald
I tried to change the data type for envelope from text to longtext and the
error with the insert obviously disappeared.
Now I'm wondering if such change can give problem to dbmail itself ... Maybe
with any struct that allocates a fixed length for the envelope... ?
Sent from my iPad
> On 22/lug/2014, at 12:35, Reindl Harald <h.rei...@thelounge.net> wrote:
>
>
>
> Am 22.07.2014 12:29, schrieb Andrea Brancatelli:
>> Hello, can anybody help me with this output from dbmail-util -ay ?
>>
>> Dbmail is 3.1.13
>
> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10]
> Error:[message]
> dbmail_message_cache_envelope(+1919): SQLException: Data too long for column
> 'envelope' at row 1
>
> is because a broken message, i have that also from time to time
> and would like to truncate that cache data or at least have
> the messageid without debug logging in the errormsg to kill
> the related mail - IMHO a cosmetic bug
>
> "dbmail_messageblks" is for sure a bug because 3.1.x should be
> happy after the migration from 2.x that this table don't exist
> because it's no longer needed
>
>> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10]
>> Error:[message]
>> dbmail_message_cache_envelope(+1919): SQLException: Data too long for column
>> 'envelope' at row 1
>> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10]
>> Error:[message]
>> dbmail_message_cache_envelope(+1921): insert envelope failed [("Wed, 25 Jun
>> 2014 11:20:40 +0200" "Le notizie dal
>> mondo della scuola" (("Scuola" NIL "scuola” “xxxx.xxx")) (("Scuola" NIL
>> "scuola" "xxxx.xxx")) (("Scuola" NIL
>> "scuola" "xxxx.xxx")) NIL ((“Xxxxx Xxxxx" NIL “xxxxx" "xxxx.xxx")("xxxx.xxx"
>> NIL "xxxxx"
>> "xxxx.xxx")(“xx...@xxxxx.xxx <mailto:xx...@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xx...@xxxxx.xxx
>> <mailto:xx...@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xx...@xxxxx.xxx
>> <mailto:xx...@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xx...@xxxxx.xxx <mailto:xx...@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xx...@xxxxx.xxx
>> <mailto:xx...@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xx...@xxxxx.xxx
>> <mailto:xx...@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xx...@xxxxx.xxx <mailto:xx...@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xx...@xxxxx.xxx
>> <mailto:xx...@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xx...@xxxxx.xxx
>> <mailto:xx...@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xx...@xxxxx.xxx <mailto:xx...@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xx...@xxxxx.xxx
>> <mailto:xx...@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("zanin_g@camera
>> ....Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10]
>> Error:[db] db_query(+370): SQLException:
>> Table 'dbmail.dbmail_messageblks' doesn't exist
>> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db]
>> db_query(+371): failed query [SELECT
>> b.messageblk, b.is <http://b.is>_header, DATE_FORMAT(p.internal_date,
>> GET_FORMAT(DATETIME,'ISO')) FROM
>> dbmail_messageblks b JOIN dbmail_physmessage p ON b.physmessage_id=p.id
>> WHERE b.physmessage_id = 8201117 ORDER BY
>> b.messageblk_idnr]
>>
>> I blanked out the mail addresses bit they are all valid.
>> I’m worried both by the data to long and by the dbmail_messageblks doesn’t
>> exist… ?
>
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
