Illegal Collations message when sending newsletters

7 Jun 2010, 2:33 AM

#1

New Zenner

Join Date:: Aug 2008
Location:: Ohio
Posts:: 63
Plugin Contributions:: 2

Illegal Collations message when sending newsletters

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

Mischief Scrapz
Just An Assortment Of Mischief

7 Jun 2010, 2:54 AM

#2

drbyte

Sensei

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

Re: Illegal Collations message when sending newsletters

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

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

7 Jun 2010, 3:43 AM

#3

mischiefdesignz

New Zenner

Join Date:: Aug 2008
Location:: Ohio
Posts:: 63
Plugin Contributions:: 2

Re: Illegal Collations message when sending newsletters

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

:dontgetit

Mischief Scrapz
Just An Assortment Of Mischief

7 Jun 2010, 4:14 AM

#4

drbyte

Sensei

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

Re: Illegal Collations message when sending newsletters

MischiefDesignz:

it was a fresh install,
MischiefDesignz:

[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?

MischiefDesignz:

when I go to their phpadmin ...
"their"?

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

7 Jun 2010, 4:23 AM

#5

gilby

Totally Zenned

Join Date:: Aug 2005
Location:: Vic, Oz
Posts:: 1,816
Plugin Contributions:: 0

Re: Illegal Collations message when sending newsletters

MischiefDesignz:

[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?

Contribs: - Time Zone Fix/Offset ■ Google Adsense ■ betterCategoriesEzInfo ■ Multi Cross Sell

7 Jun 2010, 4:43 AM

#6

mischiefdesignz

New Zenner

Join Date:: Aug 2008
Location:: Ohio
Posts:: 63
Plugin Contributions:: 2

Re: Illegal Collations message when sending newsletters

DrByte:

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.

Mischief Scrapz
Just An Assortment Of Mischief

7 Jun 2010, 4:47 AM

#7

drbyte

Sensei

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

Re: Illegal Collations message when sending newsletters

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.

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

7 Jun 2010, 9:34 AM

#8

stevesh

Black Belt

Join Date:: Feb 2005
Location:: Lansing, Michigan USA
Posts:: 19,793
Plugin Contributions:: 2

Re: Illegal Collations message when sending newsletters

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 ?

7 Jun 2010, 2:03 PM

#9

mischiefdesignz

New Zenner

Join Date:: Aug 2008
Location:: Ohio
Posts:: 63
Plugin Contributions:: 2

Re: Illegal Collations message when sending newsletters

got it tyvm I just needed fresh eyes :)

Mischief Scrapz
Just An Assortment Of Mischief

7 Jun 2010, 2:05 PM

#10

mischiefdesignz

New Zenner

Join Date:: Aug 2008
Location:: Ohio
Posts:: 63
Plugin Contributions:: 2

Re: Illegal Collations message when sending newsletters

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 ?

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.

Mischief Scrapz
Just An Assortment Of Mischief

4 Jul 2010, 2:18 AM

#11

mana

New Zenner

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

Re: Illegal Collations message when sending newsletters

I've been having a similar problem. I thought I'd successfully changed all collations to what was being used for all other tables (latin1_general_ci), but when I go to try again it has the same error message except that the bad collation is latin1_general_cs ... and I can see this collation nowhere in any of my databases. Any ideas?

4 Jul 2010, 3:09 AM

#12

mana

New Zenner

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

Re: Illegal Collations message when sending newsletters

Ok, I've fixed it...if anyone is having a similar problem, you just need to remove then reinstall the subscription manager (can't believe I didn't think of that before).