Quote Originally Posted by dgarrett20 View Post
I have ZenCart 1.3.8 and installed Newletter Subscribe v 2.1.1.

Everything is working fine, but I had previously added a discount to newsletter subscribers [Newsletter Discount Mod] http://www.zen-cart.com/index.php?ma...roducts_id=986

If they checked the newsletter box when signing up they get 5% off of their orders.

So testing this new subscribe without an account mod, I signed up for the newsletter. I confirmed it in my email and then went to signup and checkout and the discount doesn't work.

In the admin section it changed me from Newsletter-Only Subscriber to Customer and I am still on the newsletter, but not able to get the discount. If I goto the account and check the box for the newsletter I get the following error:

1062 Duplicate entry 'davidgarrettjr######################' for key 2
in:
[INSERT INTO zen_subscribers (customers_id, email_address, email_format) VALUES ('314', 'davidgarrettjr######################', 'TEXT')]

However, if I sign up after being subscribed to the newsletter only and I check the box at the bottom then everything is fine.

Question is: Is there a way to let a newsletter subscriber sign up for an account to where the box is already checked and/or it incorporates the discount?

I set it up now to keep the box automatically checked during signup and that seems to work, but I'd rather not have to do that and to have the box checked already only for those that have signed up for the newsletter before they sign up for an account.

If anyone can offer a fix that works, I'll send you a free knife from my store. www.knivesandmore.biz

Feel free to sign up and check out the error.