View Issue Details

IDProjectCategoryView StatusLast Update
0002777OXID eShop (all versions)1.05. Userspublic2024-01-26 07:33
ReporterBergfreunde Assigned To 
Status confirmedResolutionreopened 
Product Version4.10.4 / 5.3.4 
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 closedSvenBrunk 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 
has duplicate 0007452 closedQA OXID eShop (all versions) Newsletter should not be unsubscribed by guest order 
related to 0005657 confirmedSvenBrunk OXID eShop (all versions) oxUser should not be deleted if exist in database 



2017-06-12 11:06

reporter   ~0012113

Last edited: 2017-06-12 11:06

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

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