Illegal Collations message when sending newsletters

[MischiefDesignz]

I am also having a similar problem, I am running Zen 1.3.9d, every time I try to send out a newsletter I get 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' ]

not to sure what to do about it, any help will be appreciated.... THANKS

[DrByte]

What's the history behind your journey to v1.3.9d? What versions did you upgrade *from*, and when?

[MischiefDesignz]

it was a fresh install,
when I go to their phpadmin to check the collation this is what I get ....

The additional features for working with linked tables have been deactivated

[DrByte]

it was a fresh install,

[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' ]

Um ... but ... that query isn't *in* the core of Zen Cart.
Are you using some newsletter addon?

when I go to their phpadmin ...

"their"?

[gilby]

[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' ]THANKS

That looks like code from the "newsletter subscribe" add on
Are you using the latest version for zen-cart 139 of this addon?

[MischiefDesignz]

Are you using some newsletter addon?

"their"?

yes I am using the latest version of newsletter subscribe, and "their" I am working on a zen cart for some one.

[DrByte]

By default Zen Cart v1.3.9d installs using latin1_general_ci as the collation for its tables.
You've created the "subscribers" table using latin1_swedish_ci for at least the email_address field, and probably the entire table.

Your easiest fix will be to change the collation on that field of the subscribers table to match the rest of your database.

That's assuming you can actually control the database with phpMyAdmin. If you can't, then you'll need to obtain the necessary permissions from your client.

[stevesh]

I have two bone-stock 1.3.9d test sites with no add ons which show latin1_swedish_ci in all tables ...? A server thing, maybe ?

[MischiefDesignz]

got it tyvm I just needed fresh eyes :)

[MischiefDesignz]

I have two bone-stock 1.3.9d test sites with no add ons which show latin1_swedish_ci in all tables ...? A server thing, maybe ?

you will need to go in to your phpmyadmin and change the collation for at least newsletter and subcribers. I changed mine to utf8_unicode_ci and it is working perfectly for me.