Newsletter-Only Subscriptions for v1.3x

[nagelkruid]

Suddenly, this sidebox isn't working.

The errors I'm seeing look like the defines aren't working. So, for example, the sidebox header says "BOX_HEADING_SUBSCRIBE".
Tim

Hello Tim,
did you check the includes/language/english (or perhaps your_language) directory?
you should have subscribe.php in there with the define in it for this header

Jeroen

[jasmel]

Had a hard time finding this thread. Maybe we can change the title to "Newsletter Subscribe" since this mod replaced the previous one.

The question I have is how do I change the admin page to display the correct number of subscribers?

Newsletter subscribers: 1,234 (this number no longer increases)

I think this has something to do with the new db update for the newsletter only subscribers.

Thanks!

[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?

[ftdc]

Using Zen Cart v.1.38a i think 4weeks in to modifying it i have tryed to install this mod and time and time again it doesn't work fore me.
After I place all the files on my local test server it turns admin blank anyone had this problem or have a solution