Can't send email through admin, getting "1267 Illegal mix of collations"

**Jdcolfashion** · 15 Jul 2010, 03:48 AM

Hi guys, whenever I log into my admin and go to send email I am met by this 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 znc_subscribers as s LEFT JOIN znc_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.

my site is www.sdsensualfashion.com

Please help! Thanks!

**DrByte** · 15 Jul 2010, 03:57 AM

From the "Similar Threads" listed at the bottom of this page:
http://www.zen-cart.com/forum/showthread.php?t=156882

**Jdcolfashion** · 15 Jul 2010, 04:18 AM

I made sure to read those threads, but I do not know how to even install myphpadmin and I reinstalled the subscription manager but it still says the same thing.

How do I go about installing the myphp sql? Thanks

**DrByte** · 15 Jul 2010, 04:41 AM

As far as phpMyAdmin goes, that's supplied by your hosting company. You should ask them where to find it in your hosting control panel that they gave you instructions to login to for managing your website.

**DrByte** · 15 Jul 2010, 05:03 AM

Try going to Admin->Tools->Install SQL Patch and paste the following into the window and click the Send button:

Code:

alter table subscribers change email_address email_address 
 varchar(96) NOT NULL default '' UNIQUE collate 'latin1_general_ci';

**RaLz87** · 26 Aug 2010, 02:28 AM

Just want to let others know that I was having the same issue as OP and this fixed my problem. Thanks!

**picandnix** · 20 Jan 2011, 11:17 PM

Dr Byte I have to say you are a genius!

I had that same issue after I had installed Newsletter Subscribe to my site, I searched, and once again my issue was resloved within two minutes of discovering the problem thanks to your SQL patch. So now it's the first night in a long time I can manage to have an early night.

**jingjo** · 18 Oct 2011, 11:43 PM

Originally Posted by picandnix

Dr Byte I have to say you are a genius!

I had that same issue after I had installed Newsletter Subscribe to my site, I searched, and once again my issue was resloved within two minutes of discovering the problem thanks to your SQL patch. So now it's the first night in a long time I can manage to have an early night.

Had the same problem too after installing Newsletter Subscribe - it seems to be a bug in the ad-on. It would be good to get it fixed.