Newsletter-Only Subscriptions for v1.3x

I just implemented the module. When I try to unsubscribe, I have to log in. Is this how it is supposed to work? How can a customer log in if they just provided an email account and didn't create a customer account?

Hi there,
First of all - Thank you for a great contrubution!

Version 2.2.2 on Zencart 1.3.9h. I got a problem with the confirmation email after a customer has signed up for the newsletter.

When choosing E-mail only, the customer doesn't recieve any link to confirm the subscription.
It works fine if they choose Text-only and they get a confirmation link. (index.php?main_page=subscribe_confirm&confirm=XXXXXX&email=[email protected])

Anyone knows what's wrong?

Thank you in advance!

When a customer that is a newsletter only subscriber tries to create an account, we get an error like this...

1062 Duplicate entry 'stefanie.pr######################' for key 2
in:
[INSERT INTO zen_subscribers (customers_id, email_address, email_format, confirmed, subscribed_date) VALUES ( 34, 'xxx######################', 'HTML', '1', now())]

kwrosenzweig:

When a customer that is a newsletter only subscriber tries to create an account, we get an error like this...

1062 Duplicate entry 'stefanie.pr######################' for key 2
in:
[INSERT INTO zen_subscribers (customers_id, email_address, email_format, confirmed, subscribed_date) VALUES ( 34, 'xxx######################', 'HTML', '1', now())]

In includes/modules/your_template/create_account.php, find the code between // BEGIN newsletter_subscribe mod 1/1 and // END newsletter_subscribe mod 1/1 and try replacing it with:

// BEGIN newsletter_subscribe mod 1/1
// If a newsletter only account exists we update the info,
// but keep the subscription active, and give them a message that to
// change they should do so on their account page (after creation).
    if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') && (NEWSONLY_SUBSCRIPTION_ENABLED=='true')) {
      $check_subscribers_query = "select count(*) as total from " . TABLE_SUBSCRIBERS . "
                    where email_address = '" . zen_db_input($email_address) . "' ";
      $check_subscribers = $db->Execute($check_subscribers_query);
      if ($check_subscribers->fields['total'] > 0) {
        $sql = "UPDATE " . TABLE_SUBSCRIBERS . " SET
                customers_id = '" . (int)$_SESSION['customer_id'] . "',
                email_format = '" . zen_db_input($email_format) . "',
                confirmed = '1' 
                WHERE email_address = '" . zen_db_input($email_address) . "' ";
        $db->Execute($sql);
        $messageStack->add_session('login', SUBSCRIBE_MERGED_NEWSONLY_ACCT);
      } else {
        if (!empty($newsletter)) {
          $sql = "INSERT INTO " . TABLE_SUBSCRIBERS . " 
                  (customers_id, email_address, email_format, confirmed, subscribed_date)
                  VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . zen_db_input($email_address) . "', '" . zen_db_input($email_format) . "', '1', now())";
          $db->Execute($sql);
        }
      }
    }
// END newsletter_subscribe mod 1/1

Thanks for the code kamelion0927, I just installed the subscriber and had the same problem as kwrosenzweig but all seems to be sorted now.
Another question:
I want the subscriber in the footer instead of the header, so I simply used the code from the instructions and put it into the tpl_footer.php. Seems to work so far but is that going to cause any problems in the future?

Cheers

Pacu

I've had mine in the footer for a while and haven't been generating any errors. :)

Thanks for replying, I will stick with it then.

I was looking for the code for Newsletter Subscribe in the footer.
Since you have done it succesfully, could you please send it across.

Thanks

raunharman:

I was looking for the code for Newsletter Subscribe in the footer.
Since you have done it succesfully, could you please send it across.

Thanks

All you do is use the code that goes in the header and put it in the footer instead.

I've installed the mod and it's worked perfectly. However, it's added the word "subscribe" to the site title and at the bottom of the main content area. I removed all the files however the subscribe: keep appearing

How do I get rid of that?! (see site here: http://www.ironsightsfirearms.com

somi97:

I've installed the mod and it's worked perfectly. However, it's added the word "subscribe" to the site title and at the bottom of the main content area. I removed all the files however the subscribe: keep appearing

How do I get rid of that?! (see site here: http://www.ironsightsfirearms.com

Never Mind...I found the problem. Thanks again.

somi97:

Never Mind...I found the problem. Thanks again.

And....
For those following this thread the answer was????

I have a problem with the confirmation link when subscribe in html format.

In the email confirmation for the newsletter the link appears on "TEXT_Only" subscribes but disappears on "HTML" subscribes. Why is this? I found the question throughout this forum but not answers.

Thank you!

Zen Cart version v1.3.9d

I'm having a problem when a newsletter only subscriber creates a customer account. When the submit button is clicked on the account creation page, the following error occurs:

1062 Duplicate entry '[email protected]' for key 2
in:
[INSERT INTO zen_subscribers (customers_id, email_address, email_format, confirmed, subscribed_date) VALUES ( 5, '[email protected]', 'TEXT', '1', now())]

Current setup:
Zen Cart: 1.3.9g
Newsletter Subscribe Version: 2.2.2

Does anyone have any suggestions on what might be the fix for this? Thanks.

Jeff

All emails I send via the admin say "Dear Newsletter Subscriber" instead of "Dear customer's name." Even those to customers who haven't subscribed to newsletters.

I just realized that we installed the latest version of this add-on, which is probably creating this issue.

Does anyone know how I could fix this?

Thanks!
(We use ZC v1.3.9h)

I'm trying to install this mod, but I can't see Subscription Manager under Customers. How come?

msphamtastic:

I'm trying to install this mod, but I can't see Subscription Manager under Customers. How come?
Make sure you have change the admin folder to your custom folder name. Make sure all the files have uploaded correctly.

countrycharm:

Make sure you have change the admin folder to your custom folder name. Make sure all the files have uploaded correctly.

Thank you!!! :clap:
Do you happen to know why the confirmation letter doesn't get sent out?

Thannaree:

All emails I send via the admin say "Dear Newsletter Subscriber" instead of "Dear customer's name." Even those to customers who haven't subscribed to newsletters.

I just realized that we installed the latest version of this add-on, which is probably creating this issue.

Does anyone know how I could fix this?

Thanks!
(We use ZC v1.3.9h)

When I send emails from the admin it doesn't add "Dear anything" to any emails

When I send newsletters from the admin
It uses the customers name correctly if thay have an account.

It only uses "Dear Newsletter Subscriber" for customers who signed up with this mod (and don't have an account)
This mod doesn't collect Customers names so it cannot use them as it doesn't know what the name on the subscriber is!

SincoS:

I'm about to give up on this add on (Newletter Subscribe v 2.1.1)
ive tried everything to install it but can't find the answer.

I receive this error when i click the install button after following the instructions.
I'm using AAMPS with php 5.3.8, ZC 1.3.9, and this is all being done on a localhost server for testing.

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 'TYPE=MyISAM' at line 9
in:
[ CREATE TABLE IF NOT EXISTS zen_subscribers ( subscriber_id int(11) NOT NULL auto_increment, customers_id int(11) default NULL, email_address varchar(96) NOT NULL default '' UNIQUE, email_format varchar(4) NOT NULL default 'TEXT', confirmed varchar(8) default NULL, subscribed_date date NOT NULL default '0000-00-00', PRIMARY KEY (subscriber_id) ) TYPE=MyISAM;]
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.

Maybe there is a common mistake that i made

A bit late, but in case you haven't already found the answer:

Go to admin\includes\functions\extra_functions\subscription_manager.php

around line 114

change ```php
) TYPE=MyISAM;");

to

```php
) ENGINE=MyISAM;");