Newsletter-Only Subscriptions for v1.3x

[MVIP]

Hi there,

I think installed the mod okay. I tested it by sending the confirmation to my email.

However, when I was going to the "USAGE INSTRUCTIONS" in the Read Me file, I didn't seem to get through to this point:

Under 'Tools -> Send Email' you'll see new customer groups:
Email Test Group - Customers
Email Test Group - Newsletter-only subscribers
These two fields pull the correct emails you designated in your
Newsletter Test Group Email settings.

Newsletter Subscribers
Customer Account Newsletter Subscribers
Newsletter-only Subscribers

I don't see new customer groups or Newsletter Subscribers under 'Tools -> Send Email'.

Rather, under Tools ->Send Email, it says:
"Send Email To Customers Text Editor

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'locate'
in:
[SELECT s.email_address as customers_email_address FROM subscribers as s LEFT JOIN configuration as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

What does this mean? Can someone please help? Thank you.

[viper75]

Hi!
I've installed this mod. But in the mail to confirm the subscription missing the link!

Help me please!

[badger6021]

And....
For those following this thread the answer was????

I also have this problem, has anyone found a solution yet?



I will be your friend for life if you can help me because I thought I had looked in pretty much every PHP file and can't work out why this is happaning

http://www.thephonebox.co.uk/

[badger6021]

I've installed the mod and it's worked perfectly. However, it's added the word "subscribe" to the site title and at the bottom of the main content area. I removed all the files however the subscribe: keep appearing

How do I get rid of that?! (see site here: http://www.ironsightsfirearms.com

This problem I mean

[PublicM]

http://www.zen-cart.com/forum/images/smilies/clap.gif
I found out why the confirmation link wasn't showing up in the customer confirmation emails. It is because I forgot to upload email/email_template_newsletter_subscription.html and the email/email_template_newsletter_unsubscription.html. If other similar things are not working for you be sure to double check that you have uploaded all of the files to the correct folders.

[robbie269]

Has anyone tried this addon in Zen Cart Ver 1.5 yet?

[joepixel]

I too would like to know if anyone is running this successfully on V1.5. Sounds like there are quite a few issues with it running on the older versions. Anyone tried it on V 1.5 yet?

[picaflor-azul]

Hello ;-)

I have a version of the newsletter subscribe module working on a version 1.5. cart. The module is showing as a configuration menu item instead of a customers menu item. I can't upload the zip here because it is too large. Is there any way that I can post the code here somewhere so that someone can take a look at it for me? I am not a php programmer ;-)

Please try only in a test environment.

The code is here:

Upgraded Newsletter Subscribe

Thanks,

Anne

[picaflor-azul]

Ok, I've worked out how to add the pages into the correct place in the admin menus.

Now, if someone could just take a look at the zip and let me know if there are any security related or other problems.

Thanks,

Anne

[DrByte]

You're probably far better off integrating something like the Mailchimp sidebox and having your customers signup for your newsletter that way. Then periodically export your newsletter subscribers from your store using the Email Address Exporter, and load them into your Mailchimp account.

I make that recommendation because the Mailchimp addon involves only a small handful of files. But this archaic old "Newsletter Subscribe" addon alters a zillion core files and makes upgrading a NIGHTMARE, plus results in tons of confusing support requests when someone decides to uninstall it because uninstalling isn't clean or easy.