Newsletter-Only Subscriptions for v1.3x

[pensive612]

Hey everyone,

For some reason, I tried to send out a Newsletter Subscribers-Only email. And it went to all my subscribers blank! Just the title.

So I would like to test this, but I don't think the SQL query is pulling the Newsletter Subscribe - Test Group email address.

It just says: Newsletter Subscribers-Only Test Group (0)

And I do have an address put in the Config>Email Options.

Does anyone have any ideas, so i can continue trying to figure out what went wrong!

Thanks very much in advance.

[deadeye]

Hi Notgoddess,

When entering an address in the sidebox there is the following error:

The customer receives the confirmation mail and in the admin the mail is added.

Changing the values in Minimum Values doesn't seems to help.

I hope it isn't to much trouble to solve this problem.

Xavier

Anyone else came upon/fixed this issue. I've been trying to, but to no avail. Almost seems like the test variables ($subscribe, $error) aren't global or perhaps the header is getting loaded twice. Something odd.

[deadeye]

Anyone else came upon/fixed this issue. I've been trying to, but to no avail. Almost seems like the test variables ($subscribe, $error) aren't global or perhaps the header is getting loaded twice. Something odd.

I guess the original quote didn't have the error, but basically when you submit to add a newsletter-only subscription. Everything processes and confirmation emails get sent, but the page that loads after the submit indicates success and failure (the email address isn't long enough error). 1.3.7 ZC

[luvsealssoaps]

Hey, thanks for the great mod. Just installed V2.06 on my Zencart 1.36 and it works fine... up until...

Getting the following error when trying to click in the e-mail confirm newsletter-only subscription with a test e-mail:

"Error This email address has not been registered."

That comes up when I do either HTML or Text. In the Subscription Manager, the e-mail address does show up with Status P, but unless I go in and check the box myself, they won't be confirmed.

here's my site, in case any of you want to test it out...

http://luvseals-soaps.com/catalog/

anyone getting this yet? I can just not have folks confirm, but then this kinda misleads them b/c they get an e-mail asking them to confirm.

[chacha-vintage]

Hello! I was excited to find this mod too, but when I go to test it, the confirmation e-mail does not get out to the subscriber. I get this message in my sending e-mail:

Recipient address rejected: Policy
Rejection- --SENDER_QUOTA_REJECTION-- (in reply to RCPT TO command)

When I look on my host's wiki, they have a 100 e-mail per hour quota, which is what would cause this error.

So it has something to do with spam is my conclusion... On another php site, I saw something about adding validation code so that spammers cannot use it, but didn't find the link they referred to...

Anyone have any clue about how to fix this?? Or should I contact my hosting company for advice?

Thanks so much!

[virtualahmad]

Someone else has already posted this issue, but I didn't see a solution, and now I'm faced with the same situation...

I have this and SEO URL's installed. Whenever an email address is entered, it comes back with "Error Is your email address correct? It should contain at least 6 characters. Please try again."

SEO off, it works fine. There are other issues too... for example when the confirmation link is clicked in the confirmation email, it comes up saying "This email address has not been registered."

Anyone have ANY ideas ?

ZC 1.3.7, latest mods from downloads area.

[davale]

Hi NotGoddess,

I'm still having problems with the subscription_manager.php script within extra_functions. They keep giving me the '1267 Illegal mix of collations' error message when trying to send out newsletters. Tried applying the directions in an earlier post by Dr. Byte for hours in all sorts of variants but only ended up with parsing errors. Don't know what to try next.

Option A: ensure that the group entries are delimited using % and , and ' -- like this: '%[email protected]%', '%[email protected]%', '%etc%', '%etc%'

Then change your query to:

SELECT c.customers_email_address as customers_email_address 
FROM customers as c 
LEFT JOIN configuration as q 
  on c.customers_email_address 
  LIKE  q.configuration_value 
WHERE configuration_key = 'EMAIL_FROM' ;

Option B: ensure that the entries are delimited with ' and , --- like this: '[email protected]', '[email protected]', 'etc', 'etc', 'etc'

Then use a query like this:

SELECT c.customers_email_address as customers_email_address 
FROM customers as c 
LEFT JOIN configuration as q 
  on c.customers_email_address 
  IN  (q.configuration_value) 
WHERE configuration_key = 'EMAIL_FROM' ;

Did you try this out with success? If so I would really appreciate it if you could give me directions on how to change the code without wrecking it. I'd really like to start using the newsletter functions of Zen Cart but keep running into this.

[Robbyn7]

I've installed and reinstalled this mod several times and was looking forward to using it but after soing everything as the instructions directed, I have no sidebox. I added everything in the right order and also to my YOUR_TEMPLATES folder. Still no sidebox.
I also notice when I click on Unsubscribe, it takes me to the unsuscribe page but it has no box to enter your email address. Just the regret into and the submit button. Am I missing something. Thanks.

[haredo]

I believe I have the fix for at least the 1267 error generated for some of us with the new version of this mod for 1.3.7

When the mod is installed, it creates the subscribers table and sets the collation of email_address, email_format, and confirmed. That's why one of the collation errors mentions SWEDISH.

All the Admin needs to do is open the subscribers table in phpMyAdmin and edit the email_address, email_format, and confirmed collation fields to match the OTHER collation mentioned in the errror.

Voila!

Please note that this does not addresss any errors other than the 1267 database error after installation.

Take a look at this

[virtualahmad]

Robbyn7, you might want to try be deleting the files on your site, and then reuploading them. Sounds to me that you have a corrupted upload file.