Zen Cart Logo
Forums / All Other Contributions/Addons / newsletter subscribe 2.2.2 can not send e-mail

newsletter subscribe 2.2.2 can not send e-mail

Views: 760

Results 1 to 4 of 4
4 Jul 2011, 7:57 PM
#1
ms4104 avatar

ms4104

New Zenner

Join Date:
May 2011
Posts:
11
Plugin Contributions:
0

newsletter subscribe 2.2.2 can not send e-mail

I installed newsletter subscribe and everythign works good. I can see the layout side box, i have the subscription option under the customers tab now, but when I click send e-mail from the subscription management area or from the tools>send email area I get this error

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.

Anyone know what this could be?

Site is https://www.dazed.me

4 Jul 2011, 7:59 PM
#2
ms4104 avatar

ms4104

New Zenner

Join Date:
May 2011
Posts:
11
Plugin Contributions:
0

Re: newsletter subscribe 2.2.2 can not send e-mail

Is there any chance this could be related to my installation?

/public_html/catalog/includes/languages/english/html_includes/mygrey/

definesubscript.php & defineunsubscript.php are supposed to be changed to CHMOD 777 then back to 644. I am 99% sure I did this..but 1% of me can not remember.

4 Jul 2011, 8:23 PM
#4
ms4104 avatar

ms4104

New Zenner

Join Date:
May 2011
Posts:
11
Plugin Contributions:
0

Re: newsletter subscribe 2.2.2 can not send e-mail

Thanks

Fixed

No explanation what caused it though. The sql string fixed it so I am happy ;)