Newsletter-Only Subscriptions for v1.3x

[barco57]

See I just needed to reach the end of my rope and read my own post a couple of times and the problem jumped out at me. I just used phpmyadmin and fixed the problem with that particular email address, which happened to be mine, and *poof* magic happens and newsletters are bein' sent.

[NotGoddess]

Let me check it out...

[NotGoddess]

See I just needed to reach the end of my rope and read my own post a couple of times and the problem jumped out at me. I just used phpmyadmin and fixed the problem with that particular email address, which happened to be mine, and *poof* magic happens and newsletters are bein' sent.

grin... often happens :)

Was it the quotes? or doubling? That's what jumped out at me when I saw it but I wanted to be sure before answering.

-Ng_

(btw...I've decided to finish up the revision and release tonight rather than delay until monday. It'll be up soon).

[barco57]

what I don't know is how the email address got screwed up in the first place. None of the other email addresses in the list have any problems.

It was the doubling.

[barco57]

I have another question about the database

when browsing zen_subscribers I noted that some of the email address under customer id have a number, but when you look at the subscribe date it shows 0000-00-00. The other email addresses have null for the customer id and have a filled out subscriber date. Do I assume correctly that the customers with an id and no date signed up for the newsletter when creating an account and the others signed up for the newsletter only? and is this the correct behavior for this mod?

[NotGoddess]

when browsing zen_subscribers I noted that some of the email address under customer id have a number, but when you look at the subscribe date it shows 0000-00-00. The other email addresses have null for the customer id and have a filled out subscriber date. Do I assume correctly that the customers with an id and no date signed up for the newsletter when creating an account and the others signed up for the newsletter only? and is this the correct behavior for this mod?

Yes, I don't transfer over the customer account creation date or when the subscription was made/changed (tho I easily could if you'd like that) for customers.

News-only subscribers have a subscribed_date, but no customers_id (as they are not a customer). When/if they become one, then it gets merged and updated.

-Ng_

[barco57]

I don't see a reason at this time to make anychanges to this behavior. I just wanted to check and make sure I understood what was going on. Every little bit of information I gather on zen-cart, its mods and the interaction with the database helps me sort out the little problems as they arise without having to have a panic attack everytime something doesn't work out quite right. Thanks.

[NotGoddess]

This is mainly a BugFix release, but it also enhances the subscription manager page in admin.

It fixes the known flaws in 2.0.2 and fixes an inadvertant error I introduced with the 2.0.3 patch file.

No database upgrade is needed-you can just overwrite the files. To overwrite just the changed files, see the changelog for a list.

Submitted to the downloads section, also available on my site: http://www.notgoddess.com/scripts/newsletter-subscribe

As ever, report issues and I'll address them promptly. I will be afk July 2 and part of the third.

-Ng_

[kookiewookie]

great! i updated all files. All seems working fine now except one strange thing


When i go to Subscription Manager and sent a email to a newsletter only subscr. it sents the email fine.
BUT when i do select: Newsletter only Subscr. from the newslettermanager i does not send the email for there is a error: No recipient addresses found in header .

Sending to ALL is fine as the others.. except this one does not seem to work correctly.

What should i double check?? some one a solution maybe?

[audradh]

Okay, you say you aren't too sql-savvy, but can you use phpMyAdmin? If so, this is the easiest way to fix this. ...

Just wanted to say thanks Ng! I manually deleted the dups by browsing the table in phpmyadmin as we discussed via pm. All is happy

Best,
Audra