Newsletter-Only Subscriptions for v1.3x

[sergiojg]

Hey guys, I did the installation and is working very good but the only problem that i have when i make an email to send to the customers i use html and it only send text, so i can't not send images or colors. please help me.

i install to see if i can fix this problem a new editor but i see and i use the editor but when i sent is only text.

Please help me to fix it.

[xxhlp]

Hi, I got a problem when I tried to install this module on v1.3.9h.
I have copied all the files to Zen cart folders, and when I clicked the botton <Install> at Admin panel, the below messages came out and I had nothing to do with it.

------------------------------------------------------
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
in:
[ CREATE TABLE IF NOT EXISTS zen_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;]
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.

--------------------------------------------------------------------------

I am using:

Database: MySQL 5.5.8
PHP Version: 5.3.5 (Zend: 2.3.0)
Server OS: Windows NT
HTTP Server: Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1
@localhost XAMPP


Can anyone help me out?
Thanks!

[SarahL]

For all the "duplicate email address" errors that you are getting from your store - I looked into it and it was actually ignoring the UPDATE SQL statement in create_account.php, the reason that it was ignoring it look to be as it was checking to see how many customers_id's were present - as the customer isn't a customer yet it would always come back 0 - therefore try to INSERT rather than UPDATE

Made 1 tweak too:

includes/modules/YOUR_TEMPLATE/create_account.php

line 320 & 321 change to this

$check_subscribers_sql = "select count(subscriber_id) as total from " . TABLE_SUBSCRIBERS . "
							      where email_address = :email:";

just changed customers_id too subscriber_id in count statement

Working for me on 1.3.9h

Thanks
Sarah

[triple Moon Ranch]

Hi I hope im doing this is the right place.
I just installed this in version1.3.9h as well and I didn't get the error when installing it everything seemed to be working fine till I got to where you go to Tools/send email.

Then I get this message:

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 wzc_subscribers as s LEFT JOIN wzc_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.


If someone could point me in the right direction as to how to fix this they would be my hero. LOL

Thanks,
Suzanne

[triple Moon Ranch]

Please forgive me I did not see the post that was excatly the same as mine further up this thread.

The solution about changing the db setting from swedish to general does seem to be the solution. It worked for me as well.

Thanks again,
Suzanne

[shorti6877]

i am using zen car 1.3.9h
I wanted to send a newsletter and when i hit the send button this is what I got:

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 znc_subscribers as s LEFT JOIN znc_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.

[kamelion0927]

i am using zen car 1.3.9h
I wanted to send a newsletter and when i hit the send button this is what I got:

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 znc_subscribers as s LEFT JOIN znc_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.

Look at the post right above yours. This has been answered at least a couple times before.

[shorti6877]

thanks i didnt realize it..i seem to have fixed it..now a new problem of newsletter only sending in text format..will need send in HTML ugh

[gilby]

thanks i didnt realize it..i seem to have fixed it..now a new problem of newsletter only sending in text format..will need send in HTML ugh

See here:
http://www.zen-cart.com/forum/showthread.php?t=163280

[kamelion0927]

thanks i didnt realize it..i seem to have fixed it..now a new problem of newsletter only sending in text format..will need send in HTML ugh

I know what you mean. That issue took a bit more work but if you search through the forums, I know the answer is there. (I would just tell you how, but I fixed it so long ago, I can't remember.)