[Dbmail-dev] [DBMail 0000772]: Database Error - value too long for type character varying(100) when insterting into dbmail_replycache
The following issue has been SUBMITTED. == http://www.dbmail.org/mantis/view.php?id=772 == Reported By:yavo Assigned To: == Project:DBMail Issue ID: 772 Category: Database layer Reproducibility:have not tried Severity: minor Priority: normal Status: new target: == Date Submitted: 25-Feb-09 15:34 CET Last Modified: 25-Feb-09 15:34 CET == Summary:Database Error - value too long for type character varying(100) when insterting into dbmail_replycache Description: I get the above message in my postgres logs when an auto reply is sent. ERROR: value too long for type character varying(100) STATEMENT: INSERT INTO dbmail_replycache (to_addr, from_addr, handle, lastseen) VALUES('em...@example.com','em...@example.com','Text longer than 100 characters', CURRENT_TIMESTAMP) == Issue History Date ModifiedUsername FieldChange == 25-Feb-09 15:34 yavo New Issue == ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
[Dbmail-dev] [DBMail 0000772]: Database Error - value too long for type character varying(100) when insterting into dbmail_replycache
A NOTE has been added to this issue. == http://www.dbmail.org/mantis/view.php?id=772 == Reported By:yavo Assigned To: == Project:DBMail Issue ID: 772 Category: Database layer Reproducibility:have not tried Severity: minor Priority: normal Status: new target: == Date Submitted: 25-Feb-09 15:34 CET Last Modified: 25-Feb-09 15:40 CET == Summary:Database Error - value too long for type character varying(100) when insterting into dbmail_replycache Description: I get the above message in my postgres logs when an auto reply is sent. ERROR: value too long for type character varying(100) STATEMENT: INSERT INTO dbmail_replycache (to_addr, from_addr, handle, lastseen) VALUES('em...@example.com','em...@example.com','Text longer than 100 characters', CURRENT_TIMESTAMP) == -- (0002796) yavo (reporter) - 25-Feb-09 15:40 http://www.dbmail.org/mantis/view.php?id=772#c2796 -- After inspecting my database, this seems to have been introduced by upgrading to 2.2.11 Before a random hash was being placed in the handle, now it appears that the email body is placed there. Issue History Date ModifiedUsername FieldChange == 25-Feb-09 15:34 yavo New Issue 25-Feb-09 15:40 yavo Note Added: 0002796 == ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
[Dbmail-dev] [DBMail 0000772]: Database Error - value too long for type character varying(100) when insterting into dbmail_replycache
A NOTE has been added to this issue. == http://www.dbmail.org/mantis/view.php?id=772 == Reported By:yavo Assigned To:paul == Project:DBMail Issue ID: 772 Category: Database layer Reproducibility:have not tried Severity: minor Priority: normal Status: feedback target: == Date Submitted: 25-Feb-09 15:34 CET Last Modified: 31-Jul-09 00:51 CEST == Summary:Database Error - value too long for type character varying(100) when insterting into dbmail_replycache Description: I get the above message in my postgres logs when an auto reply is sent. ERROR: value too long for type character varying(100) STATEMENT: INSERT INTO dbmail_replycache (to_addr, from_addr, handle, lastseen) VALUES('em...@example.com','em...@example.com','Text longer than 100 characters', CURRENT_TIMESTAMP) == -- (0002796) yavo (reporter) - 25-Feb-09 15:40 http://www.dbmail.org/mantis/view.php?id=772#c2796 -- After inspecting my database, this seems to have been introduced by upgrading to 2.2.11 Before a random hash was being placed in the handle, now it appears that the email body is placed there. -- (0002811) paul (administrator) - 08-Mar-09 17:31 http://www.dbmail.org/mantis/view.php?id=772#c2811 -- The 'hash' is not random, but a md5 hash of the combined messagebody+subject. It could also be determined by the sieve script. If you can please post a level=5 trace of a delivery that leads to the mentioned failure, and plz include the sieve script involved. -- (0002889) netvulture (developer) - 31-Jul-09 00:51 http://www.dbmail.org/mantis/view.php?id=772#c2889 -- I have a patch for 2.3.x that addresses this. Will need to backport to 2.2.x Issue History Date ModifiedUsername FieldChange == 25-Feb-09 15:34 yavo New Issue 25-Feb-09 15:40 yavo Note Added: 0002796 08-Mar-09 17:31 paul Note Added: 0002811 08-Mar-09 17:31 paul Assigned To => paul 08-Mar-09 17:31 paul Status new => feedback 31-Jul-09 00:51 netvulture Issue Monitored: netvulture 31-Jul-09 00:51 netvulture Note Added: 0002889 == ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev