Newsletter-Only Subscriptions for v1.3x

[chac416]

geeee, i reinstalled the subscribtion, and now i forgot how i fixed the sidebox width issue... which file was that...

nevermind, took the patch file from ur site....

now here's another problem after reinstalling the subscription and installing the subscription manager..

thats what i get when i click on Subscribtion manager in admin...

1054 Unknown column 'confirmed' in 'field list'
in:
[select subscriber_id, customers_id, email_address, email_format, confirmed, subscribed_date from zen_subscribers order by email_address limit 0, 20]
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.

and this when i first opened the admin page

1054 Unknown column 'confirmed' in 'where clause'
in:
[select count(*) as count from zen_subscribers where confirmed= '1' or customers_id >= '1']
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.

[chac416]

okay, i found our why, fields where missing from the database...

can someone look into his database and copy/paste for me the attributes of the following fields (confirmed, subscribed_date) thank u so much in advance

[chac416]

NG,
i have decided to use phplist for sending out my newsletter.
there's one thing i still want to do. i want my subscribers to unsubscribe using ur module not phplist.
i.e. link them back to the unsubscribe page on zencart... can you provide me with the link of the unsubscribe page... thanks lot,

[NotGoddess]

You mean the 'unsubscribe from newsletter' link or the one that goes on the bottom of newsletters?

The former is an option in the cart config 'show newsletter unsubscribe link' (don't have an admin handy here to look up the exact page for you).

The latter, should be the same link, with the email changed to the subscriber's email (or none and they enter their email). It would look something like:

http://yoursite.com/yourstore/index....ge=unsubscribe


-Ng_

[TGS]

I installed the newsletter module and all seems good, except...I am testing the confirm subscription request...in the subscription management section it either says C or N, but never P (pending) when I have not yet responded to the confirm email (during testing).

Did I miss installing something? I think I have the newest version.

[NotGoddess]

No you didn't miss anything. Someone else caught it a few posts back. It's fixed in the release coming tonight (in a couple hours...an evil wonderful friend surprised me with the new book from a fave author and I kinda had to read a couple chapters...or six so got delayed [but I told myself no more til this is done, so it will be quick.] :).

-Ng_

[NotGoddess]

Okay folks, it's up. Apologies for the delay.

I've submitted it to the downloads section, but if there's a delay, you can grab it from my site: http://www.notgoddess.com/scripts/newsletter-subscribe

As ever I must stress - make backups before you install! :)

If you already have v2.0.2 installed, you should see an 'update' button instead of an install button.

This contrib uses the 'create table if not exists' syntax on the subscriber's table, and the 'replace' syntax for the various defines. If you have mysql 4.1+ you shouldn't have a problem. If you do, you'll have to peruse the file and update manually.

Report any issues and I'll get patches out asap.

...I did mention that you should backup first, right?

Enjoy.

-Ng_

[kookiewookie]

Hi!

I have some strange problem with the unsubscribe action on the website.
When i click unsubcribe from newsletter and then the button Unsubscibe
it gives me the message that the emailadres below is unsubscibed....
I did not put in a e-mailadres that should be removed from the list....and offcourse there is no emailaddress showing.

Any idea on this one?

>>> oeps, maybe just have to install the updated version 2.03 , am using 2.02 now.

[NotGoddess]

Do upgrade if you wish, but it's there in 2.0.3 too :) (I guess I should have put out a last call :)

If you edit the template/your_template/templates/tpl_unsubscribe_default.php and change line 14 from:

<?php if (!isset($_GET['action']) || ($_GET['action'] != 'unsubscribe')) { ?>

to

<?php if (empty($unsubscribe_address) || ((!isset($_GET['action']) || ($_GET['action'] != 'unsubscribe')))) { ?>

It will always show the "We're sorry you want to unsubscribe" text for blank emails.

The unsubscribe module is set so if a person enters a nonsense email it'll still tell them it's unsubscribed so people can't use it as a way to suss out emails. That's why it always repeats the email a person enters (in case they misspelled their email).

If people wish I can change that so it gives a 'invalid email' error message instead....3 votes gets it.

[NotGoddess]

I also noted the sorting works wonderfully...until you try to click on a string to edit.
Then it's resetting to the default display.

Also, I'm not sure if it's a 'first record' issue or 'customer' issue but clicking on the first address to edit gives you a blank edit box.

I'll work on both of these tonight and get out a patch.

-Ng_