Hi Shaun, Not so while back ago you helped me setting up a shop v6_nashop :) Maybe I can help you with this :)
I have been messing around with the newsletter subscription a while ago aswell. I believe the OXID System subscribes new registered user automatically into the oxnewssubscribed table as unsubscribed, the subscription date in this case means the date the user registered. Another thing I figured out was that if a non-existing user subscribes to a newsletter, he also gets a user created with the fields oxid, name, surname and mail address and other fields left empty (this user is not usable). Later when registering for a user and when using the same email address you used for the subscribing, these previously inserted values gets updated this also counts for the oxnewssubscribed table aswell. So the user won't get double emails and or can subcribe/unsubscribe himself/herself. Hope this helps :) Best regards, Yusuf 2012/9/12 Shaun Purvis <[email protected]> > Noticed some peculiar states in the database regarding newsletters > subscriptions. I'm new to newsletters so maybe I'm just missing something, > but here's the issue: > > Noticed several entries (users) in the oxnewssubscribed table with a > opt-in value of 0 (1=subscribed, 2=pre-subscribed, 0=unsubscribed) yet they > have a valid subscribe date, but no un-subscribe date. This seems like it > should be impossible, no? How did a user get into this table without ever > being subscribed? > > Maybe there's a bug that incorrectly sets new subscribers to a state of > 0. Took a quick look in the bug tracker but didn't see anything like this. > > > If anybody knows of this as a past/present issue, maybe I will change the > state of all these users to 1 before I start sending emails. Or is there a > logical explanation for these states? > > Cheers, > Shaun. > > _______________________________________________ > dev-general mailing list > [email protected] > http://dir.gmane.org/gmane.comp.php.oxid.general >
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
