Newsletter-Only Subscriptions for v1.3x

[CJPinder]

Hi,

How long will it take to have new version of this modules?

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.

This is great modules but i found some bug!

Can you be a bit more descriptive about the bug you have found?

Regards,
Christian.

[Robert Saint John]

That should fix it.

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! )

[CJPinder]

It certainly did, thank you very much, Christian! I'd never have figured that out on my own.

No problem, glad it is now working for you.

Nice avatar, btw! (I'm probably one of the few Americans who'd recognize it! )

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.

Regards,
Christian.

[stevefriedman71]

I get this error, too:

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.

Did anyone ever found a solution to that? It also affects the sending of emails and coupons

And why is it that the db has BOTH collations, anyway? My DB has "latin1_swedish_ci" AND "latin1_general_ci"

[CJPinder]

Hi,

I get this error, too:
Did anyone ever found a solution to that? It also affects the sending of emails and coupons
And why is it that the db has BOTH collations, anyway? My DB has "latin1_swedish_ci" AND "latin1_general_ci"

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?

Which version of Zen Cart are you using?

Regards,
Christian.

[stevefriedman71]

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?

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 version

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.

[CJPinder]

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)

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;

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.

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.

[stevefriedman71]

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

[CJPinder]

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.

[stevefriedman71]

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.

FINALLY i got it