Newsletter Subscribe 2.2.2 Addon Issue

[jmp04]

Hi all, ive added the Newsletter subscribe 2.2.2 addon:

http://www.zen-cart.com/index.php?ma...roducts_id=106

And tested it by adding an email of my own, confirmation of subscription etc... comes through fine and activates no problems.


When i go into "Newsletter & Product Notifications Manager" to send and email, and click "Send" on the template I have created i get the following 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.


This also happens if i go into Customers -> Subscription Manager, then try to send an individual email to one account and also going to Tools -> Send Email, results in the same error.

Any ideas where its broken?

J