Newsletter-Only Subscriptions for v1.3x

[dgarrett20]

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?

[dgarrett20]

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.

[senortim]

Hi Jeroen,

Oh, wow. So I just realized this error is not just the sidebox but it's hitting my registration as well. (Maybe that's a clue about what's wrong?)

Something really seems wrong with my defines. The "newsletter_subscribe_filesnames.php" is in /includes/extra_datafiles/ -- and he "subscribe.php" is in /includes/languages/english/my_template/.

I'm getting an error now on the define "TABLE_SUBSCRIBERS".

Thanks for your help!
Tim

[senortim]

My store is not working and I don't have a clue why this part of the system is even being affected -- other than something being wrong somewhere in the defines list. Can anyone suggest how I can debug that?

Here is the error I'm getting:

1146 Table 'zenstore.TABLE_SUBSCRIBERS' doesn't exist
in:
[select count(*) as total from TABLE_SUBSCRIBERS where email_address = '[email protected]' ]

[nagelkruid]

Here is the error I'm getting:

1146 Table 'zenstore.TABLE_SUBSCRIBERS' doesn't exist
in:
[select count(*) as total from TABLE_SUBSCRIBERS where email_address = '[email protected]' ]

When do you get that error?

[senortim]

I get it when registering a new user (create_account), recovering a password (password_forgotten -- btw, this one does reset the password, but the email never arrives), when I submit a change to subscriptions (account_newsletters), and on the final step of placing an order (checkout_process).

It occurs whenever using the TABLE_SUBSCRIBER define value -- which apparently is not getting defined.

Note, too, that my shipping and billing addresses are not automatically filling in. No clear defines here -- I'm seeing nothing, rather than values in all caps -- but this used to work as well.

Thanks for any ideas. I'm 95% sure this isn't caused by the newsletter subscribe MOD, but help from you all is appreciated.

[nagelkruid]

Thanks for any ideas. I'm 95% sure this isn't caused by the newsletter subscribe MOD, but help from you all is appreciated.

Tell me what happens if you run this command in the sql patchtool which is available under tools:

UPDATE subscribers SET email_format = 'TEXT' WHERE email_address = '[email protected]';

do you get a green line that says succesfully processed or do you get an error?

[nagelkruid]

Hi Jeroen,

Oh, wow. So I just realized this error is not just the sidebox but it's hitting my registration as well. (Maybe that's a clue about what's wrong?)

Something really seems wrong with my defines. The "newsletter_subscribe_filesnames.php" is in /includes/extra_datafiles/ -- and he "subscribe.php" is in /includes/languages/english/my_template/.

I'm getting an error now on the define "TABLE_SUBSCRIBERS".

Thanks for your help!
Tim

As the SQL query catched in the admin, i am thinking it has to be somewhere in the shop-side of things.
The only place i would suspect this to go wrong is indeed in newsletter_subscribe_filenames.php.
You allready said it's there, if it isn't corrupt then i wouldn't know why it would throw that error.
Maybe you should try re-uploading that file.
If that doesn't solve anything then i don't think the error is in subscribe mod, but i would probably remove the mod anyway and see if the shop would start running without an error again, or if you then possibly get a different error message.

[senortim]

Thanks, nagelkruid. I'll give that a try. It might take a while to see; I've got the site running in a crippled mode that required some modifications to code. (Would be great!! if ZC would let us turn off MODs in a control panel!!) :-)

[nagelkruid]

Thanks, nagelkruid. I'll give that a try. It might take a while to see; I've got the site running in a crippled mode that required some modifications to code. (Would be great!! if ZC would let us turn off MODs in a control panel!!) :-)

Heh, they can write a control panel, but it is still up to the people who write these mods to have a proper disable/enable function.

But i agree, especially for code added to core-files and autoloaders, would be great to have an if(this_mod_enabled) option in there....mmm, sounds like a perfect world...