Newsletter Subscriber Discount

[swguy]

The Newsletter Discount mod has been updated to include the latest MailChimp API. Only MailChimp users need upgrade; others are not affected. PLEASE READ THE INSTRUCTIONS CAREFULLY; there are a couple of new steps due to changes in the API. Note that if you are also running MailChimp sidebox, you must upgrade that module too.

Note that you MUST remove and reinstall this module in admin->modules->order total to get the new settings you need.

[gotlogos]

I've installed this and it has done something to my email database to where I can no longer send emails or even use the newsletter function of my admin. I cannot even export my email addresses. I get this error message everytime I NOW try to use any of my emial capabilities in zen cart:

"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."

I have seen in another thread where someone else was having these issues.

Is there any solution to this? I am in a bit of a panic mode now as my list is getting larger and I need to communicate with them. I cannot even send them direct emails from within the admin of zen cart

[swguy]

Your issue has nothing to do with Newsletter Discounts. You need to change the collations on your tables so that they are consistent.

[gotlogos]

Hi--I never saw this error before I installed Newsletter Discounts and I had tested the built-in email and newsletter functions of Zen Cart.

Re: changing collations. I am pretty tech-saavy so if you could give me an idea of what I would have to do for this. As it stands now I am going to have to go through the laborious task of trying to get my emails out of Zen Cart and use some third party solutions.

Any help would be appreciated.

thanks - Daniel

Your issue has nothing to do with Newsletter Discounts. You need to change the collations on your tables so that they are consistent.

[gotlogos]

I really love this module...in our openign week it has been a smash week with all of our customers practically, signign up for the Newletter for an automatic 5% discount.

But I really need to be able to use my newsletter features in ZenCart. When I now go to access any sned mail functions it gives this:

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.


TSG you mention I need to fix collations. I am not a computer newbie by any means but is there any info you or anyone can give to do this. I badly need to start sendign out Newsletter announcements.

Daniel
GotVapes.com

[swguy]

Backup your database.
Google "Change Collation Mysql phpMyAdmin"
Do what it says.
You should do this on the subscribers and configuration tables.

[gotlogos]

Backup your database.
Google "Change Collation Mysql phpMyAdmin"
Do what it says.
You should do this on the subscribers and configuration tables.

Thanks - I actually found a sql patch from DrBytes that I applied in the Tools menu that worked perfectly...

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

[MollyOlly]

I figured this out fairly quickly. Just add:

if ($_SESSION['cc_id'] > 0) {
return;
}

to function process() in ot_newsletter_discount.php...


Before coupon is applied:


After any coupon is applied:

Can you please tell me what line you put this on because I can not get it to work for me at all.
Thank you

[mstng67]

Is there a way to make the newsletter discount effective after other discounts, i.e., the quantity discount? I would rather have the newsletter discount be taken off last.

[swguy]

Each of the discounts has a sort order in admin->modules->order total. Just set the sort order of Quantity Discounts to be lower than Newsletter Discount, and it will be done that way.