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

15 Jul 2010, 2:48 AM

#1

New Zenner

Join Date:: Jun 2010
Posts:: 23
Plugin Contributions:: 0

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

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 https://www.sdsensualfashion.com

Please help! Thanks! :smile:

15 Jul 2010, 2:57 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

15 Jul 2010, 3:18 AM

#3

jdcolfashion

New Zenner

Join Date:: Jun 2010
Posts:: 23
Plugin Contributions:: 0

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

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

15 Jul 2010, 3:41 AM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

15 Jul 2010, 4:03 AM

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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

Try going to Admin->Tools->Install SQL Patch and paste the following into the window and click the Send button:```
alter table subscribers change email_address email_address
varchar(96) NOT NULL default '' UNIQUE collate 'latin1_general_ci';

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

26 Aug 2010, 1:28 AM

#6

ralz87

New Zenner

Join Date:: Aug 2010
Posts:: 1
Plugin Contributions:: 0

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

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

20 Jan 2011, 10:17 PM

#7

picandnix

Totally Zenned

Join Date:: Dec 2010
Location:: UK
Posts:: 1,779
Plugin Contributions:: 2

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

Dr Byte I have to say you are a genius! :clap: :clap: :clap:
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.

**Low cost websites**

18 Oct 2011, 10:43 PM

#8

jingjo

New Zenner

Join Date:: May 2011
Posts:: 29
Plugin Contributions:: 0

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

picandnix:

Dr Byte I have to say you are a genius! :clap: :clap: :clap:
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. :frusty: