Newsletter-Only Subscriptions for v1.3x

Sorry if this has been covered but i can't find it.

Installed NS and working on 1.3.9e except that a newsletter subscriber stays a newsletter subscriber (N) even when they register an account and subscribe to the newsletter. (Should change to (C)

Has anyone any idea why this doesn't change?

Or if it does for you, could you say so, then i'll know it's me :-)

Tia

Paul

I used a former version of Newsletter Subcription before and added a define page of Define_subscribe_confirm.php so that I can edit the confirm in Admin.

After I updated to version 2.2, Define_subscribe_confirm.php didn't work any more.

The confirm page reflects the content in Subscribe_confirm.php. How can I modify the code so that I can still edit the content of confirmation page in Admin under "define page editor"? Much thanks!!

Hello there nice add on like it allot onley thing is I dont need a sidebox couse I wan't it in a jquerry dropdown and on a page for people disabled javascript in their browsers I hacked it and put it in the header but it will not get threw validation at W3C.

I get this returned on both the dropdown div and the page from W3C:

Error Line 120, Column 80: attributes construct error

but things work I just need to find the problem couse i don't get whats wrong pls help!:frusty:

Site: F U C K T H E D R E S S C O D E . C O M

Hi everyone, I've tried to install this twice and each time it ruins my programming...

I am using 1.39 is it compatible with this version? Anyone have any feedback? Thanks!

First, thanks for this addon. It works very well.

I am using Newsletter Subscribe v 2.1.1 with ZC 1.3.9f.

I thought I'd let you know that there are two mispellings in unsubscribe.php. There are two instances of 'adres' instead of 'address'.

Thanks again.

In response to joyjoy's post above here are a couple of tips I have from my experience installing this mod.

1-Make sure all YOUR_TEMPLATE folders are placed in the correct places and renamed to the correct name for your template.

2- The most important thing. For all files that are replacing existing ZenCart files, merge the Newsletter changes into your existing ZenCart files, do not overwrite your existing files even if you think you haven't made any changes in them. If you're running a later version of Zen Cart than Newsletter was made with, then you could be overwriting changes in the newer version of Zen Cart.

I don't know what I'm doing wrong. But I have now tried to install this add 4 times. I have carefully opened every folder and renamed all that is necessary. I have even tried most recently to manually add each folder to it's proper directory - just in case.

It never works! It's driving me crazy because I really want this mod!!!

Is anyone else having problems? Have you been able to solve it?

It's not as if I'm not familiar with what I'm doing. I've installed a lot of add ons and this is the only one that I've had problems with.:frusty:

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.

When I try to edit the table in PHPMyAdmin there doesn't seem to be a way to edit the table. How do I edit it? I can browse but that's it.

robbinsgj:

When I try to edit the table in PHPMyAdmin there doesn't seem to be a way to edit the table. How do I edit it? I can browse but that's it.

Ok, I fixed the collation issue as far as I can see. Configuration and subscribers match but I'm still getting ther following error:
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.

Do you need to change to latin1_swedish_ci for every value or just for collation?

I have a fresh install on 1.3.9x and it appears that an email address is accepted as subscribed, but then it doesn't show up in the database and no sub is created. Please advise :) I've had this work perfectly on everything else I've done...very odd.

After uninstalling this, is there a way to reverse the database error its created? I cant send emails.

bpryor:

First, thanks for this addon. It works very well.
I am using Newsletter Subscribe v 2.1.1 with ZC 1.3.9f.

I thought I'd let you know that there are two mispellings in unsubscribe.php. There are two instances of 'adres' instead of 'address'.
i know that version, it was written for 1.3.8a so handsup for you that you got it to work on the current version 1.3.9f. I suspect you did have a tad more editing to do than just change adres into address :yes:

I wouldn't recommend using version 2.1.1 on 1.3.9 version as it is not tested, i can see in the download section Judy has taken up the task to write the module to be compatible with 1.3.9 in a newer NewsLetter Subscribe version 2.2 series.

bpryor:

In response to joyjoy's post above here are a couple of tips I have from my experience installing this mod.

1-Make sure all YOUR_TEMPLATE folders are placed in the correct places and renamed to the correct name for your template.

2- The most important thing. For all files that are replacing existing ZenCart files, merge the Newsletter changes into your existing ZenCart files, do not overwrite your existing files even if you think you haven't made any changes in them. If you're running a later version of Zen Cart than Newsletter was made with, then you could be overwriting changes in the newer version of Zen Cart.

Excellent advise, this is the safest way to add modules to your store. Counterpart is unfortunately that most shop owners are better in selling products than in looking at php code, which creates sort of a gap sometimes :lamo:

I didn't look at Judy's later versions, but if you choose to use Newsletter subscribe v2.1.1 than this is definetly the only way to get a shot at succesfully implementing it. You need to know what you are doing as it was never written for 1.3.9+ so DO NOT overwrite existing files.
Again, i would recommend going with Judy's later versions in the v2.2 series as they were rewritten for the 1.3.9+ zen-carts

nagelkruid:

i know that version, it was written for 1.3.8a so handsup for you that you got it to work on the current version 1.3.9f. I suspect you did have a tad more editing to do than just change adres into address :yes:

I wouldn't recommend using version 2.1.1 on 1.3.9 version as it is not tested, i can see in the download section Judy has taken up the task to write the module to be compatible with 1.3.9 in a newer NewsLetter Subscribe version 2.2 series.

Excellent advise, this is the safest way to add modules to your store. Counterpart is unfortunately that most shop owners are better in selling products than in looking at php code, which creates sort of a gap sometimes :lamo:

I didn't look at Judy's later versions, but if you choose to use Newsletter subscribe v2.1.1 than this is definetly the only way to get a shot at succesfully implementing it. You need to know what you are doing as it was never written for 1.3.9+ so DO NOT overwrite existing files.
Again, i would recommend going with Judy's later versions in the v2.2 series as they were rewritten for the 1.3.9+ zen-carts

I agree with bpryor 100%
I'm running this on 1.3.9g with no problem. You have to compare and merge the files from the newsletter module with the files in 1.3.9g.

I am having some error when I tried to import a file of email addresses. It gave me this error message:

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 '' at line 1
in:
[REPLACE INTO subscribers ( email_address, email_format, confirmed, subscribed_date ) VALUES ( '��������×�D�@��l�������������������������������� ����ÿ��������!����ÿ��������"����ÿ��������#����ÿ��������$����ÿ��������%����ÿ��������&����ÿ��������'����ÿ��������(����ÿ��������)����ÿ��������*����ÿ��������+����ÿ��������', 'HTML', '1', NOW() )]
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.

Then when I went back to look at the email addresses already in there, I see the � symbol all over. What did I do wrong?

lauriesscraps.com/store

I think I got it figured out now, but would like to still know why it did this. Was it the type of document I was suing to import? It seemed to fix it when I changed it to a note pad doc.

First of all, thanks for this contribution.

I've installed the older version of this mod because I am running zc 1.38a. What I would like to know is, if there is a way to add a first and last name to each email I import. As of now each email has a name of "Newsletter Subscriber".

idle:

First of all, thanks for this contribution.

I've installed the older version of this mod because I am running zc 1.38a. What I would like to know is, if there is a way to add a first and last name to each email I import. As of now each email has a name of "Newsletter Subscriber".

Yes there is but its not easy
You would need to add the required fields to the database
And rewrite a considerable amount of code to add these 2 fields.
I don't believe that anyone has done this before

As well when this has been asked previously
Most have pointed out that the less obstacles you put in a customers way then the more likely thay are to sign up for the newsletter

bpryor:

First, thanks for this addon. It works very well.

I am using Newsletter Subscribe v 2.1.1 with ZC 1.3.9f.

I thought I'd let you know that there are two mispellings in unsubscribe.php. There are two instances of 'adres' instead of 'address'.

Thanks again.

In response to joyjoy's post above here are a couple of tips I have from my experience installing this mod.

1-Make sure all YOUR_TEMPLATE folders are placed in the correct places and renamed to the correct name for your template.

2- The most important thing. For all files that are replacing existing ZenCart files, merge the Newsletter changes into your existing ZenCart files, do not overwrite your existing files even if you think you haven't made any changes in them. If you're running a later version of Zen Cart than Newsletter was made with, then you could be overwriting changes in the newer version of Zen Cart.

I wish I would have read this before I read the install. All of my files have been overwritten and I can't seem to get this to work. I've followed the instructions to a tee... Any suggestions now, after the install, would be greatly appreciated! Version 2.2
Latest version of zencart. :frusty:

Okay. I've been having a full on relationship with winmerge today and I've discovered after 3 installs and 3 backup restores that even though the install file states that admin/index.php and admin/customers.php have changes my files DO NOT show differences. Could this be a problem? I'd appreciate any and all help.

Lynn

http://marketcafe-online.com

If I remove the News letter-only subscription contribution from my site and return to using the standard log in on my site what will happen to my list of news letter subscription only subscribers?

Astarkley:

If I remove the News letter-only subscription contribution from my site and return to using the standard log in on my site what will happen to my list of news letter subscription only subscribers?

Well.... Nothing they will still be in the "subscribers" table, assuming that you don't delete it.

As zen-cart doesn't use it, they will be ignored, as if they didn't exist.

If you remove the mod it will be as if you had never installed it.

What did you expect, or hope to happen?

I just want to make sure I don't loose the email addresses that I collected through the subscribe to newsletter feature so that I can hopefully convert them to account holders. My site actually really requires more than just an e-mail address to fully benefit the customer. my web-site is http://letsseethemenu.com