Great! This works, what would I be without all you top zenners out there!Quote:
Originally Posted by davewest
Thank you for the input!
Printable View
Great! This works, what would I be without all you top zenners out there!Quote:
Originally Posted by davewest
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
gettting the same error, I tried changing the collation in the phpmyadmin and the error is showing???????????Quote:
Originally Posted by lweldon
Quote:
Originally Posted by stevefriedman71
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.