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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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