6.0.0-beta1
9/24/25

[#2438] [PATCH] Fix for amavisd-sql constraint problem
Summary [PATCH] Fix for amavisd-sql constraint problem
Queue Sam
Queue Version HEAD
Type Bug
State Resolved
Priority 2. Medium
Owners Horde Developers (at) , max (at)
Requester josh (at) endries (dot) org
Created 08/14/2005 (7346 days ago)
Due
Updated 09/09/2005 (7320 days ago)
Assigned 08/15/2005 (7345 days ago)
Resolved 09/09/2005 (7320 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
09/09/2005 03:33:00 AM Chuck Hagenbuch Comment #2
State ⇒ Resolved
Reply to this comment
Looks alright to me. Committed, thanks.
08/15/2005 10:32:50 PM Jan Schneider Assigned to max
Assigned to Horde DevelopersHorde Developers
State ⇒ Assigned
 
08/14/2005 01:59:40 PM josh (at) endries (dot) org Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ [PATCH] Fix for amavisd-sql constraint problem
Queue ⇒ Sam
New Attachment: sam-diff Download
Reply to this comment
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

Saved Queries