Printable View
Hi,
I don't think anyone is actively maintaining this module at the moment. If you read through this thread there have been a number of people posting bug fixes. One of those fixes might help your situation.Quote:
Originally Posted by kimsonvu
Can you be a bit more descriptive about the bug you have found?Quote:
Originally Posted by kimsonvu
Regards,
Christian.
It certainly did, thank you very much, Christian! I'd never have figured that out on my own. Nice avatar, btw! (I'm probably one of the few Americans who'd recognize it!:smile: )Quote:
Originally Posted by CJPinder
No problem, glad it is now working for you.Quote:
Originally Posted by Robert Saint John
Seemed appropriate and suited my weird sense of humor. Amazed you recognised him, I doubt there are many UK people who would, let alone US ones.Quote:
Originally Posted by Robert Saint John
Regards,
Christian.
I get this error, too:
Did anyone ever found a solution to that? It also affects the sending of emails and couponsQuote:
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.
And why is it that the db has BOTH collations, anyway? My DB has "latin1_swedish_ci" AND "latin1_general_ci"
Hi,
Which version of the mod are you using and was it a fresh install or an upgrade? Did you ever have an older version of the mod installed?Quote:
Originally Posted by stevefriedman71
Which version of Zen Cart are you using?
Regards,
Christian.
Fresh install of v 2.0.6 to zencart 1.3.7.1. never used another mod versionQuote:
Originally Posted by CJPinder
ODD:
when i uninstall the mod (botton in the admin) the error changes to that the subscribers table is missing.
When i add this table from a backup DB but NOT instal the mod, i can use the mail and "send gift certificate to customers" but as soon as i install the mod again the error chages back to illegal mix of collations.
Try installing the mod and then copying and pasting the following into Admin..Tools..Install SQL Patches.. (take a database backup first)Quote:
Originally Posted by stevefriedman71
This will delete the existing subscribers table and create a new one without any mention of collations. If you have any existing newsletter only subscribers then make note of them because this will lose that information.Code:DROP TABLE IF EXISTS `subscribers`;
CREATE TABLE IF NOT EXISTS `subscribers` (
`subscriber_id` int(11) NOT NULL auto_increment,
`customers_id` int(11) default NULL,
`email_address` varchar(96) NOT NULL default '' UNIQUE,
`email_format` varchar(4) NOT NULL default 'TEXT',
`confirmed` varchar(8) default NULL,
`subscribed_date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`subscriber_id`)
) TYPE=MyISAM;
Somewhere in this long thread there is a copy (or a link to a copy) of version 2.07 of the mod. Might be worth a try as well.
Regards,
Christian.
same effect. the error is back
"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."
It looks like the email_address column in the subscribers table has been created with a latin1_general_ci collation instead of a latin1_swedish_ci collation as it should be. I'm not sure why though.
How was your Zen Cart database originally created? Has it been upgraded or moved since then?
If you are comfortable using PHPMyAdmin (or whatever MySQL admin your host provides) then you could go into the database and change the email_address column in the subscribers table to have a latin1_swedish_ci collation.
Regards,
Christian.
:clap: THANK YOU ALL for the help....
Issue is solved. for all that have the same issue check the tables "subscribers" and "configuration" for collation differences.:smartalec:
FINALLY i got it