Newsletter-Only Subscriptions for v1.3x

[NotGoddess]

When i go to Subscription Manager and sent a email to a newsletter only subscr. it sents the email fine.
BUT when i do select: Newsletter only Subscr. from the newslettermanager i does not send the email for there is a error: No recipient addresses found in header .

Okay, let me verify what you are saying.
1) You have newsletter-only subscribers.

2) You can click on the 'email' button from there and send email to that individual

3) When you go into Tools -> Newsletter Manager, you're picking this option:
Newsletter-only Subscribers (#)
And that (#) is a number other than 0.

4) When you select that drop-down option and hit 'select' and it goes to the preview screen, you see this in red:
Customers receiving newsletter: #
And again that # is greater than 0 and should match the previous #.

5) You click on 'send mail' and that's when you get the error?

And that it's only the Newsletter-only Subscribers (#) one that gives you the error?

I'm not running into issues on my dev site. Even sending to a 0 group goes okay (it just sends 0 emails). It might be an issue with the imported emails.

-Ng_

[kookiewookie]

right!
If i send mail from Subscription manager all goes fine.
If i send from newsletter manager all goes fine with all options BUT
not the particular selection: Newsletters Subscribers Only!
Then all over sudden there is no emailadres in header even when the 'count' says there is at least one.

[NotGoddess]

right!
If i send mail from Subscription manager all goes fine.
If i send from newsletter manager all goes fine with all options BUT
not the particular selection: Newsletters Subscribers Only!
Then all over sudden there is no emailadres in header even when the 'count' says there is at least one.

Okay, from some testing we were able to discover it's a sendmail-related error.

I'm working on the issue.

-Ng_

[kookiewookie]

Hopefully you find the solution soon; thank you very much!

[NotGoddess]

Got it. I knew it was my scripting somewhere causing the error but thought it was sendmail related. It's actually in the query string used. It's pulling email_address but it needs to be returned as customers_email_address

Use the sql patch tool to do this update:

  UPDATE query_builder set query_string = 'SELECT email_address as customers_email_address FROM TABLE_SUBSCRIBERS WHERE email_format != ''NONE'' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address'
	WHERE query_string = 'SELECT email_address FROM TABLE_SUBSCRIBERS WHERE email_format != ''NONE'' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address';

Be sure to add your dbprefix if needed.
Or use phpMyAdmin to update it.

I'll fix it in the release.

-Ng_

[NotGoddess]

New version fixing the above issue. Version 2.0.5

On my site or soon in contributions.

-Ng_

[barco57]

works like a charm thanks.

now onto my wishlist...... I am trying to figure out to make the process of dealing with subscribers who sign up after we have sent out the newsletter for the month. Would it be possible to track when a newsletter is sent out (set date) and then have a function where new suscribers who have not gotten that newsletter are tracked and grouped in the dropdown so that I can send them the newsletter, say once a week. When the next newsletter is sent to all subscribers it would reset the tracking.

on to another issue subscribe date. We already went over the subscribe date for customers in the zen_subscribers list. No issue but when I go to subscription manager some of the customers early (by date) on in the list have an odd date of subscrition (11-30-2036). These customers also have the 00-00-0000 date in the DB. I suppose the two are related but it seems to have stopped after one of the updates, not sure which one though since I didn't notice this until today after I updated to 2.05

[NotGoddess]

Regarding the first...I'll see what I can do.

Regarding the second, I'll make the next update add a subscribed date for customers-that should resolve that issue.

Can you do me a favor and add these to the wishlist on my site (just go to the article and add as a comment)-it'll help remind me to get them in rather than relying on my ability to scroll through the posts.

-Ng_

[barco57]

ok added them as comments on your site.

[woodlandsprite]

NG: I'm having an "issue" with my cart -
I have found that the Send Email tool does not function if the customer is not subscribed to the newsletter.

I don't know if this was tied to having newsletter only subscriptions added to my cart.

If i get a chance, I'll see if I have space & the ability to do a clean install of 1.3.0.2 with to test, but I thought I'd ask here if anyone else can replicate the problem.

Thanks for this module again, btw. It's fantastic