View Issue Details

IDProjectCategoryView StatusLast Update
0002777OXID eShop (all versions)1.05. Userspublic2023-07-26 14:22
Status confirmedResolutionreopened 
Product Version4.10.4 / 5.3.4 
Target VersionFixed in Version 
Summary0002777: Newsletter - Users already subscribed for newsletter shouldn't be set to oxdboptin = 2 when they subscribe again
DescriptionWhen there is double-optin and a user subscribes for newsletter and confirms the following email the value oxnewssubscribed.oxdboptin is "1"

When user subscribes again oxdboptin will be reset to value "2". I think that shouldn't happen - value should stay "1" and user maybe should get a message that he is already subscribed.

Else I could unsubsribe several users of other shops by tiping e-mail adresses into newsletter-subscription field until they confirm the double-opt-in mail again.
Steps To Reproduce

- enter mailadress
- confirm double-opt-in mail
- check newsletter-flag in shopadmin (it is set now)
- reenter mailadress in frontend
- check newsletter-flag in shopadmin (it is gone)
TagsNo tags attached.
PHP VersionNot defined
Database VersionNot defined


related to 0006146 closedSven Brunk OXID eShop (all versions) Newsletter Checkbox in Checkout Progress doesn't show the actual Status of the newsletter subscription of guest users 
has duplicate 0007302 closedQA Flow theme Bug in OXID Newsletter Landingpage /index.php?cl=newsletter 
has duplicate 0007303 closed OXID eShop (all versions) Bug in OXID Newsletter Landingpage /index.php?cl=newsletter 



2017-06-12 11:06

reporter   ~0012113

Last edited: 2017-06-12 11:06

View 2 revisions

In this forum thread @Firefax complains that the issue wasn't resolved and can be reproduced in 4.10.4:

In reply, provides a possible resolution:

Please re-check. Thanks!


2017-06-12 18:25

reporter   ~0012115

Hi, i think this ticket has the same reason as / is relatet to

If you already have a sucessful double opt in registration, just don't change anything, when you register again.


2022-01-28 18:18

administrator   ~0013572

Last edited: 2022-01-28 18:18

View 2 revisions

Unfortunately, there is even more questionable behavior by resubscribing to the newsletter:
- OXUNSUBSCRIBED is set to current time.
- OXUNSUBSCRIBED is set to local time instead of UTC.
- OXSUBSCRIBED is not updated again.

This was originally reported in issue#7302, which was marked as duplicate:



2023-07-26 14:22

administrator   ~0015443

Still reproducible in 6.5.2 and 7.0.0
- mko