Newsletter-Only Subscriptions for v1.3x

Quote:

---

Originally Posted by mvveelen

They are not merged as far as I can see. I checked all the accounts......

There should be an option to select "All Newsletter + all nieuwsbrief-lezer"....... I think I'm not the only one, maybe you can check if this is so on your shops ?

---

I think maybe you're still misunderstanding what each group is.

All Newsletter subscribers is all customers *who have chosen to subscribe* (not all customers!) AND all newsletter only (nieuwsbrief-lezer) addresses.

When you say you checked all accounts, I'm not sure you checked the place I mean. You can't look at the Subscription Manager for this info, because it will just show as C for customer (which again, does NOT mean subscriber)

Go into the profile for each customer (Customers -> Customers -> Edit) , and at the bottom of the profile under the Options heading and look at the Newsletter dropdown menu. If *every single* customer is set to Subscribed (I find it hard to believe that is the case because I've never seen every customer choose to subscribe in any site I've ever run. Many don't want to.) -- then I do not know what the problem is. And I apologize for sounding so sure I'm right. :D

But -- I'm betting you'll see that a few of your customers are set to Unsubscribed.

If you want to send a newsletter or email to all customers (even those who are set to UNSUBSCRIBED) and all newsletter subscribers, you'll have to do it in multiple parts -- one to All Customers and one to each newsletter only subscriber.
Just know that if you have a customer who has chosen NOT to subscribe, and you send them a newsletter, you may face angering a customer, or losing a customer.

If you want to send a newsletter or email to all the people (whether customer or subscriber only) who HAVE subscribed the All Newsletter Subscribers will cover it.

Not sure if I understand you correct, but I only want to send all customers and nieuwsbrief-lezers who are subscribed. Not the ones that don't want to receive a newsletter.

So I can select all newsletter subscribers (easy), but how can I send all the nieuwsbrief-lezers with just one "click" ? They are all listed seperately, but not as a group ?

Quote:

---

Originally Posted by mvveelen

Not sure if I understand you correct, but I only want to send all customers and nieuwsbrief-lezers who are subscribed. Not the ones that don't want to receive a newsletter.

So I can select all newsletter subscribers (easy), but how can I send all the nieuwsbrief-lezers with just one "click" ? They are all listed seperately, but not as a group ?

---

The nieuwsbrief-lezers are already included in All Newsletter Subscribers -- that's what that group is. It's all the people (both customers who chose to subscribe and the newsletter only people) that want to get the newsletter.

Everyone that you can send mail to is listed separately *in addition* to being part of the different groups, I'm guessing in case you wanted to send only to one person. The nieuwsbrief-lezers are noted as such in that list only because you don't have their name on file to display, where the customers have given you that information. The only thing you know about nieuwsbrief-lezers is their email addresses.

Quote:

---

Originally Posted by mvveelen

So I can select all newsletter subscribers (easy), but how can I send all the nieuwsbrief-lezers with just one "click" ? They are all listed seperately, but not as a group ?

---

Sorry didn't quite catch this when I first answered you (I wasn't fully awake).

On my sites, when I go to either Send Email or Newsletter and Product Notifications Manager to send a message, I see a group called Newsletter-only Subscribers.

Why that's not in your list I'm not sure. My only guess is that maybe you're running an older version of Newsletter-only (I only have the latest release installed, so I can't say if this is something missing from older versions.)

Hello!

My shop opens in about 3 weeks. I am running ZC 1.3.7 and installed the Nov 14 2006 v1.3.6 2.0.6 version on a test site and it works fine. My question is should I wait for the new release? or roll with the older version?

If it's working why wait? I'd almost put money on the next release not being available for a long time if you wait, but if you go ahead, it will be out the next day! It's the Zen Cart way! :laugh:

Quote:

---

Originally Posted by sparrish

Okay, I've tested it out, and it works... mostly. There seems to be some sort of issue with the unsubscribe page. When the customer unsubscribes, they ARE removed from the database, but instead of going to a page to verify that they have unsubscribed, I got this error:

Code:

---

1065 Query was empty
in:
[]

---

---

I have fixed this error. Fixed file attached. Replace /includes/modules/pages/unsubscribe/header_php.php with it.
I havn't tried all test cases so ymmv.
This is a 2.07 error so don't use this file if you're using 2.06.

TosumaBen, I got a similar error recently on the unsubscribe page, on 2.06 I believe, but traced it to the query factory queries stored in the database having soft end of line characters in some of the database strings. Removed these and all was well. Don't know it is related.

Rgds,

Quote:

---

Originally Posted by Chuckl

TosumaBen, I got a similar error recently on the unsubscribe page, on 2.06 I believe, but traced it to the query factory queries stored in the database having soft end of line characters in some of the database strings. Removed these and all was well. Don't know it is related.

---

This would be a different error as it resulted from a curly brace that moved in the update from 2.06 to 2.07.

This is just what I was looking for. The installation seemed to be going well until I tried to install the box in the custom header:

Warning: main(includes/templates/template_default/templates/tpl_subscribe_header.php) [function.main]: failed to open stream: No such file or directory in /home/.../includes/modules/CUSTOM_TEMPLATE/subscribe_header.php on line 20

executing:
<?php
// BEGIN newsletter_subscribe mod 1/1
if(defined('NEWSONLY_SUBSCRIPTION_ENABLED') &&
(NEWSONLY_SUBSCRIPTION_ENABLED=='true') &&
(NEWSONLY_SUBSCRIPTION_HEADER=='true')) {
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_SUBSCRIBE_HEADER));
}
// END newsletter_subscribe mod 1/1
?>

It is going to templalte_default rather than the CUSTOM_TEMPLATE, I think.
Can you advise?

Thanks!
Mary

Hi all,

How do i make it so its a blank template and i can put my own html in the newsletters without the tables, writing and logo been there already?

Thanks

You can add an image to the newsletter by doing copying the file I have attached

edit the section below to match your domain and image location use the image size of 125x90 for best results

Code:

---

define('BOX_SUBSCRIBE_DEFAULT_TEXT', '<img src="http://www.yourdomain.com/images/newsletter/subscribe.jpg">');

---

If you have any kind of php or coding knowledge you can add whatever you desire to.

When updating Email Address of a customer through shop front end website you get a problem.
Email Address shows up as

HTML Code:

---

[email protected]'[email protected]

---

I think this code is the problem, but I am not sure how to fix it with the weird colon prefixes.

HTML Code:

---

          $sql = "UPDATE " . TABLE_SUBSCRIBERS . " SET
                        email_address = :emailAddress'" . $email_address . "',
                        email_format = :emailFormat'" . $email_format . "'
                        WHERE customers_id = :customersID";

---

UPDATE:
I removed the :emailFormat and :emailAddress, fixed my problem. Also need to DELETE existing records that match the new email address when they are NULL customers_id to avoid "duplicate key" errors. And if you add/import an email address via ADMIN which already exists as a customer address you will cause trouble, there needs to be code to check for that.

Is it possible to remove the "HTML" & "TEXT-Only" plus the corresponding buttons from this module? If so, can the internal settings default to html for all customers?

Thanks!

Quote:

---

Originally Posted by MeltDown

Is it possible to remove the "HTML" & "TEXT-Only" plus the corresponding buttons from this module? If so, can the internal settings default to html for all customers?

Thanks!

---

HTML is the default option so if you just hide the form buttons in the subscribe and update account areas it would suffice.

Quote:

---

Originally Posted by tez

HTML is the default option so if you just hide the form buttons in the subscribe and update account areas it would suffice.

---

Thanks for responding, Tez. Could I impose on you for a bit more detail? I've been digging around but this is a pretty beefy module and I'm feeling a bit out of my league. What steps would I follow to make this change?

Thanks again - Tim

If you are experiencing problems with the header display it's because the template file is not referenced. Fix:

Open: root/includes/modules/MYTEMPLATE/subscribe_header.php

Replace: (Line 20)

PHP Code:

---

require($template->get_template_dir('tpl_subscribe_header',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_subscribe_header.php'); 


---

With:

PHP Code:

---

require($template->get_template_dir('tpl_subscribe_header.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_subscribe_header.php'); 


---

Error is the missing .php extension on the first tpl_subscribe_header.

Cheers,

Bjorn

Does this work with 1.3.7? Is there a lot of modifications to make it work if it doesn't?

Thanks,
Kelly

Yes it works with 1.3.7, i just installed it yesterday and I am Modded out!! hehehe

Thanks. I will try it. :smile:

hi! every may i know how to make it defult in html format when ppl usng sidebox subscribe newsletter? cos i can't find out where is the setting located .. it only show me text for mat as a deafult .. :S

Quote:

---

Originally Posted by MeltDown

Is it possible to remove the "HTML" & "TEXT-Only" plus the corresponding buttons from this module? If so, can the internal settings default to html for all customers?

Thanks!

---

I'm still unable to resolve this issue. I now know from Tez that:

Quote:

---

HTML is the default option so if you just hide the form buttons in the subscribe and update account areas it would suffice.

---

But I still haven't been able to determine what steps to follow to make these changes. Any help would be greatly appreciated!

Tim

Hi NG,

Have just loaded your excellent Newsletter Subscribe and all appeaed to be OK. I then did a test to myself, by putting my own email in the box and sending and received the confirmation email immediately. Then I clicked the link on the mail and it took me back to my site on an error page. The same thing happened when I used another email address. It does not seem the new email addresses have been stored either because the confirmation process failed. If you or anyone could take a look I'd be very grateful for any advise. The site is http://www.saulsaddlery.com/store and the newsletter box is on the bottom left side.

Many thanks,

Rob

Hi All,

To update my problem, the two emails I have entered in the newsletter box are listed as 'confirmation pending. So it is just the return confirmation which is not working. The link to click (it it helps) was:

http://saulsaddlery.com/store/[email protected]

hope this throws a bit more light on it,

Rob

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.

I can't seem to search my way to an answer in this thread and I apologize if this question has already been answered. I currently have this module installed and its working great.

My question is: how can I add rows to the "subscription_manager.php" page? Currently, the page shows 20 customers, however, on my 24" monitor there is 2/3 of the page that is left empty. I have looked at every line of code in the file and can't find what I'm looking for.

Thanks guys!

Can't test it as I don't have enough subscribers to the new site but, using Configuration in the Admin, the second item under maximum values may be what you need.

Set "Search Results Per Page" to whatever value works for you. Be advised that, not only does this set MANY items in the admin, it also sets the max in Featured Products for the catalog.

Quote:

---

Originally Posted by dbltoe

Can't test it as I don't have enough subscribers to the new site but, using Configuration in the Admin, the second item under maximum values may be what you need.

Set "Search Results Per Page" to whatever value works for you. Be advised that, not only does this set MANY items in the admin, it also sets the max in Featured Products for the catalog.

---

Thanks a lot for your suggestion. That did the job, and I haven't found anything that it adversely affected elsewhere.

Thanks again!

Hi,
I have a problem with the Subscription Date.
If someone signs up for just the newsletter the date is fine, BUT if they signup as a customer the date today is 11/30/2036 under Subscription Manager and the date is the right date under Customers.

I'm sure this must be something simple but I cant find where the date comes for.

Can anyone help?

There is two images below first is the Subscription Manager, second is Customers.

Search this thread, the fix is in here, what version you running? The newest one?

<rant>
This is one of the reasons I don't like mods that have been taken over without leaving the original in place. What I wouldn't give to be able to compare NotGoddess's version with that of sparrish.
</rant>

NotGoddess started the mod and (apparently) dropped off the map. sparrish "took over" but modified many things in the original.
Folks are having problems with the version created by sparrish that were occurring in NotGoddess's earlier version.
NotGoddess started an attempt to fix the problem in post #275 of this thread but only had a quick fix.

Quote:

---

update subscribers set subscribed_date = now() where subscribed_date = '0000-00-00';

---

Run that sql update and the dates will change for you. For some reason, the system inserts a null versus a correct date in the situation you mentioned.
Sorry I can't be of mere help. Wish either NotGoddess or sparrish would return.

Quote:

---

Originally Posted by knuckle-101

Search this thread, the fix is in here, what version you running? The newest one?

---

Thanks for your reply.
I am using the latest one from the downloads section.
I have been scanning this thread but 44 pages.

Quote:

---

Originally Posted by dbltoe

<rant>
This is one of the reasons I don't like mods that have been taken over without leaving the original in place. What I wouldn't give to be able to compare NotGoddess's version with that of sparrish.
</rant>

NotGoddess started the mod and (apparently) dropped off the map. sparrish "took over" but modified many things in the original.
Folks are having problems with the version created by sparrish that were occurring in NotGoddess's earlier version.
NotGoddess started an attempt to fix the problem in post #275 of this thread but only had a quick fix.Run that sql update and the dates will change for you. For some reason, the system inserts a null versus a correct date in the situation you mentioned.
Sorry I can't be of mere help. Wish either NotGoddess or sparrish would return.

---

Thanks for replying, I will give that a try tomorrow on my test server first.

So don't we anyone to work on this contribution.

Woody619,
The cause of your woes is an 'omission in the code' in /includes/modules/your_template/create_account.php around line 330.

Change:

$sql = "INSERT INTO " . TABLE_SUBSCRIBERS . "
(customers_id, email_address, email_format, confirmed)
VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . $email_address . "', '" . $email_format . "', '1')";


to read:

$sql = "INSERT INTO " . TABLE_SUBSCRIBERS . "
(customers_id, email_address, email_format, confirmed, subscribed_date)
VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . $email_address . "', '" . $email_format . "', '1', now())";

Rgds,

Chuck

Quote:

---

Originally Posted by MeltDown

I'm still unable to resolve this issue. I now know from Tez that:

But I still haven't been able to determine what steps to follow to make these changes. Any help would be greatly appreciated!

Tim

---

Edit /includes/templates/your_template/sideboxes/tpl_subscribe.php and remove the following

if(EMAIL_USE_HTML == 'true') {
$content .= ' <br /> <label>' . zen_draw_radio_field('email_format', 'HTML', true) . ENTRY_EMAIL_HTML_DISPLAY . '</label>';
$content .= ' <label style="white-space:nowrap">' . zen_draw_radio_field('email_format', 'TEXT', false) . ENTRY_EMAIL_TEXT_DISPLAY . '</label>';
}

The customer default email format is set in Admin-Configuration-Customer Details.

Rgds,

Chuck

Quote:

---

Originally Posted by Chuckl

Woody619,
The cause of your woes is an 'omission in the code' in /includes/modules/your_template/create_account.php around line 330.

Change:

$sql = "INSERT INTO " . TABLE_SUBSCRIBERS . "
(customers_id, email_address, email_format, confirmed)
VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . $email_address . "', '" . $email_format . "', '1')";


to read:

$sql = "INSERT INTO " . TABLE_SUBSCRIBERS . "
(customers_id, email_address, email_format, confirmed, subscribed_date)
VALUES ('" . (int)$_SESSION['customer_id'] . "', '" . $email_address . "', '" . $email_format . "', '1', now())";

Rgds,

Chuck

---

Thanks Chuck, nice one that worked a treat, thanks for helping.

Peace

Woody

Quote:

---

Originally Posted by Chuckl

Edit /includes/templates/your_template/sideboxes/tpl_subscribe.php and remove the following

if(EMAIL_USE_HTML == 'true') {
$content .= ' <br /> <label>' . zen_draw_radio_field('email_format', 'HTML', true) . ENTRY_EMAIL_HTML_DISPLAY . '</label>';
$content .= ' <label style="white-space:nowrap">' . zen_draw_radio_field('email_format', 'TEXT', false) . ENTRY_EMAIL_TEXT_DISPLAY . '</label>';
}

The customer default email format is set in Admin-Configuration-Customer Details.

Rgds,

Chuck

---

Beautiful - That did the trick. Thanks Chuck

Question: When signing up for a newsletter account, it is defaulting to text instead of html. In my admin/config/email it is set to default to HTML and altering the Admin-Configuration-Customer Details doen't seem to have any effect. Any idea how to force an HTML default?

Thanks again - Tim

Tim, Yes, I think it is in

/includes/modules/pages/subscribe/header_php.php,

about line 33, there's a 'TEXT' there that should be 'HTML'.

Hopefully that will force the issue.

Rgds,

Chuck

Quote:

---

Originally Posted by Chuckl

Tim, Yes, I think it is in

/includes/modules/pages/subscribe/header_php.php,

about line 33, there's a 'TEXT' there that should be 'HTML'.

Hopefully that will force the issue.

Rgds,

Chuck

---

Worked like a charm!

Thanks for taking the time to help me out, Chuck. This issue has been one of those minor annoyances that I've really wanted to check-off the ever-expanding 'to-do' list.

Thanks again - Tim

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/

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.

Quote:

---

Originally Posted by X@vier

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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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.

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!

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.

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.

Quote:

---

Originally Posted by DrByte

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:

Code:

---

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:

Code:

---

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.

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.

Quote:

---

Originally Posted by dbltoe

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

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.

So I should delete all the files associated with the mod again and reinstall? Ok, I'll try that. Thanks.

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.

Quote:

---

Originally Posted by DrByte

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:

Code:

---

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:

Code:

---

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.

Somehow I have gotten this to work - after my previous QUOTA issue. I tried again and based on the error message, added the includes/templates/YOUR_TEMPLATE/templates files to the template_default/templates folder as well as to mine.

Really, I have not much of a clue what I'm doing. It's just trial and error!

But I'm glad I've gotten this to work. I hope these other probs get resolved too b/c this is such a great add-on.

davale,
check out post 428, It fix the 1267.

You will find shortly after that that you will need to do the fix in 431 as well.

Thanks for your help Virtualahmad,
I deleted all the files and reinstalled the mod. Still no sidebox. I noticed if I add the subscribe.php file to my Sidebox folder, I'm able to choose the subscribe sidebox in Admin/Tools/Layout Boxes Controller, after I set the box up, it messes up my website. So I have to remove it and add it to my YOUR_TEMPLATE file which now it doesn't show up in Admin/Tools/Layout Controller as an option.

Is there anything else I can try?

when you say "YOUR_TEMPLATE" folder, is that the actual name of the folder you are putting the file in ?

Just using the "Your_Template" as provided in the mod. Mines is my own site name. This is where I added Subscribe.php and all my overrides into.

you should be adding all the files that are currently in the "your_template" folder to whatever your template folder is. So for example, if you FTP to your site, and look in the /includes/templates/ folder, if you have "template_default", "classic", "your_template", and "trustit", and you are using the "trustit" template, then all your files should be put in the corresponding "trustit" template folders.

unless I am misunderstanding what you are saying...

Big Thanks to Virtualahmad.
I now have my Newsletter Subscribe Sidebox. :clap:

One last question(hopefully)...the box to add your email address isn't wide enough. It seems to cut off the word address. Is there a way to widen this? Thanks.

Hello. I'm using the mod 2.0.6 in ZC 1.3.0.2, and it works perfect but only one problem, after i push the button in the sidebox i get the comfirmation text but my sideboxes in the right go outside the design

http://www.prime-records.com/shop/

somehow is to wide, is any way to fix this problem

THX

Has a solution for removing subscribers been found yet? I have to remove subscribers manually using PHPmyAdmin. When you try to delete someone via the software, it asks you if you wish to delete, and when you confirm, goes back to the list as though it deleted them, but it does not remove them.

Anyone have an idea?

Delete subscriber works fine in all systems on which I have it installed. The only test in the code is for admin 'demo' mode, i.e. whether the person requesting the delete is a full admin or not. If true the delete is ignored.

Thats odd. I am a full admin, and this has never worked from the time it was installed. Every other function works fine, but deleting subscribers via the admin interface never has.

Where in the code is the 'demo' mode info? I went through all the code, and couldn't even find where it did the SQL to remove the subscriber.......thats why I'm puzzled.

What version are you using, I'm assuming 2.06 or 2.07?
Look in /admin/subscription_manager.php, case statement lines 110-129.

Quote:

---

Originally Posted by Chuckl

What version are you using, I'm assuming 2.06 or 2.07?
Look in /admin/subscription_manager.php, case statement lines 110-129.

---

I'm using 2.06. Is there a 2.07? I didn't see it in the downloads or on the website. Found the code. I noticed it was checking subscription date, and my DB had the zero subscription date, so I updated that in my database to 1-1-2007.

I went in again to admin. The first email on the list happened to be a test email I subscribed today to test this. I selected it, and told it to delete, and it removed it from the list showing. Good stuff. So I searched for the second one to delete, found it, and with that the only one showing (from the search). Deleted it, and then searched it again. It was still there. So I searched the first one I deleted. Also still there.

I am hugely puzzled here. I have no errors in my server logs, and no error returns in Zencart. It *looks* like it is deleting, but a search after deleting shows the record still there.

I never get the success message when deleting. All subscribers are showing confirmed, and have sub dates of 1-1-2007. I am the admin on the site, admin demo is off.

Just to make sure it wasn't something I did, I reloaded all the original 2.06 code from the zip file, right down to the email templates before I did all this........

Yes there is a 2.07, may well be a beta release however, don't remember to be honest, and minimally different to 2.06.
Minor point, I never see a success message, but the entry disappears from the list. Could just be refreshing too quickly.
At the risk of stating the obvious, does your Zen Cart DB user have delete priviledges/permissions on that table in that database?
Other than that, all I can think of is caching or persistent connections or similar. The code is hardly very complicated, just - if confirmed and not demo set, delete the entry.

Quote:

---

Originally Posted by Chuckl

Yes there is a 2.07, may well be a beta release however, don't remember to be honest, and minimally different to 2.06.
Minor point, I never see a success message, but the entry disappears from the list. Could just be refreshing too quickly.
At the risk of stating the obvious, does your Zen Cart DB user have delete priviledges/permissions on that table in that database?
Other than that, all I can think of is caching or persistent connections or similar. The code is hardly very complicated, just - if confirmed and not demo set, delete the entry.

---

Yep, I've got delete/create/etc. permissions (I'm the site designer). I don't know about refreshing too quickly, I just let the site do that when I delete the entries. I know what you mean about the code, it *is* simple! I haven't made any gross changes to the Zen Cart code, and definitely didn't mess with persistent connections. Caching? I'm not sure how that would affect it.

::sigh:: Frustrating!!!

By refreshing too quickly, I meant that the server I was testing on was 2 yards away on a direct network connection, so any message would have flashed by too quickly for me to see.
On the caching side - clutching at straws really, the thought that it might be returning a cached page with the info still there, or that the DB writes are writing to cache, but not propagating out to the DB.
A couple of judiciously placed debug writes or echo statements to ensure that the code is being executed?

I tested newsletter subscribe and received a confirmation email which required me to confirm. For some reason the link took me back to my home page and not a confirmation page. Am I missing a file?

Thanks
http://www.foxxydiva.com/fashions

Quote:

---

Originally Posted by Chuckl

By refreshing too quickly, I meant that the server I was testing on was 2 yards away on a direct network connection, so any message would have flashed by too quickly for me to see.
On the caching side - clutching at straws really, the thought that it might be returning a cached page with the info still there, or that the DB writes are writing to cache, but not propagating out to the DB.
A couple of judiciously placed debug writes or echo statements to ensure that the code is being executed?

---

Nope, not returning a cached page, I checked the database via PhpMyAdmin, and the info was still there.

I tried overwriting the files, in case there was a glitch somewhere, but it still isn't deleting when I remove someone via the admin interface.....

Installed everything as carefully as possible... but perhaps I skipped a step. I'm getting this error :

1054 Unknown column 'subscribed_date' in 'field list'
in:
[REPLACE INTO subscribers ( customers_id, email_address, email_format, subscribed_date ) VALUES ( '2', '[email protected]', 'HTML', NOW() )]
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.


I'm pretty desperate to get the newsletter installed, so any help is greatly appreciated.

After hitting the Back button, I see this...


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





Subscription Management http://rickrushart.com/admin/include...ton_remove.gif http://rickrushart.com/admin/include...bscription.gif | http://rickrushart.com/admin/include...scriptions.gif | http://rickrushart.com/admin/include...ton_import.gif Status: C=Customer N=Newsletter-Only Subscriber P=Pending Confirmation

All of the files have been uploaded, and mods made.

When I hit the 'install' button, the page goes to a blank white, with this left as the address.

/admin/subscription_manager.php?action=install

Going back to the page to install again, only gives the same result.

The database is not being updated. Do you have the necessary SQL that I can manually run thru phpMyAdmin?

That or any suggestions as to what might be wrong. Thanks.

NM. Problem fixed.

I'm still desperate for help... We're about to kick off an advertising campaign and having the newsletter would be awesome.

To refresh my situation, I'm getting the following error...


When I click 'SEND' on a Newsletter, I get the following error :

1054 Unknown column 'confirmed' in 'where clause'
in:
[SELECT email_address as customers_email_address FROM subscribers WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address ]
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.

Any help would be greatly appreciated...

I installed the newsletter mod, now it breaks my page when you try to subscribe. Test for yourself here: www.axcelsports.com/store

Can someone please help with this? Any idea why it would do that?

BradSmith, in your first post above, you refer to an error in a SQL statement - a 'Replace'. Where is that to be found in the Newsletter Subscribers mod? Replace can be dangerous, Update might be safer.

1054 errors are caused by running MySQL 4 code on MySQL 5. A search on the error in the forums will give several solutions.

On a closer look, your error seems to be somewhat self inflicted. The Replace did not set a value for the confirmed column, and the default value is 'NULL'. Edit that to '1'.

Changing the Confirmed Column Value from NULL to 1 needs to be done from the database by editing a table there, right?

I suppose it's a tad obvious that I've never been involved in this sort of thing before, but I was sort of pushed into the whole web developing thing.

Yes, you can edit the table with phpmyadmin or similar, or you can use a table update statement.

e.g. from your earlier example

UPDATE subscribers SET confirmed = '1' WHERE customers_id = '2';

or

UPDATE subscribers SET confirmed = '1' WHERE confirmed = NULL;

the sidebox is not showing in my tools-Layout boxes controller?
Everything is upload correctly, not sure what is going on?

Quote:

---

Originally Posted by Chuckl

BradSmith, in your first post above, you refer to an error in a SQL statement - a 'Replace'. Where is that to be found in the Newsletter Subscribers mod? Replace can be dangerous, Update might be safer.

---

I don't know the answer to this question... I believe I am getting these errors because the persons who ran this site before me, had installed a Newsletter Mod and it's remnants may be conflicting with this.

I've saved all of our subscribers' emails in case I have to start fresh... I'm so far over my head I have no idea what to do. I've opened up the database, only to realize I had no idea which table I was needing to edit.

Any further help on this will be appreciated - I realize it's probably irritating to have to help a guy along like this, but I'm afraid I'm just clueless.

It is the subscribers table you are interested in. In there is a column called 'confirmed'. Most of the entries will be '1', but one at least will be a Null - Empty - Blank. Change it to 1.

hi, i am having issues with this mod.

I installed, and take a look at my right sidebox: http://www.lightswitchclothing.com/catalog

It's looking for something and not finding it.

Also, if you just click where the button SHOULD BE, i get these errors:

Warning: main(includes/templates/template_default/templates/tpl_subscribe_header.php) [function.main]: failed to open stream: No such file or directory in /home/lightswi/public_html/catalog/includes/modules/lavender/subscribe_header.php on line 20

Warning: main(includes/templates/template_default/templates/tpl_subscribe_header.php) [function.main]: failed to open stream: No such file or directory in /home/lightswi/public_html/catalog/includes/modules/lavender/subscribe_header.php on line 20

Fatal error: main() [function.require]: Failed opening required 'includes/templates/template_default/templates/tpl_subscribe_header.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/lightswi/public_html/catalog/includes/modules/lavender/subscribe_header.php on line 20

Does anyone know whats going on here? Seems to have an issue with the subscribe_header file line 20 which is this:

PHP Code:

---

require($template->get_template_dir('tpl_subscribe_header',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_subscribe_header.php'); 


---

thanks.

The mod has a templates folder called YOUR_TEMPLATE that should be renamed to the name of the template you are using before copying the files onto the server.

You can get rid of the error message by giving it what it wants -

includes/templates/template_default/templates/tpl_subscribe_header.php No such file or directory

Put a copy of tpl_subscribe_header.php from the mod YOUR_TEMPLATE folder into the /includes/templates/template_default/templates folder on the server, or if you prefer not to use the template_default folder, in the templates folder inside the folder of your store template.

Hello there,
Any help would be appreciated - Please take a look at the screenshot, for some reason the subscribecontent is not being included in the subscribe container, causing this strange look,

Also, how can I make the color baby blue instead of white in back of the letters?

Maybe this is related to my 1st issue.

Thanks,
Tatiana

Quote:

---

Originally Posted by Chuckl

The mod has a templates folder called YOUR_TEMPLATE that should be renamed to the name of the template you are using before copying the files onto the server.

You can get rid of the error message by giving it what it wants -

includes/templates/template_default/templates/tpl_subscribe_header.php No such file or directory

Put a copy of tpl_subscribe_header.php from the mod YOUR_TEMPLATE folder into the /includes/templates/template_default/templates folder on the server, or if you prefer not to use the template_default folder, in the templates folder inside the folder of your store template.

---

Ok, I did that, but nothing has changed. I have no idea what the heck is wrong here. Hmmm..

hey, ok i did get rid of the error. but why am I still having the other issue where its saying:

BOX_SUBSCRIBE_DEFAULT_TEXT

HEADER_SUBSCRIBE_BUTTON


I renamed the folders for my template. so, not sure whats up with this.

thanks.

ok, I finally figured it on on my own. ugh. what a nightmare.

thanks for the help people.

Hello,

I have a client whom I've setup this module for. She says when she goes into the HTML editor to make changes to her newsletter, she is not able to edit the fields for Image URL & Alternate Text ,...etc.

Do you know why this might be disabled for her?

Also...as a second question. When she sends a test to Administrator it send in TXT format instead of HTML. There is no where to specify for admin accounts the email preference. But when I sent a test to administrator (which is a separate account) it sends in html.

Anyone know why this might happen?

Tracy

sorry what I meant to say in the third paragraph was that when she logs in with her admin id...it sends in TEXT format, when I login with my admin id it sends in HTML.

tracy

Is there a way to display Newsletter Subscribe email input form like on a myspace profile or a site outside zen-cart? So people can sign up outside of the shopping cart.

basically Like a email form that links to the mods function recording their emails in the zen-cart system? Is this possible....?

Thanks to Bjorn, back on page 42 for fixing the header link for NLS, an added bonus of this is that on the "index.php?main_page=subscribe" page, the email window now appears under the warning text (please try again-not enough characters)

BTW:

With NLS installed is there a way to link/goto this page "index.php?main_page=subscribe" without the "please try again" warning text?

I wanted to make a link to this page.

Is this just not possible?

Given there are no responses to the question I guess either it's not possible or I'm not being clear with my question.. not sure. I'm sure it can be done some how with simply using input forms right? Where would you aim the forms process to so it could record the email in zen-cart?

Let me know if anyone has a idea how to do this.

Thanks.

Quote:

---

Originally Posted by shackle

Is there a way to display Newsletter Subscribe email input form like on a myspace profile or a site outside zen-cart? So people can sign up outside of the shopping cart.

basically Like a email form that links to the mods function recording their emails in the zen-cart system? Is this possible....?

---

Just go to your index.php?main_page=subscribe page and copy the <form>...</form> code.

I've searched the forums for help but no answers yet. Why is it when someone registers as a customer on my site it shows 11/30/2036 on my Subscription Management Admin Screen?

Has anyone experienced this issue after installing the Newsletter-Only subscriptions mod? If so, how was it resolved?

I'm using the current 1.37 version of Zencart.

Thanks for your help.

Quote:

---

Originally Posted by tez

Just go to your index.php?main_page=subscribe page and copy the <form>...</form> code.

---

Yeah silly me( I didn't think it would be that easy lol) I figured that would work just not sure. For anyone else wanting to do this all you have to do is right click "view page source" then find the subscribe sidebox <form> ... </form> like said above.

This works flawlessly.

Quote:

---

Originally Posted by Robbyn7

I've searched the forums for help but no answers yet. Why is it when someone registers as a customer on my site it shows 11/30/2036 on my Subscription Management Admin Screen?

Has anyone experienced this issue after installing the Newsletter-Only subscriptions mod? If so, how was it resolved?

I'm using the current 1.37 version of Zencart.

Thanks for your help.

---

I have this problem too. The only mods I have is GC. I have the lastest version of Zen 1.37.

Anyone?

Login is showing this too.