Newsletter-Only Subscriptions for v1.3x

Seen a few unanswered posts in this thread from people who are just unable to get it to even show let alone work. Here is my problem, i will explain as best i can;

I have downloaded Newsletter Subscribe 2.2 and meticulously uploaded all the files to their correct locations as per the file structure etc. All template based files are in the correct folders based on the name of my template.

My zencart version is 1.3.9h.
I log into my admin panel and go to tools - layout boxes controller and am informed there is a new module found, which i edit to appear on the left column.

As per the readme file i go to config - my store but there is no mention of it anywhere in there and my site shows absolutely no trace of it. No meta tags, no button, no link, nothing.

This is the first time i've tried to install this particular mod, so i'm hoping i'm missing something really obvious as plenty of people clearly have it working.

Many thanks
Matt

Matthammer:

Seen a few unanswered posts in this thread from people who are just unable to get it to even show let alone work. Here is my problem, i will explain as best i can;

I have downloaded Newsletter Subscribe 2.2 and meticulously uploaded all the files to their correct locations as per the file structure etc. All template based files are in the correct folders based on the name of my template.

My zencart version is 1.3.9h.
I log into my admin panel and go to tools - layout boxes controller and am informed there is a new module found, which i edit to appear on the left column.

As per the readme file i go to config - my store but there is no mention of it anywhere in there and my site shows absolutely no trace of it. No meta tags, no button, no link, nothing.

This is the first time i've tried to install this particular mod, so i'm hoping i'm missing something really obvious as plenty of people clearly have it working.

Many thanks
Matt

Zen cart has had a over haul so you need to take the core files this module uses and merge them with the file that zen cart uses. This will fix your problems.

Hi, managed to fix this. Merge not required.
Thanks

countrycharm:

Zen cart has had a over haul so you need to take the core files this module uses and merge them with the file that zen cart uses. This will fix your problems.

Your answer assumes that everyone knows what you mean by "merge". And how do you merge by the way? And exactly what core files are you talking about?

Can you elaborate and be specific?

Matthammer:

Hi, managed to fix this. Merge not required.
Thanks

Great...could you not have told the rest of us how you managed to fix it, and help out others on the forum?

The problem I am having is this is what I see when I go 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 zen_subscribers as s LEFT JOIN zen_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.

So, I can't even send emails to anyone. I think that is the only issue with this module that I am having. I am finally seeing it under Layout Boxes Controller and have successfully added the newsletter sidebox to my template...but if you can't send any emails, then it does no good.

Does anyone know how to edit the text within this newsletter module?

The generic "Enter your email address to subscribe to our Newsletter." could be changed to offer something in exchange for a subscription (free report, coupon, etc.) which would be much better from a marketing standpoint.

Thanks!

organelle67:

The problem I am having is this is what I see when I go 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 zen_subscribers as s LEFT JOIN zen_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.

So, I can't even send emails to anyone. I think that is the only issue with this module that I am having. I am finally seeing it under Layout Boxes Controller and have successfully added the newsletter sidebox to my template...but if you can't send any emails, then it does no good.

Modifications are made to the following core files:
admin/index.php
admin/customers.php
includes/functions/function_email.php
includes/functions/audience.php
includes/modules/pages/account_edit/header_php.php
includes/modules/pages/account_newsletters/header_php.php
includes/modules/pages/unsubscribe/header_php.php

If you have made other changes, or have added other modules add on's, that uses these core files that are mentioned here,
I highly recommend using a merging program, such as WinMerge
(http://winmerge.sourceforge.net/) to merge the files together. Most problems are due to files not being in the right place. In other words people didn't change the custom folder name to match theirs.

I had the same issue and found you have to go to the table structure and change the collation for the individual fields as well!

organelle67:

The problem I am having is this is what I see when I go 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 zen_subscribers as s LEFT JOIN zen_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.

So, I can't even send emails to anyone. I think that is the only issue with this module that I am having. I am finally seeing it under Layout Boxes Controller and have successfully added the newsletter sidebox to my template...but if you can't send any emails, then it does no good.
I had the same error message and I had to go into MySQL and edit the fields that were set as latin1_swedish to latin1_general

I have been trying to get this mod to work with COWOA for the last couple of days and I know that there is documentation about COWOA and this mod having compatibility issues due to the fact that COWOA clients are still entered into the database, but as they function completely separate other than that variable, I figured I could work out a way to make them play nice - and I think I did it.

I just wanted to post what I did here in the hopes that someone who has actual php knowledge would take a look and confirm that it won't cause conflicts in my coding.

What I did was go into the includes/modules/pages/subscribe/header.php and in the "check if email address exists in CUSTOMERS table or in SUBSCRIBERS table" section, I added

$check_cust_COWOA_query = "select count(*) as total from " . TABLE_CUSTOMERS .
			" where COWOA_account = '" . zen_db_input($COWOA_account) . "'";
		$check_cust_COWOA = $db->Execute($check_cust_COWOA_query);

underneath

$check_cust_email_query = "select count(*) as total from " . TABLE_CUSTOMERS .
			" where customers_email_address = '" . zen_db_input($email_address) . "'";
		$check_cust_email = $db->Execute($check_cust_email_query);

and then I changed

if ($check_cust_email->fields['total'] > 0) {

to

if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA == 'false')){

I followed the same steps in admin/subscription_manager.php.

Then I created a test COWOA order, signed up for a subscription and everything worked perfectly. I got a confirmation email and was able to confirm my subscription even though I had completed a COWOA order with the same email address.

I know that the mindset is that a COWOA client will most likely not want a subscription but after so many years in the customer service field, I wouldn't be surprised if a handful of them do. People can be so weird sometimes.

I have the newsletter module in my header but I can't seem to figure out how to get it to the right and down in the middle.

http://frompropertorocker.com/fptr_test/

I am sure it's probably really simple and I am just missing where to go lol.

Thanks in advance!

nolsowski:

I have the newsletter module in my header but I can't seem to figure out how to get it to the right and down in the middle.

http://frompropertorocker.com/fptr_test/

I am sure it's probably really simple and I am just missing where to go lol.

Thanks in advance!

If you still need help with this, I'm not great at coding but I can show you how to adjust the css - it's really easy with FF.

I looked at your site (which is fabulous - I love the stars on your sidebox headers!) and didn't see the newsletter subscribe box.

kamelion0927:

If you still need help with this, I'm not great at coding but I can show you how to adjust the css - it's really easy with FF.

I looked at your site (which is fabulous - I love the stars on your sidebox headers!) and didn't see the newsletter subscribe box.

Thanks Kamelion. I forgot I shut it off when I was working on the header. It's up but it's hard to see now but it's at the top still lol.

If it's possible to move to the right and to the bottom that will be awesome! If not that's ok and I will just put it in the sidebox.

Thank you for the compliments of my site and for your help. :)

Ok. I see what you're going for!

I think I have mine in about the same position that you want yours.

The first thing that you're going to need to do is go into includes/templates/your_template/common/tpl_header.php and add some <div> tags to your code which you can then utilize in the stylesheet.

In includes/templates/your_template/common/tpl_header.php, your code should look something like this:

<div id="subscribeWrapper">
<?php // BEGIN newsletter_subscribe mod 1/1 if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') && (NEWSONLY_SUBSCRIPTION_ENABLED=='true') && (NEWSONLY_SUBSCRIPTION_HEADER=='true')) { include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_SUBSCRIBE_HEADER)); } // END newsletter_subscribe mod 1/1 ?>
</div>

By placing the <div id="subscribeWrapper"> before the code and the </div> after, you can tell the stylesheet which section needs to be moved.

Next, open up your stylesheet.css and anywhere you want add:
subscribeWrapper{}

Then you can add padding and margins as applicable inside the {}.

I highly recommend using a Firefox add-on called Firebug if you don't already because you can actually adjust the CSS on your site through Firebug to see what it looks like before you change the stylesheet. It saves a lot of time when making adjustments to CSS.

Just an FYI, I'm pretty new to all of this too so if I didn't explain myself clearly, don't feel bad asking for further explanation.

Good luck!

kamelion0927:

Ok. I see what you're going for!

I think I have mine in about the same position that you want yours.

The first thing that you're going to need to do is go into includes/templates/your_template/common/tpl_header.php and add some <div> tags to your code which you can then utilize in the stylesheet.

In includes/templates/your_template/common/tpl_header.php, your code should look something like this:

<div id="subscribeWrapper">
<?php // BEGIN newsletter_subscribe mod 1/1 if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') && (NEWSONLY_SUBSCRIPTION_ENABLED=='true') && (NEWSONLY_SUBSCRIPTION_HEADER=='true')) { include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_SUBSCRIBE_HEADER)); } // END newsletter_subscribe mod 1/1 ?>
</div>

By placing the <div id="subscribeWrapper"> before the code and the </div> after, you can tell the stylesheet which section needs to be moved.

Next, open up your stylesheet.css and anywhere you want add:
subscribeWrapper{}

Then you can add padding and margins as applicable inside the {}.

I highly recommend using a Firefox add-on called Firebug if you don't already because you can actually adjust the CSS on your site through Firebug to see what it looks like before you change the stylesheet. It saves a lot of time when making adjustments to CSS.

Just an FYI, I'm pretty new to all of this too so if I didn't explain myself clearly, don't feel bad asking for further explanation.

Good luck!

Thanks a bunch! I got the first part done pretty easily but on the second part I have a question. Where did you add the code in the stylesheet? I am lost on where to even put it. lol

nolsowski:

Thanks a bunch! I got the first part done pretty easily but on the second part I have a question. Where did you add the code in the stylesheet? I am lost on where to even put it. lol

Nvm lol. I got it now. Almost lol. Just need to play with the code to get it to the bottom now. :)

Okay I was wrong. I am going to need your help lol.

I have been playing with it in the firebug and it keeps messing up my logo. (I don't have an actual header. I made my header to go in the logo since it wasn't fitting right when I named it to go in the header) Does that make a difference now? Sorry I just remembered that and now it probably won't work?

nolsowski:

Okay I was wrong. I am going to need your help lol.

I have been playing with it in the firebug and it keeps messing up my logo. (I don't have an actual header. I made my header to go in the logo since it wasn't fitting right when I named it to go in the header) Does that make a difference now? Sorry I just remembered that and now it probably won't work?

Nope - the code for the subscribe header is completely separate from the rest of the header. It all depends on where you put the code.

Think of the header (or any other code) as a Lego wall, the divs as small pieces of stuck together Legos and each piece of code as an individual Lego. If you have a bunch of different code in the same div, they're going to move together - just like a bunch of constructed Legos. (Stupid analogy I know, but the most visual one I can come up with on this little sleep.)

In looking at your site, I'm not showing the subscribeWrapper CSS settings. Do you have #subscribeWrapper{} on your stylesheet?

kamelion0927:

Nope - the code for the subscribe header is completely separate from the rest of the header. It all depends on where you put the code.

Think of the header (or any other code) as a Lego wall, the divs as small pieces of stuck together Legos and each piece of code as an individual Lego. If you have a bunch of different code in the same div, they're going to move together - just like a bunch of constructed Legos. (Stupid analogy I know, but the most visual one I can come up with on this little sleep.)

In looking at your site, I'm not showing the subscribeWrapper CSS settings. Do you have #subscribeWrapper{} on your stylesheet?

That does make sense. I didn't put the subscribeWrapper in the CSS yet because I am not sure where in the CSS to put it lol.

I just put it in now so hopefully it's in the right place lol