Please see my reply in your other thread...
http://www.zen-cart.com/forum/showpo...1&postcount=15
Regards,
Christian.
Printable View
Please see my reply in your other thread...
http://www.zen-cart.com/forum/showpo...1&postcount=15
Regards,
Christian.
I removed NLS 2.0.6 on my 1.3.7 Zen Cart, to ease my upgrade to 1.3.8a and await a new tested version for 1.3.8a.
I followed the uninstall directions and removed the Subscription manager from admin menu, restored all the core files and deleted the NLS only files.
I am now getting this error when I access admin>Tools>Send email:
I was aware that the remove option in Subscription manager would drop the subscribers database. I have no customers currently so I thought that would be fine, but when I create new customers (newsletter/customers) I still see this error.Quote:
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 'WHERE email_format != 'NONE' and confirmed = 1 and (customers_i
in:
[SELECT email_address as customers_email_address FROM 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.
did I do something wrong?:cry:
My original estimate of a couple of days has slipped somewhat :blush:. I love deadlines. I love the whooshing noise they make as they go by.
It looks like you have missed one of the core files when you were returning them to their original state. You need to double check the files NLS overwrites. Doing the upgrade to v1.38 will give you a clean set of files anyway so you could just do that.
Regards,
Christian.
Thanks for your reply! and thank you for working on this essential mod!
I took your suggestion and double checked the core overwrites that v2.0.6 overwrote and made sure I did successfully replace them with original 1.3.7 core files:
admin/index.php
admin/customers.php
includes/functions/function_email.php
includes/functions/audience.php
includes/modules/pages/account_edit/header_php.php
includes/modules/pages/account_newsletters/header_php.php
includes/modules/pages/unsubscribe/header_php.php
sadly the files are correct, and I still have that error.
I know nothing about MySQL databases, but I compared the current MySql database to my backed up copy and see there is indeed a table missing called subscribe.
In the uninstall directions this is stated :
Which I thought meant it just drop the customers database /info...and go back to regular ZC newsletter biz.....as I have no customers I was not concerned about putting a table back.....but I guess this table is removed (completely, not just customers) and not put back? I think ZC loses functionally::oops:Quote:
Note that the remove option also DELETES/DROPS the subscribers database, so make
sure you have a backup of that table before you remove.
Again I am guessing.
but this table is now missing from my database:
Quote:
-- Table structure for table `subscribers`
--
CREATE TABLE `subscribers` (
`subscriber_id` int(11) NOT NULL auto_increment,
`customers_id` int(11) default NULL,
`email_address` varchar(96) NOT NULL default '',
`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`),
UNIQUE KEY `email_address` (`email_address`)
) TYPE=MyISAM AUTO_INCREMENT=63 ;
--
-- Dumping data for table `subscribers`
--
INSERT INTO `subscribers` (`subscriber_id`, `customers_id`, `email_address`, `email_format`, `confirmed`, `subscribed_date`) VALUES
(2, 8, '[email protected]', 'TEXT', NULL, '2007-04-15'),
(14, NULL, '[email protected]', 'TEXT', 'YXZGdj', '2007-04-15'),
(5, NULL, '[email protected]', 'TEXT', '1', '2007-04-15'),
and so on...
-- --------------------------------------------------------
--
I am going to muddle through my backed up site/Mysql and try to merge the NLS 2.06 into the upgrade of 1.3.8a if it goes in ok, disable it and wait for the upgraded NLS for 1.3.8a
What do you think?:lookaroun
There is one more core file which has an override on it...
includes/modules/YOUR_TEMPLATE/create_account.php
...where YOUR_TEMPLATE should be replaced with the name of your template. If that file exists then take a copy of it (just in case) and then delete it.
The 'subscribers' table is not part of a standard Zen Cart installation, it is used purely for NLS so without NLS you do not need the 'subscribers' table. After checking the file mentioned above I would also do a search through all the .php files for the phrase TABLE_SUBSCRIBERS . When NLS is completely removed TABLE_SUBSCRIBERS should not appear anywhere.
Hope that helps.
Regards,
Christian.
Thanks again Christian, for your speedy help!
I did as you suggested and searched for any left over NLS files..... all NLS files are indeed completely gone from my file set. I still get the error when I access admin>tools>send email.
I searched my database for the error that I mentioned before and found it in the query_builder table as the last line under dumping data for query_builder>
Again I do not know what I am doing, but felt I had nothing to lose so I went into my phpAdmin found this line and deleted it out of database.Quote:
(8, 'email,newsletters', 'Newsletter-only Subscribers', 'Returns email address of all confirmed Newsletter-Only subscribers.', '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', '');
I do not have the error anymore and the cart seems ok, I did notice however, under admin>tools>send email : in the drop down (send to) customer menu there is a "Newsletter subscribers" option, which I don't remember if ZC had before I installed NLS 2.0.6.
Anyway, the whole cart may go up in flames now, but I wanted to trouble shoot this error, if I need to uninstall NLS again.
Did I do the correct thing?
----
Also: I am having trouble merging NLS 2.0.6 into 1.3.8a. I can clearly see the code for NLS when its commented:but I am not skilled enough to differentiate between the other old code and what could be NLS code. Is all the NLS coding commented?PHP Code:
// BEGIN newsletter_subscribe mod 3/3 .................// END newsletter_subscribe mod 3/3
NLS? ex:
admin>customers>line 882 :so...PHP Code:
echo zen_draw_hidden_field('customers_newsletter');
Would it be possible to upgrade to my ZC to 1.3.8a leaving out all the NLS 2.0.6 files, but keeping the NLS Subscription manger/'subscribers' table in the database, until the NLS 1.3.8a files are available for install?
I am looking for the easiest way to upgrade without messing up my site/database, due to my inexperience.
Again thank you for your help....
I just compared the new version of NLS 2.0.9 to my old v2.0.6 and noticed a typo that was mentioned in a previous forum , not sure if it should be carried over into the next version or not, but I thought I should mention it:
http://www.zen-cart.com/forum/showpo...&postcount=509
PHP Code:
require($template->get_template_dir('tpl_subscribe_header',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_subscribe_header.php');
hope this helps....PHP Code:
require($template->get_template_dir('tpl_subscribe_header.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_subscribe_header.php');
I find the newletter only subscrption quite useful but it does have limitations with email control such as bounces. As such we use a product written for us for this purpose. We have a sizable database with an email going out every 3-4 weeks. As a result we get 50-150 bounces each time and when we get 3 in a row we regard these addresses as dead. Any ideas on a bulk delete of these addresses using PHP or SQL (preference is SQL)? A normal delete list is around 100 addresses.
GREAT MOD.
I was wondering how to go about adding to this mod. I want to add 3 or 4 check boxes that will allow the subscriber to choose which newsletter to subscribe to.
Such as
Check Box A = Newsletters regarding new products
Check Box B = Newsletters regarding outdated products, or discontinued products
Check Box C = Newsletters regarding the company only
Check Box D = Newsletters regarding products in development
Any ideas on going about this?
Thanks
Rooster!
Im still testing this mod...
currently if someone wants to unsubscribe they go to the /index.php?main_page=unsubscribe page
They enter their email address and are unsubscribed.
But this page gives everyone the ability to delete any email address they enter :( off the sites NLS list
anyway to tighten this up? so its possible to delete their email and only their email address (perhaps a php generated link in an email sent to them? )
ex:
maybe this more of a request for an future feature.Code:https://YOURSITE.com/index.php?action=unsubscribe&main_page=unsubscribe&addr=delete_only_my_email%40yoursite.com&x=34&y=6
any other way around this?
Hey All,
Just checking in to see if anyone successfully integrated this into ZenCart v1.3.8?
Thanks, JJ
don't believe anyone has but I'm available for the work. I'm waiting for one of my customers who has this mod to get the site upgrade so I can be paid. Nobody needs it or is asking for it yet.
excellent mod, thanks for the hard work!
I have one question though - I've installed the mod and it's working perfectly. however, it's added the word "subscribe" to my site title and at the top of the main content area. How do I get rid of that?! (see site here: http://www.littleturtleknits.com/zencart/ )
I need it, for my own site, and don't have enough PHP/Zen Cart knowldge/experience to integrate it, and worry a lot about making problems for my working site. What would it take for you to do the real/sure thing Zen Cart v1.3.8 upgrade and then make it available to all? Maybe myself and others in need will be able to PayPal you something reasonable for your troubles?
JJ
I don't know how much time it will take. As it is, there is one bug that needs to be fixed, too. It could only be $100 - could be more. I might even have time this week to do it. If I have time on my hands, I could get it done and after receiving enough money to cover time (then releasing it to those who pay something) - then upload it as a free contribution.
jeez... you're greedy... i thought we all try to make zencart better...
not greedy - right now we're in dire financial straits due to my husband's medical problems and his disability has been denied and we can't afford the health insurance.
I do what I can for zen cart - which has included several contributions - including one this morning.
Never assume you know what's going on - life isn't that simple.
Good to hear and thank you for all you have done for everyone.
Now that I've sweet talked you I have a question
As iIuse another program to actually send the emails is there away to do bulk deletes other than through sql statements. Reason is that on 3 consequtive newsletter bounces we delete the email address from our system which we would like to do from this system as well. We can export the dletes as a record to a line text file or a delimited file.
Any thoughts?
Hello everybody,
There are two new versions of the Newsletter Subscribe mod available for download in the contribs section...
http://www.zen-cart.com/index.php?ma...roducts_id=106
v2.0.9a - Bug fix release. Use this version if you are using Zen Cart v1.3.7
v2.1.0 - Compatibility release. This is the version you need to use with Zen Cart v1.3.8.
The features and functionality of the two versions is identical. The only difference is that v2.09a contains modified versions of the ZC 1.3.7 core files and v2.10 contains modified versions of the ZC 1.3.8 core files.
Don't mix the two up, you'll cause weird problems with your Zen Cart installation if you do.
Regards,
Christian.
Greetings All!
New to Zen Cart, and to the Forum. I just installed v1.3.7 (the version that was on my current server; haven't made the jump yet to v1.3.8). Anyway, I also just completed installation of Newsletter Subscribe v2.0.9a. Installation went without a hitch, and all works well. I do have a couple of questions that I can't seem to find answers to:
1) Which files to I edit to change the text on the confirmation screen that appears after subscribing?
2) I thought this was a double opt-in system. I received an email after I subscribed myself, but there was no copy in it; just the following text:
EMAIL_WELCOME
EMAIL_TEXT
EMAIL_CONFIRMATION_TEXT
EMAIL_CONTACT
EMAIL_CLOSURE
Isn't there supposed to be a link in that email that a subscriber has to click on to confirm their email address? And in my Admin, it shows where I subscribed, but it also states that confirmation has not been received, and no newsletters will be sent to my address. If customers have no way to confirm they want to be added to my mailing list, doesn't this defeat the entire purpose of this mod?
Am I missing something here? Did I do something wrong? Or am I just not seeing something that is blatantly in front of me? Any and all help will be appreciated!
Regards,
Bug-Eyed Drewster
P.S. If this has been addressed before, please forgive me - but there are 63 pages to this friggin' thread, and I'm too old, too tired, and too blind to read that much right now.
Hi Drewster,
Sorry it has taken me a few days to reply. Been very busy.
Change the line that says...
In the includes/languages/english/YOUR_TEMPLATE/subscribe_confirm.php file. Where YOUR_TEMPLATE should be the name of the template you use.PHP Code:
define('TEXT_INFORMATION_CONFIRM', 'Thank you for confirming your email address.');
It is a double opt-in system and the email you received should have had some text and a link in it. The fact that you are seeing the EMAIL_WELCOME text rather than a proper message indicates that one or more files have not been uploaded or not uploaded to the right place.
Check that you have renamed all the folders called YOUR_TEMPLATE to the name of the template your are using. Then check that all the files in the includes/languages/english folder and sub-folders have been uploaded correctly.
Regards,
Christian.
Thank you for the updated NLS!:cheers:
First of all... THANK YOU FOR THIS CONTRIBUTION! YOU ROCK!
Now, after installing I seem to have one quite small problem. When I go in to send an individual email to a subscriber (via Customers | Subscription Manager and then click the "email" button for a subscriber) I get this:
Fatal error: Call to a member function read() on a non-object in /home/MYUSERDIR/public_html/admin/mail.php on line 380
Is this related to this contrib or is something else afoot?
THANKS!
Sorry... first rule is post your versions! LOL
Contrib just downloaded this morning so: v 2.1.0
Zen is 1.3.7.1
I bet I need to upgrade... huh? :blush:
Thanks!
Oh ok great... I will try that! Thanks!
Wow, thanks! That worked PERFECTLY!
Again... YOU ROCK!
I installed the Newsletter Module, and while it works great for the newsletter, for some reason it make my Product Images disappear.
Here is a link to a product page
http://mp3travelguides.com/store/ind...&products_id=7
Anyone have any idea why this would happen?
When I switched to the default template, the images still didn't show up.
I am using Zen Cart 1.3.7
The Module I am using is Newletter Subscribe v 2.1.0 for Zen Cart v1.3.8.
I'm guessing this means I should try updating to Zen Cart 1.3.8? It was very bizarre. I uploaded the module and the first time I went to a product page, I got a message about it not finding some file (which I didn't pay attention to, but obviously should next time), then when I refreshed the page, my product page was there, but without the product image.
I have little knowledge about php so I'm not quite sure where I should even begin to look to fix the problem. Any help at all would be GREATLY appreciated.
The v2.1.0 version of the mod is for Zen Cart 1.3.8 and will cause problems if you use it with Zen Cart 1.3.7. For Zen Cart 1.3.7 you need to use v2.0.9a of the mod. So first thing to try is to download v2.0.9a and then install the files that come with that version of the mod, you won't need to do the database bit again.
Regards,
Christian.
I just installed the latest version from the downloads on v1.3.8 zencart. Everything works great except if you go here http://www.giftsofcharacter.com and look at the sidebox, the radio input is not right. The subscribe button and text-only are in the wrong place. I LOVE this add-on and I have looked at the sidebox code, but am not a coder so I don't quite know what to do...Thanks! Amy
I've just looked at the HTML in the sidebox and it is not ideal. It should work okay with a standard Zen Cart stylesheet though. The problem you are seeing is being caused by a style in your stylesheet at about line 248...
That is not in the standard Zen Cart stylesheet and it is causing the radio buttons on the Subscribe sidebox to do strange things.HTML Code:html>/**/body input[type=checkbox], html>/**/body input[type=radio] {
float:left;
clear:both;
}
Regards,
Christian.
As an additional to what I said above....
If you want to stick with your current stylesheet settings then you could try editing includes/templates/YOUR_TEMPLATE/sideboxes/tpl_subscribe.php and change the lines that say...
...to be...PHP Code:
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>';
}
Hope that helps.PHP Code:
if(EMAIL_USE_HTML == 'true') {
$content .= ' <br /> ' . zen_draw_radio_field('email_format', 'HTML', true, 'id="emailhtmlformat"');
$content .= ' <label for="emailhtmlformat" class="radioButtonLabel">'. ENTRY_EMAIL_HTML_DISPLAY . '</label>';
$content .= zen_draw_radio_field('email_format', 'TEXT', false, 'id="emailtextformat"');
$content .= ' <label for="emailtextformat" class="radioButtonLabel">'. ENTRY_EMAIL_TEXT_DISPLAY . '</label>';
}
Regards,
Christian.
Thanks! I think that's what I'll do :o) I really love my template. I also just remembered that the defined pages from the newsletter subscription mod are not showing up in the admin Define Pages Editor. I've uploaded the mod twice, so I don't think I missed anything. How do I get those to show up there? Thanks! Amy
PS For anyone who's using the Apple Zen template, the above line of code should have a second break in it to put the subscribe button down to the next line:
$content .= ' <br /><br />' . zen_image_submit (BUTTON_IMAGE_SUBSCRIBE,HEADER_SUBSCRIBE_BUTTON, 'value="' . HEADER_SUBSCRIBE_BUTTON . '" ');
Otherwise it just sits next to the text-only line :)
Your welcome. Your template does look very nice.
I've had a play with the HTML a bit more and I think the following will probably work best...
Now you come to mention it I seem to remember having the same problem when I first started using it. I'll have a look and see what is going on.PHP Code:
if(EMAIL_USE_HTML == 'true') {
$content .= '<div id="subscribeBoxEmailFormat" style="white-space:nowrap"> ';
$content .= zen_draw_radio_field('email_format', 'HTML', true, 'id="emailhtmlformat"');
$content .= '<label for="emailhtmlformat" class="radioButtonLabel">'. ENTRY_EMAIL_HTML_DISPLAY . '</label>';
$content .= zen_draw_radio_field('email_format', 'TEXT', false, 'id="emailtextformat"');
$content .= '<label for="emailtextformat" class="radioButtonLabel">'. ENTRY_EMAIL_TEXT_DISPLAY . '</label>';
$content .= '</div>';
}
Regards,
Christian.
I've had a look and I remember now what I had to do to get this working. It is because of a feature (bug?) in the Define Pages Editor. If you look at the files that came in the mod download you will see define_subscribe.php and define_unsubscribe.php in the includes/languages/english/html_includes/YOUR_TEMPLATE directory. So you rename YOUR_TEMPLATE to the name of your custom template and upload them to your server. Trouble is the files won't appear in the Define Pages Editor unless you also upload the define_subscribe.php and define_unsubscribe.php files to the includes/languages/english/html_includes directory. Once you have done that it should all work fine and the Define Pages Editor will allow you to edit the files in your custom template directory.
Regards,
Christian.
I've installed the lastest version of this 2.10 on my 1.38a ZC. All my newsletter emails are being sent in duplicate.
I had an earlier version of this mod installed on 1.37 which worked fine. For this version I've overwritten all the files - just copied the new files over to my installation - done the dB upgrade.
Also - clicking on the unsubscribe link in the newsletter doesn't remove the address from the dB.
Any help is appreciated.
Which version of the mod were you using with ZC 1.3.7?
Which audience are you sending the newsletter to?
Does the unsubscribe work if you go to the store front, click the Newsletter Unsubscribe link and enter the email address?
Regards,
Christian.
I don't remember the version number. I installed it about 10 months ago. Probably the best solution here is to uninstall and do a fresh install, but at this point I don't know how to remove the original installation.
I sent the newsletter in two batches, after first testing it with the test group. I didn't notice the test group duplications before I sent out the two big batches. The two batches were 1. Customer account subscribers 2. newsletter only subscribers.Quote:
Which audience are you sending the newsletter to?
I have to split them up like this because my server has an hourly limit.
When I look in the email log, every subscriber received two newsletters.
I tested the unsubscribe function again this morning and it's working now.Quote:
Does the unsubscribe work if you go to the store front, click the Newsletter Unsubscribe link and enter the email address?
I've been testing this more, and found that when I send the newsletter to the administrator only, there is just one newsletter sent out.
When I send the newsletter to my test group each newsletter is sent out twice.
My email logs show two newsletters being sent out to each address, with a delay of about 5 seconds.
I've also tested the mail function sending a message to my test group. No duplicates there, so the problem is with the newsletter mod.
Hi,
I am currently using the Newsletter-Only Subscriptions mod version 2.09a. Installation went very smooth and ussage is very good so far. I have found one problem tough. When someone tries to change his e-mail adress in his account into an newsletter only e-mail adress. He will get this error:
I dont know if this is a mistake on my end or something else.Quote:
1062 Duplicate entry 'minasmax######################' for key 2
in:
[UPDATE subscribers SET email_address = 'minasmax######################', email_format = 'TEXT' WHERE customers_id = 100007]
If someone could help me, it would be appriciated:yes:.
greetings,
Minas
I've been looking through the code but can't see what would be causing your duplicate email issue. Hard to tell if it is a bug in the mod, a bug in ZC 1.3.8 or something that happened during your upgrade process. I'm going to have to give this one some more thought and do some more testing.
Anyone else out there using ZC 1.3.8 and v2.1.0 of the mod experiencing similar issues?
Regards,
Christian.
I'd tend to think it has something to do with the upgrade process, since I've seen other posts here that say ZC 1.3.8 and NLO is working fine for them.
I'd like to start fresh, but since I don't know exactly which version I started with I don't really know how to do an uninstall.
Hi, I have 2 questions regarding this module:
1. How do I bypass confirmation request?
2. How do I make the default email preference of header newsletter to HTML instead of TEXT?
Please advise. Thanks in advance.
I feel like an idiot for asking this but I can't figure it out. What's the url to the page where people go to subscribe? Or is there one? Was this designed just for the sidebox or header?
I am getting an error message when someone tires to subscribe for newsletter only. I'm using zen cart 1.3.8, and version 2.10 of Newsletter Subscribe.
When someone enters in their e-mail address and clicks subscribe, this is the message:
* * * * *
Newsletter Subscription
Thank you for taking a moment to subscribe to our Newsletter.
You'll receive notices of newly available products, special offers, and news of upcoming showings.
Error This email address has not been registered.
Newsletter:HTMLTEXT-Only
* * * * * * *
When I check in my newsletters subscriptions, it doesn't show up. I checked to be sure all of the modules files were uploaded, and they are.
Here's my site:
http://www.tracibunkers.com/zen/
I got it fixed. It seems the pages files were the culprit and it worked after reinstalling them.
But now I have another question. In the e-mail the customer gets, asking them to click on the link to confirm their subscription, it shows the html code instead of just having a clickable link. Where do I fix that?
Thanks!
I just installed a fresh version for 1.3.7 dated as updated Jan 11 2008.
Everything is great except that one bug you said you were working on about the error that people get when they try to update their account, and I also have an import problem: when I tried to import an excel file with one column and in that one column only email addresses exist, I get an error:
Upload failed: The uploaded file exceeds the upload_max_filesize
but the file is about 100k with ten email addresses. What can I do?
Having installed this mod I'm getting the following message when I try to view the Customers page in Admin:
Fatal error: Call to undefined function: zen_get_customers_address_book() in ......./customers.php
Any idea why this has happened please?
Cheers
Patrick
P.S I'm using Zen Cart 1.3.7
where is the comfirmation page located? I would like to change the text but cannot find it.
Thank you
Hello everyone,
I am considering installing this contribution, and before i go through the process of working this into a live shop i have a quick question that I've had a hard time answering in reading the literature for the contribution:
Does this use the same mailing list engine that is supplied with zen cart?
I am trying to decide between this and the PHPlist mod, so if there is anyone that is familiar with both and can help me outline their differences i would be forever grateful. :smile:
The email template...
email/email_template_newsletter_subscription.html
The email define...
includes/languages/english/YOUR_TEMPLATE/subscribe.php
If you mean changing the text on the web page, same as your other defines..
includes/languages/english/html_includes/YOUR_TEMPLATE/define_subscribe.php
I've just installed this mod. Haven't tested it yet. I have a couple of recommendations regarding its installation that I wanted to post first. I assume my points won't have been covered before, otherwise they probably would have been acted on already.
1. Step 4 of the installation guide is misleading. It says to rename the "YOUR_TEMPLATE" subdirectory in includes/templates. It doesn't say to rename any other instances. There are in fact a few other folders, not just within includes/templates, that require going into and changing. I didn't realise this until after uploading it all.
2. In includes\languages\english\html_includes\YOUR_TEMPLATE, there are the two files, define_subscribe and define_unsubscribe. These are obviously designed to be loaded into the Define Pages Editor in admin. This doesn't work. This is because these two files are missing from the directory above. There are no files in includes\languages\english\html_includes, so Zen Cart is effectively not overiding anything. After putting a copy of these two files in the directory above, it works.
Hope this helps.
Hi
Without reading through the 67 pages as I don't have a problem as such to solve - great mod and have used since early inception - can I add a Name box for the subscription?
Thanks for the contrib, getting an error when testing it out, when I enter my email address I get
1054 Unknown column 'email_address' in 'where clause'
in:
[select count(*) as total from mysubscribers where email_address = 'myemail AT x DOT com']
NM fixed it just clicked on remove
Ooh, glad I found this thread. I have v2.10 and Zen Cart 1.3.8a
Customers are reporting these two issues:
1) When trying to login and update their newsletter subscription, they are getting this error.
andQuote:
1062 Duplicate entry '[email protected]' for key 2
in:
[INSERT INTO subscribers (customers_id, email_address, email_format) VALUES ('788', '[email protected]', 'HTML')]
2)Any help?Quote:
Another problem seems to be when a customer receives the newsletter confirmation email and it instructs them to click the link to confirm their email address, it takes them to a page with this error at the top: This email address has already placed a Newsletter-Only subscription.
Thanks!
After following the installation instructions to the point where I should see a "Subscription Manager" option under the "Customer" tab, the option does not appear. Where am I going wrong?:(
Problem Solved after re-installing contribution. Thank you!
Hello all and kudos for this great mod. I have installed v209a in Zen 1.3.7 and the box for entering the subscribers email addy is too long. Need help in where and how this box can be shortened to fit the sidebox.
Can be seen at: http://stunstasersandmore.com
I am using v.1.3.8. Seems I successfully installed the mod but when I turn on the subscribe sidebox, my cart only loads to the point of that sidebox, essentially shutting down the shop.
Not sure what is going on. Has anyone else had this problem?
Nevermind my last post I figured it out. I had the custom template folders name incorrectly.
However, I am now having a new problem. When I try to subscribe using a new email address, I get the following on the subscribe page:
-------------------------------------------
Thank you for taking a moment to subscribe to our Newsletter.
You'll receive notices of newly available products, special offers, and news of upcoming showings.
Error There is already a Customer Account using that email address. To subscribe to the newsletter, please LOGIN and select the My Account link at the top right. Click here if you have forgotten your password.
Before you begin receiving your subscription to our newsletter, you MUST reply to our subscribe-confirm request sent to your email: [email protected].
Please check your e-mail inbox. When you receive the confirmation request, just click on the confirmation link enclosed in the email.
If you have troubles signing up, please send a message to [email protected].
---------------------------------------------
First it says thank you.
Then I get an error message saying that the email address is already in use (which it isn't)
Then it says confirm and I am not receiving confirmation emails.
Additionally, the email address doesn't show up in the admin.
In essence, it is not working.
Not sure what to do, would really like to use this contribution.
Thanks,
I installed this module...seems really good.
BUT seems that subscribes default to TEXT-only for the email format even if they select Html option on the subscribe box.
Any ideas as to what the problem could be?
Thanks.
I have done what we could call a successful installation of this mod, except for one problem.
Email come and go properly, the opt-in links works correctly.
The problem is the subscribe button is clicked after entering a email address the following message comes up at the top of the page:
"Warning: mail() [function.mail]: SMTP server response: 501 5.5.4 Invalid Address in D:\home\Default\stunstasersandmore.com\htdocs\includes\modules\pages\subscribe\h eader_php.php on line 109"
Although the correct message is displayed that says check your email. etc,etc.
If I could eliminate this message I believe all else would be ok. Any suggestions?
I am running Zen 1.3.7 and have newsletter ver 2.0.9a installed.
My URL is: http://stunstasersandmore.com
Hello,
Everything seems right however when an email addy is typed into the subscribe box and the box is clicked, the screen refreshes and nothing appears in the main window (thank you for subscribing). When I go into the Admin module to check I have no one new in my list.
Any ideas or places to look. Double checked file locations and merges that I had to make and everything looks good. Not sure even where to begin.
Thanks in advance!
Hey dnolan,
I am guessing that was not in response to my question!:lookaroun
Thanks davewest... that did the trick... man, to easy to overlook sometimes :lamo:
:blink:I am still reading, looking and scratching my head on this one. Please, does anyone have any ideas? Everything, is working perfectly except for this message at the top of page after 'subscribe' is clicked. This message disappears when the next page is rendered.
The key here is the SMTP response. Go back to your Admin->Configuration->E-mail Options look at the SMTP entries and reenter all. This could be as simple as an extra space or dot where there shouldn't be one or using sendmail on a windows server. If your sending email to all but yourself, recheck your address and confirm it with your host. Line 109 is sending the store owner a message not the subscriber.Quote:
"Warning: mail() [function.mail]: SMTP server response: 501 5.5.4 Invalid Address in D:\home\Default\stunstasersandmore.com\htdocs\incl udes\modules\pages\subscribe\header_php.php on line 109"
Hi, I am using this with 1.3.7 and am having a problem DELETING subscribers. I find a subscriber, click the delete button, it asks if i am sure and i delete but it does not delete them.
I am now having to go into phpMyAdmin and manually remove people, which is annoying and time consuming.
Any thoughts on why this would be happening?
Thanks!
I am having a problem with a error/warning when accessing the subscriber manager - the page loads but there is a bunch of text (which appears to be the contents of the subscription_manager.php file) and the following warning:
Warning: Cannot modify header information - headers already sent by (output started at /mnt/w0505/d17/s02/b02d1920/www/brazilianshoebox.com/shop/admin/includes/languages/english/subscription_manager.php:7) in /mnt/w0505/d17/s02/b02d1920/www/brazilianshoebox.com/shop/admin/includes/init_includes/init_templates.php on line 36
If I scroll down I can view the subscriber listings etc. and all other functionality appears to be working
This is v 2.1.0 with Zen Cart v1.3.8a
Any and all assistance would be appreciated!
This might help..
https://www.zen-cart.com/tutorials/index.php?article=87
Awesome Thanks!
I am also getting this error when a new customer signs up. You select the country and it will not register.
HELP!! :frusty:
I have killed my site and am not sure what I have done. I think it started after I installed NS.
All ideas would be appreciated.
I have searched and searched for a solution but nothing.
I should have told you I am using Zen-Cart version 1.3.7.1 and NS version 2.0.9a
Freaking out here, sorry.
KZ
I know I would not get any help from this forum, never have.
Also forum is to large. This thread is ridiculous, took 2 days to read it all. Not much help also.
Still looking for help.
the confirmation link disapear when subscribe in html format all files of contribution were right ( uploaded new one )
wgere can I fix this problem ?
I fixed the problem on my own.
Thanks for all the replies for help! :lookaroun
Perhaps someone might have some thought on this problem.
When sending a HTML email to a customer who signed up for the newsletter-only they get a TEXT email. All registered customer is sent correctly.
I have checked the settings in admin>config>e-mail options.I searched and searched, I even read the tips and troubleshooting guide.
- PHP
- Use MIME HTML when sending - TRUE
- Email sent from known domain - Yes
It appears that from the archive the messages were sent via HTML but none of them arrived as such.
zen-cart 1.3.7.1
Please?
the confirmation link disapear when subscribe in html format.
all files of contribution were right ( uploaded new one )
where can I fix this problem ?
I'm getting the following message when a customer tries to sign up for the newsletter:
Email Error: Could not execute: /usr/sbin/sendmail
What does this mean? I'm getting similar messages for other functions in admin as well when I try to send emails and upgrade customer accounts.
I don't know if this is a data base help type question or not. If I have to do something to the database, I really need some help to do that as I don't know how to get into it to fix stuff.
Make sure your email is set right in Admin->Configuration->Email Options.
see the Tutorial on setting up email if you need more info..
https://www.zen-cart.com/tutorials/i...hp?article=111