Quote Originally Posted by lweldon View Post
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???????????