newsletter subscribe 2.2.2 can not send e-mail

[ms4104]

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 www.dazed.me

[ms4104]

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.

[DrByte]

Other threads dealing with this, found by searching for your error message:

http://www.zen-cart.com/forum/showthread.php?t=159455
http://www.zen-cart.com/forum/showthread.php?t=156882

[ms4104]

Thanks

Fixed

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