Newsletter-Only Subscriptions for v1.3x

Zen Cart automatically adds the unsubscribe link to "html" newsletters regardless whether you use this mod or not

Text only emails are the problem.
Zen adds an unsubscribe link, but it requires the user to login.
Again regardless if you use this mod or not. 

Thanks for confirming this. However, I've tried again, both in html and text-only, and the link isn't there. I use the latest ZC. Do you know what could cause this?

thanks gilby.

I just figured it out. I can't find the admin->customers->Subscription Manager because i have install user access control module. That's why i can't see it in the customer menu.

I have enable it and able to intall it.

Thanks

Hi all,
This is my first time posting a question here. Sorry it's the question has already been addressed before in this thread but I wasn't able to go through >100 pages in this thread to find my answer.

I've followed the installation instructions & everything seems to work well, except that I couldn't find the Newsletter sign-up box/form at the header or sidebox. Is there any error made or omission by me?

Thanking in advance for your help & guidance :smile:

I've followed the installation instructions & everything seems to work well, except that I couldn't find the Newsletter sign-up box/form at the header or sidebox. Is there any error made or omission by me?

1. I think that you have to physically click the install button for the subscription manager mod via admin->customers->subscription manager before it is activated.

2. Next, under admin->configuration->layout settings you must check out the item labeled "Show Newsletter-only subscription field in header?" and make sure it is set appropriately to determine whether the sub mgr is located in the header or as a sidebox.

3. If it's set as a sidebox in #2, did you try to turn on the sidebox in admin->tools->layout boxes controller? You should have a sidebox something like sideboxes/YOUR_TEMPLATE/subscribe.php" which needs to be turned on with the appropriate settings.

HTH.

Jason

Thanks Jason so much for your guidance... didn't expect a response so soon :smile: I'm ok with Step 1 & 2 below but couldn't find the subscribe.php in the Layout Boxes Controller... what would possibly have gone wrong?

lindenboy:

1. I think that you have to physically click the install button for the subscription manager mod via admin->customers->subscription manager before it is activated.

2. Next, under admin->configuration->layout settings you must check out the item labeled "Show Newsletter-only subscription field in header?" and make sure it is set appropriately to determine whether the sub mgr is located in the header or as a sidebox.

3. If it's set as a sidebox in #2, did you try to turn on the sidebox in admin->tools->layout boxes controller? You should have a sidebox something like sideboxes/YOUR_TEMPLATE/subscribe.php" which needs to be turned on with the appropriate settings.

HTH.

Jason

When you copied the add-on files to your server are you ABSOLUTELY SURE that you found EVERY instance of YOUR_TEMPLATE and change it appropriately to the actual template name?

I say this for 2 reasons: 1) This appears to be the reason behind many add-ons not working upon installation and 2) Because there are SEVERAL locations within the subscribe add-on files structure which require you to change the default template folder name (YOUR_TEMPLATE) to your actual template name. One in particular that I just looked at is buried in "includes/templates." This happens to be where the sidebox contents are location. Without this path being correct, the admin console wouldn't know you added a sidebox.

When you finished installation and pulled up the layout boxes controller, were you greeted with a message at the top that said something like "new sideboxes found?" If not, you definitely did not copy over the correct file structure.

As a newb myself, I can confidently stress that making sure the file and folder structure is correct is the #1 priority when installing add-ons; I have about 10 under my belt to date, all of which work flawlessly. #2 by the way is simply following the instructions to a T.

HTH.

Jason

i installed all the files but i have the follow error message.

ERROR: The email template file for (/home/muytruch/public_html/email/so/email_template_) or (/home/muytruch/public_html/email/so/email_template_subscribe.html) cannot be found.

any idea of how to fix it ?

Hi I'm having the same problem as Integrity Designs on the page before... i just have no idea what i've done to cause this error message and re-uploading the files doesn't seem to be doing the trick so I imagine i'm putting something in the wrong place? If anyone's got any clues I'd greatly appreciate it...

Error when going to Admin>Tools>Send Email:

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.

CheekyCockney:

Hi I'm having the same problem as Integrity Designs on the page before... i just have no idea what i've done to cause this error message and re-uploading the files doesn't seem to be doing the trick so I imagine i'm putting something in the wrong place? If anyone's got any clues I'd greatly appreciate it...

Error when going to Admin>Tools>Send Email:

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.

Small update: After some more searching I have ventured into phpMyAdmin and checked out the collation settings. In 'subscribers', the collation for email_address, email_format & confirmed are all set to 'latin1_swedish_ci' which i'm lead to beleive is correct.(?) But every other collation setting in my database is set to 'latin1_general_ci'. I imagine this could cause an 'illegal mix' as the error suggests?

Hopefully this helps, I have absolutely no idea what I just said.

Me again. I was brave and changed the 3 swedish collation settings to general... and it now seems to work. Which is good news, but I'd still like someone to let me know what I did wrong... and actually how I fixed it if anyone has a clue!

Thanks

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.

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!

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

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

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

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.

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.

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

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

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

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

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

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.) :smile: