View Issue Details

IDProjectCategoryView StatusLast Update
0007303OXID eShop (all versions)4.01. Database handlingpublic2022-01-31 10:45
ReporterYazan_Rashwani Assigned To 
Status closedResolutionopen 
Product Version6.3.1 
Summary0007303: Bug in OXID Newsletter Landingpage /index.php?cl=newsletter
DescriptionHello everyone,
by calling the URL /index.php?cl=newsletter I'm facing a problem, when a customer already subscribed the newsletter and resubscribes the newsletter:
- In the oxnewssubscribed table in DB, the OXDBOPTIN field is set to 2 (email not confirmed) even when the subscriber has confirmed the email.
- The field OXUNSUBSCRIBED for timestamps is set to 2 again.
- The OXUNSUBSCRIBED field will not set to UTC timezone, but local timezone.
- When a customer unsubscribe and then later subscribe the newsletter, the field OXSUBSCRIBED will not reset
I would like to ask for a solution for these issues or for explanations.
Best regards
TagsNewsletter, resubscribe, subscribed
PHP Version7.4
Database VersionOther


duplicate of 0002777 confirmedHR Newsletter - Users already subscribed for newsletter shouldn't be set to oxdboptin = 2 when they subscribe again 


There are no notes attached to this issue.