Newsletter-Only Subscriptions for v1.3x

davewest:

edit includes/templates/YOUR_TEMPLATE/templates/tpl_unsubscribe_default.php

add a background color to the style tag...
$content .= zen_draw_input_field('addr', $addr, 'style="width:20em; background-color:#FFF;"');

Great! This works, what would I be without all you top zenners out there!

Thank you for the input!

Can I ask a question can someone please tell me how to change the "newsletter" button at the top to a button that matches my site. I can not find it anywhere for the life of me. My eye's are officially crossed. Can someone please help me.

Hi,

I use zen cart 1.39h and installed this great module. Everything works exept when a former newsletter-only subscriber decided to create an account. Then the next message appears on the frontend:

1062 Duplicate entry '[email protected]' for key 'email_address'
in:
[INSERT INTO subscribers (customers_id, email_address, email_format, confirmed, subscribed_date) VALUES ( 12, '[email protected]', 'HTML', '1', now())]

In the admin the customer appears in the customerslist.

What went wrong? :dontgetit

Lieke

I just installed newsletter subscribe/unsubscribe 2.2.2 in Zen Cart v1.3.9h and everything seemed to go fine but when i clicked on: Tools/Send Emails I got this error message:

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.

I'm still a novice at this so can anyone explain where I went wrong?

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

lweldon:

I just installed newsletter subscribe/unsubscribe 2.2.2 in Zen Cart v1.3.9h and everything seemed to go fine but when i clicked on: Tools/Send Emails I got this error message:

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.

I'm still a novice at this so can anyone explain where I went wrong?

gettting the same error, I tried changing the collation in the phpmyadmin and the error is showing???????????

stevefriedman71:

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

gettting the same error, I tried changing the collation in the phpmyadmin and the error is showing???????????

i dont know php that well sooo...

On this page, I'd like to remove the HTML and TEXT-ONLY radio buttons...

Please tell me how to do this, thanks!

p.s. I want it to automatically select html.

Figured it out. :cool:

Hi,

I've just installed this contribution. Everything is working fine, expect my 'send email' function under 'tools' is not functioning.

It says: 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 znc_subscribers as s LEFT JOIN znc_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.

Which part of the settings have i not set?
Appreciated if someone could me on this.

I've attached a pic for reference as well.

Gotta preface, I'm a noob, but:

This MOD is FREAKING BRILLIANT for sure! I am so happy to have found this one as it is going to make my life easier in the short run, and I think give customers a very prudent choice about whether or not to give us their full info, but to still be involved with the store.

THANK YOU x 100! And if I may buy you (and the other developers) a drink next time you are in Indy : )

Now, my only question: As bizarre as it sounds, is there an easy way to offer un-subscription, other than directing folks to the unsubscribe page / link (which isn't by default a part of the sidebox, but is easy enough to link to). I just want to make people who do subscribe from the side box or as a result of an email link, to feel that visually it is so easy to unsubscribe that subsribing is a no brainer. Perhaps an integrated page where entering the email and clicking a button in the sidebox or page which says 'unsubscribe' - right next to the subscribe button would effectively get them the reverse of a subscription.

That's a long way to say where is the unsubscribe functionality I guess. Any thoughts are appreciated, I can certainly work with it as is -- GREAT MOD.

JJ

cpoet:

Hi,

I've just installed this contribution. Everything is working fine, expect my 'send email' function under 'tools' is not functioning.

It says: 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 znc_subscribers as s LEFT JOIN znc_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.

Which part of the settings have i not set?
Appreciated if someone could me on this.

I've attached a pic for reference as well.

I have ALMOST the same as you....
The difference is in colour
My website is here

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.

stevefriedman71:

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

How do you do this?

Kind Regards Casey
Personalised Address Labels and more...

stevefriedman71:

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

I got this working. Changed all tables in phpAdmin to latin1_general_ci
which included the ones for the modules:
Poll Box
Rewards Points
News Box

I also changed newsletter and subscriber

I then went to admin >> Customers >> Subscription Manager, uninstalled it and then re-installed and it all works fine.

Kind Regards Casey

I have started another thread but I think this is the tread I should list in. I think the newsletter module is causing the problem.
Here is the problem. The newsletter module is working like it is suppose to. I can send newsletters to the ones who want them, I just can't send out regular emails to any customers who is not sign up. In other words a customer that is not sign up for the newsletter I can not send them a regular email when I select admin/send mail.
I mean if a customer bought something from me and paid for that item and I notice afterward the item is out of stock that they bought, now I need to email the customer to let them know whats going on but this particular customer is not sign up to our newsletter the system will not let me email them for some reason.

That was a long thread to read!!! As anyone figured out how to add the unsubscribe link to the newsletters?

I did not try before installing this module, so I am not sure it's supposed to be there in the first place.

The Email Options>Newsletter Unsubscribe Link in my admin is well set on true.

Apart from adding it manually when sending newsletters, I couldn’t find any solution in the forums.

Thanks!

Hi!

I have downloaded the zip file and try to install. But i can't find any sql in the package that allow me to update the database.

I have download all the version in the listing but still can't find one. Can anyone help?

Thannaree:

That was a long thread to read!!! As anyone figured out how to add the unsubscribe link to the newsletters?

I did not try before installing this module, so I am not sure it's supposed to be there in the first place.

The Email Options>Newsletter Unsubscribe Link in my admin is well set on true.

Apart from adding it manually when sending newsletters, I couldn’t find any solution in the forums.

Thanks!

Zen Cart automatically adds the unsubscribe link to "html" newsletters regardless whether you use this mod or not

Text only emails are the problem.
Zen adds an unsubscribe link, but it requires the user to login.
Again regardless if you use this mod or not.

kwan_kwan08:

Hi!

I have downloaded the zip file and try to install. But i can't find any sql in the package that allow me to update the database.

I have download all the version in the listing but still can't find one. Can anyone help?

goto...
admin->customers->Subscription Manager
Click the "Install" button
This automagically does the sql required

countrycharm:

I have started another thread but I think this is the tread I should list in. I think the newsletter module is causing the problem.
Here is the problem. The newsletter module is working like it is suppose to. I can send newsletters to the ones who want them, I just can't send out regular emails to any customers who is not sign up. In other words a customer that is not sign up for the newsletter I can not send them a regular email when I select admin/send mail.
I mean if a customer bought something from me and paid for that item and I notice afterward the item is out of stock that they bought, now I need to email the customer to let them know whats going on but this particular customer is not sign up to our newsletter the system will not let me email them for some reason.

Does :blink:anybody have and answer for this?