Newsletter-Only Subscriptions for v1.3x

[horsetags]

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

[lina0962]

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!!

[ftdc]

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!

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

[joyjoy]

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!

[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.

[joyjoy]

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.

[robbinsgj]

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?

[Doodlebuckets]

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.

[1kell]

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