[Tickets #2438] NEW: [PATCH] Fix for amavisd-sql constraint problem

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=2438
-----------------------------------------------------------------------
 Ticket             | 2438
 Created By         | josh at endries.org
 Summary            | [PATCH] Fix for amavisd-sql constraint problem
 Queue              | Sam
 Version            | HEAD
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
+New Attachment     | sam-diff
-----------------------------------------------------------------------


josh at endries.org (2005-08-14 06:59) wrote:

Hello,

I'm not a PHP/PEAR/Horde expert, but attached is a patch I hacked up to fix
a constraint problem I was having with SAM. The problem is that, when a user
submits a whitelist, the existence of sender addresses is only checked for
addresses in the existing wblist and not for new additions. If one user adds
an address, and someone else tries to add that same address, it breaks the
unique index in the DB. This patch simply checks for the existence of new
addresses. If found, it uses the current ID, otherwise it inserts as usual.

Josh