I installed the newsletter subscription add on and went to send a newsletter and got 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.

Any ideas?