Error 1267 - Newsletter Subscriber add-on
This is the error message I get when trying to email newsletter subscribers:
1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'locate'
[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.
I've just added the Newsletter Subscriber add-on which allows 'customers' (not registered) to subscribe to the newsletter only.
Would someone point me in the right direction?
By swguy in forum All Other Contributions/Addons
Last Post: 1 May 2012, 01:25 PM
By BassFace in forum General Questions
Last Post: 14 Aug 2009, 06:26 AM
By cla74 in forum General Questions
Last Post: 10 May 2009, 02:54 PM
By one tall man in forum General Questions
Last Post: 13 Mar 2009, 01:49 PM
By lhhgbh in forum General Questions
Last Post: 23 Dec 2006, 04:17 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC