Newsletter Subscribe 2.2.2 Addon Issue

[jmp04]

Hi all, ive added the Newsletter subscribe 2.2.2 addon:

http://www.zen-cart.com/index.php?ma...roducts_id=106

And tested it by adding an email of my own, confirmation of subscription etc... comes through fine and activates no problems.


When i go into "Newsletter & Product Notifications Manager" to send and email, and click "Send" on the template I have created i get 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.


This also happens if i go into Customers -> Subscription Manager, then try to send an individual email to one account and also going to Tools -> Send Email, results in the same error.

Any ideas where its broken?

J

[jmp04]

Can anyone help at all ?

[Mega Moonshine]

I'm experiencing the same problem.

Haven't had time to poke around and see possible causes, but did look at the file:

[admin]/includes/functions/extra_functions/subscription_manager.php

and saw that NEWSONLY_SUBSCRIPTION_TEST_GROUP could be problematic as its referenced 8 times and looks like it's not defined (to what, btw?) and doesn't look like the syntax (useage) is correct in a couple of places too. (Back-to-back single quotes, etc.)

My Two Cents Worth, anyway. If I figure out more on this, I'll post it as well.

[Mega Moonshine]

Well, I was wrong just moments ago... The file I mentioned earlier is just fine along with the syntax, etc.

Okay, found the fix in a different thread located at:

http://www.zen-cart.com/forum/showthread.php?t=156882

Basically you need to update/change the collation for the some of the fields in the tables "subscribers" and "newsletters". You'll need phpMyAdmin to access your Zen Cart database and have proper permissions to make the quick and simple changes.

I would go with setting them to "latin1_general_ci" as this is the default for Zen Cart, per Dr. Byte, and it worked for me.

This thread should be closed, but kept around for the benefit of others who find this first...