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
Quote:
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! :smile:
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
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
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.
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:
Code:
alter table subscribers change email_address email_address
varchar(96) NOT NULL default '' UNIQUE collate 'latin1_general_ci';
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!
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.
Re: Can't send email through admin, getting "1267 Illegal mix of collations"
Quote:
Originally Posted by
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:
