[OFBIZ-9361] Newsletter can be subscribed with same email address multiple times

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: Release Branch 16.11, Trunk, Upcoming Branch
• Fix Version/s: 18.12.06, 22.01.01
• Component/s: ecommerce
• Assignee: Giulio Speri
• Reporter: Aditya Sharma
• Created: 13/May/17 08:11
• Updated: 27/Nov/22 17:24
• Resolved: 27/Nov/22 17:24

Description

Steps to regenerate:
1. Go to Ecommerce component (https://demo-trunk.ofbiz.apache.org/ecommerce/control/main)
2. In Sign Up For Contact List section from the left panel, select contactList for Newsletter.
3. Fill out the email address and Click on Subscribe button.
Try subscribing with the same email address for the newsletter. Email is again added to Newsletter subscription list even if it is already subscribed for it. Email address with pending and accepted status can be again added to the list with pending status.
Multiple entries are created in ContactListParty entity for the same preferredContactMechId.
At Service level, it should check if already an entry in pending or accepted status exists.

Issue Links

• fixes: OFBIZ-12705 deleteContactListParty service breaks FK constraint on ContactListPartyStatus