Newsletter-Only Subscriptions for v1.3x

**elbert06** · 12 Feb 2011, 07:10 PM

Originally Posted by 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!

**MollyOlly** · 20 Feb 2011, 05:15 AM

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.

**Webbies** · 20 Feb 2011, 11:32 AM

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?

Lieke

**lweldon** · 24 Feb 2011, 08:10 PM

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?

**stevefriedman71** · 24 Feb 2011, 08:18 PM

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

**divaboutiques** · 7 Mar 2011, 05:40 AM

Originally Posted by 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???????????

**divaboutiques** · 7 Mar 2011, 05:41 AM

Originally Posted by 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???????????

**dddmx3** · 8 Mar 2011, 06:41 AM

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.

**dddmx3** · 8 Mar 2011, 07:03 AM

Figured it out.

**cpoet** · 21 Mar 2011, 03:47 PM

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.