Sorry, the problem was actually the fact that I changed an e-mail option setting for news letter subscription and actually has nothing to do with the "login as customer".
Printable View
Sorry, the problem was actually the fact that I changed an e-mail option setting for news letter subscription and actually has nothing to do with the "login as customer".
I installed Newsletter-Only Subscriptions for v1.3x on Zen Cart 1.3.8a. The problem I'm having is that after clicking the link in the confirmation email the subscribe confirm page says: Sorry, my system does not understand your email address. Please try again.
I'm using Simple SEO URL (SSU) and Zen Lightbox. Any suggestions? Thanks.
I just installed Newsletter-Only Subscriptions for v1.3x on Zen Cart 1.3.8a., Everything is working fine, just one problem in the "Newsletter Subscription" page all my right hand boxes are moving far all the way to the right side including the top main wide banner.
any suggestions??
thanks
What happens when you disable SSU?Quote:
Originally Posted by max101
If i recall correctly this has to do with the way the text is put in the define page. See if formatting the define page with more breaks corrects the errorQuote:
Originally Posted by melirlbr
from what 'define page' is the issue the define_subscribe one? located in the /includes/languages/english/html_includes/MY TEMPLATE ?
What happens if you put a <br /> in that file?Quote:
Originally Posted by melirlbr
sorry i did that, but putting a <br /> in the file didn't help it just pushing the text down a line, i am thinking the problem has to be somewhere else... ??
I've installed the mod and it works fine. However, I'd like to make subscription automatic (with a link to unsubscribe in every newsletter). I have tried looking at the codes but don't know where to begin to make the necessary changes.
Anyone able to help?
Error when using the email function from Customers > email > (Notice: FAILED to send Email to all recipients:)
I found this thread which has a fix.. I thought maybe this can be included in the next release of this wonderful contribution.
See thread: http://www.zen-cart.com/forum/showthread.php?p=209263
Thank you,
All seems fine except that confirmation emails are not being sent to subscribers.
newest zen installed. everything else works on the site.
What am i missing?
thanks
I've got this mod installed, and tried to subscribe via the sidebox.
This just sends me to the "newsletter subscription" page.
Is this how it is suposed to work? I assumed it would work just
fine if the customers just entered their adress in the sidebox and pressed "subscribe".
What have I missed?
Ok so when people add their email in the sidebox, it adds the email to database but wont send out confirmation email. if you do the same but on the actual subscribe page, then the email is sent and link works.
How to get the sidebox to work as it should is my question.
Correction on the "See thread": Link: http://www.zen-cart.com/forum/showpo...3&postcount=12Quote:
Originally Posted by jasmel
My client's site is running on Zen Cart 1.3.8a. My client has been receiving emails from customers saying that there is no hyperlink in the email that they are supposed to click to confirm their newsletter subscription. As a result he has a lot of pending statuses on his newsletter only subscriptions.
He has been able to confirm them from the admin console, but I was wondering if anyone else has had this issue. I tested it myself and I had the same problem. I use gmail as my email client.
Any suggestions?
Thanks,
Joshua Smith
Printsmith Designs
This is one of the best mods ever!
I wish this thread had a different title though... "Newsletter Subscribe" would probably be better. It was hard to find because the current title is somewhat misleading and this thread isn't placed at the top of the search due to poor title. IMHO.
On to the issue:
There's a misspelling in includes>languages>english>template>subscribe.php
Line 26 says: define('UNSUBSCRIBE_EMAIL_TEXT', 'Your e-mail adres is now unsubscribed
Nice catch... however, you meant to state:Quote:
Originally Posted by pricediscrimination
There's a misspelling in includes>languages>english>template>unsubscribe.php
Line 26 says: define('UNSUBSCRIBE_EMAIL_TEXT', 'Your e-mail adres is now unsubscribed
Hi
I installed the contrib , looks good and works fine , sends the emails and updates the data, but after I click on subscribe , I get the thank you page with all below at the of the Thank you page.
the subscriber email gets the emails and the address is added to the list of subscribers,I am using PHP mailer, zen 138a and the mail is functioning normal.
WordWrap] => 76 [Mailer] => mail [Sendmail] => /usr/sbin/sendmail [PluginDir] => [Version] => 1.73 [ConfirmReadingTo] => [Hostname] => [Host] => localhost [Port] => 25 [Protocol] => [Helo] => [SMTPAuth] => [Username] => [Password] => [Timeout] => 10 [SMTPDebug] => [SMTPKeepAlive] => [smtp] => [to] => Array ( [0] => Array ( [0] => [email protected] [1] => ) ) [cc] => Array ( ) [bcc] => Array ( ) [ReplyTo] => Array ( [0] => Array ( [0] => [email protected] [1] =>companyname ) ) [attachment] => Array ( ) [CustomHeader] => Array ( ) [message_type] => [boundary] => Array ( ) [language] => Array ( [provide_address] => You must provide at least one recipient email address. [mailer_not_supported] => mailer is not supported. [execute] => Could not execute: [instantiate] => Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport. [authenticate] => SMTP Error: Could not authenticate. [from_failed] => The following From address failed: [recipients_failed] => SMTP Error: The following recipients failed: [data_not_accepted] => SMTP Error: Data not accepted. [connect_host] => SMTP Error: Could not connect to SMTP host. [file_access] => Could not access file: [file_open] => File Error: Could not open file: [encoding] => Unknown encoding: ) [error_count] => 0 [LE] => )
Thanks so much for the help
Hi,
I got this error when I clickon 'Admin Home' in my zc admin AFTER I had finished ftping all the files:
I noticed that there is NOT an install.sql file or similar in this mod, so I'm assuming that the table is installed via a php file.PHP Code:1146 Table 'xxxxxxxx_xxxxxxxxx.TABLE_SUBSCRIBERS' doesn't exist
in:
[select count(*) as count from TABLE_SUBSCRIBERS where confirmed= '1' or customers_id >= '1']
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.
When I 'mouse' over the Customers tab in my admin, I do not see the 'Subscription Manager'.
Any suggestions?
I just looked at my db via phpmyadmin AND 'subscribers' does exist.Quote:
Originally Posted by autoace
Any suggestions?
One or more of the files have not been uploaded correctly. Re-upload them and try again.Quote:
Originally Posted by autoace
Regards,
Christian.
I am using Newsletter Subscribe v 2.1.1 on Zen Cart v1.3.8a, i have a slight problem, i use the site for a small community where almost all of them know each other.
some of the subscribers (it happened once) unsubscribe other members since they know their email address.
Is there a way to have the subscription only unsubscribe by the owner of the email? like send them an email and they have to click on a link. Thanks in advanced in any help.
That's not a built in feature of the mod and would need to be specially coded.Quote:
Originally Posted by TamyA
Regards,
Christian.
First, I did merge all the changes to the core file to my default zc files (made backups first).
I did another WinMerge compare of the addon file /admin/index.php and my /xxxxxx/index.php and there is only 1 difference between the 2 files:
and then there is a blank line under that code in both files.PHP Code:$customers->fields['customers_firstname'] = zen_output_string_protected($customers->fields['customers_firstname']);
$customers->fields['customers_lastname'] = zen_output_string_protected($customers->fields['customers_lastname']);
I don't have a prefix on my db, so I don't think that is the issue.
======================
I next did another WinMerge compare of the addon file /admin/customers.php because I am getting this error in my admin > tools > Send Email page:
and there is only 1 line that I am suspect:PHP Code: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 'as s left join customers as c on c.customers_id = s.customers_id' at line 1
in:
[select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join customers as c on c.customers_id = s.customers_id ]
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.
this line is not in the addon file, is that possibly what is causing the issue for admin > tools > send email?PHP Code:if (isset($_GET['search'])) $_GET['search'] = zen_output_string_protected($_GET['search']);
Any suggestions?
I don't know how I did it but I went to re-upload the files and realized that I had forgotten to upload all the files in the admin/includes folder - did that and now it works!
I'm glad I took the advice and just re-uploaded all files before I went messing w/any code. :smile:
Hi,
Have this installed already and it's working fine. Just wondering if it is possible to move this to the centre column as we are changing the look and feel of our site.
Thanks!
Brian
ZenCart v1.3.8a
Latest version of this module.
Have installed and seems to be working fine. Have two questions:
1. Under Tools - which email option should I be using. The called "Send Email" or the one called "Newsletter and Production Notification Manager".
I've tested both and they seem to work with the same results.
2. The resultant email includes the ZenCart logo at the top of the email. How do I get rid of that? The ZenCart logo shows up regardless of which email tool I use.
Thanks!
:huh:
I am having a problem, someone keep unsubscribing a customer that he knows his email address, how can i prevent that? is there anyway to confirm the unsubscribe with an email? Thanks.
I have searched this thread and found partial information about removing the "HTML" and "Text" buttons, but didn't find a complete description of how to do this. Could someone describe this in detail?
Also, could someone help me figure out how to left-justify everything? I have a very rudimentary understanding of PHP and am not sure where to look or what to do.
Thanks.
To Remove "HTML" and "Text" buttons from Newsletter Subscription Sidebox.Quote:
Originally Posted by brettabloom
Copying instructions from post #437:
1) Look for the following file:
/includes/templates/YOUR_TEMPLATE/sideboxes/tpl_subscribe.php
2) Remove the following part:
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>';
}
3) Save the edits
4) Upload the file
Hope it helps you. I just did the changes for myself and it worked.
This worked. Thank you very much!
I cannot get this to work. I transferred the files 3 times and still cannot see 'subscription manager' or anywhere to install.
The last time i transferred files, I did it manually (not moving entire folder) and now i have screwed up my zencart. UGG... Admin panel still works, but can't see my cart on the internet, just a blank page.
I have a custom template. Will this not work with a custom template?
HELP!
I have restored my zencart and am back to my original files. Please tell me how to get this patch installed.
I tried dragging the folders to my zencart folder and it did not work. I have a custom template. Do I need something like Winmerge? I am using a mac is there a winmerge type program for mac or do I need to dust off my PC and try to use it?
Am I doing something wrong?
Thanks!! :)
Ok, I restored the zencart and now I am getting this error when I click the install button on the "subscription manager"
1005 Can't create table 'zen_subscribers' (errno: 13)
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.
Hi,
I've been using the newsletter-only subscriptions for a while now and it's great - thank you.
I'd like to ask my sign ups for their christian name so that when I send them an email it's more personal - I've read several times that people are more liekly to read emails that use their name.
Does anyone know how to do this or does nayone know if it is likely to be a future update?
Many Thanks
Suekay
Hi,
I've just sifted through 94 pages and didn't find anything about unique IP checking. Could you please tell me the steps to get that accomplished?
It would be best if during newsletter sign up, not only unique email would be checked but also an IP address to prevent multiple newsletter sign ups from the same address.
It would be great to display IPs in the admin panel as well.
At the very least, one of the two, and if need be, we would manually remove duplicate entries from the same address.
We are basically trying to use this great tool for sweepstakes and we want to ensure there are no duplicates.
Thanks for your help.
Once someone helps me with this, I would be happy to repackage it as an upgrade to this wonderful contribution.
Hi,
I'd like to switch the header signup form from the header area to the footer area, any suggestions?
Also, does anyone know how to have that signup form show up on main_index.php (define pages) only on the homepage?
I updated my old version of Subscribe! 1.1 to this newest one.
Before doing that I backed everything up and downloaded the table of subscribers in SQL format. Then removed the old version.
But it won't let me upload the list of "old" subscribers. After trying different formatting and ways to upload I consistently receive error messages of one sort or other. It's approximately 2,500 people.
The subscribers table is structured like this:
subscriber_id
customers_id
email_address
email_format
confirmed
subscribed_date
And the data I'm attempting to upload looks like this:
(1157, 16, '[email protected]', '', NULL, '2008-02-25 10:22:04'),(1158, 15, '[email protected]', 'HTML', NULL, '2008-02-25 10:22:04'),(1159, 94, '[email protected]', 'HTML', NULL, '2008-02-25 10:22:04'),(1160, 95, '[email protected]', 'TEXT', NULL, '2008-02-25 10:22:04'),(1161, 6, '[email protected]', 'TEXT', NULL, '2008-02-25 10:22:04'),(1162, 7, '[email protected]', 'TEXT', NULL, '2008-02-25 10:22:04'),(1163, 8, '[email protected]', 'HTML', '1', '2008-02-25 10:22:04'),(1165, 10, '[email protected]', 'TEXT', NULL, '2008-02-25 10:22:04');
In the sample list I am entering " NULL NULL email format NULL NULL"
So, what am a I doing wrong and can anyone help.
By the way, the rest of the function works as designed, I just can't import the old addresses.
I cant seem to get the sidebox to show up under the sidebox manager, I have copied the files to both my custom template and the standard template area. The add in installed and I can add people manual but I cant get the side box to work.
Installing Ver2.2 on zen-cart 1.3.9c
I received a Mysql error when attempting to install due to apostrophe's in the email address.
Around line 91 in
admin\includes\functions\extra_functions\subscription_manager.php
change
toPHP Code:'" . $cust_subscribers->fields['customers_email_address'] . "',
This will prepare the input correctly for insertion into the database for those rare casesPHP Code:'" . zen_db_input($cust_subscribers->fields['customers_email_address']) . "',
Quote:
Originally Posted by Oakwood
Please Help - I'm trying to put the newsletter subscribe box onto the main page down the bottom like this site http://www.sugarandspice.com.au/ and i copied view source like the quote above but it keeps vanishing.. any ideas which lines / fields to copy and paste or how to? :no:
(I think this will be a great add on once i get it going! Thank you to the creator!).
Hi:
Right now I'm using V1.3.8a, but may be upgrading to the latest version shortly.
I would love to install this newsletter add-on. Is there a site that I can go to in order to see what it actually looks like.
I'm not much of a webmaster, but willing to try and add this to my site. Love the idea that people can sign up for my newsletter and not have to have the 'unsubscribe' on my home page.
Any feedback would be greatly appreciated.
I have had to uninstall this and have done so, except that I am getting an error in my sql. How do you uninstall the sql part of this?
What is the error?Quote:
Originally Posted by 1kell
Does anyone have this mod working on zen cart 1.3.9d?
I did a fresh standard installation of a 1.3.9d cart with no mods except the newsletter subscribe 2.2 version.
In admin when going to tools > send email, I'm getting this error
1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'locate'
in:
[SELECT s.email_address as customers_email_address FROM zen_subscribers as s LEFT JOIN zen_configuration as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP' ]
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.
Hi
I have this installed and working on 1.3.9d.
With html emails turned off, this records the subscriber preference as html, when it should be text.
Which part of the code can i change to make this record a text preference pleas?
I have searched the forum and this thread, but cannot find anything.
TIA
Paul
Hi, I've installed the mod and done some changes around the store and such, usually just fumbling my way through.. however now when I sign up to the newsletter only subscription I get this as the confirmation email...
EMAIL_WELCOME
EMAIL_TEXT
EMAIL_CONFIRMATION_TEXT
EMAIL_CONTACT
EMAIL_CLOSURE
EMAIL_DISCLAIMER_NEW_CUSTOMER
This email is sent in accordance with the US CAN-SPAM Law in effect 01/01/2004. Removal requests can be sent to this address and will be honored and respected.
Can someone please offer a suggestion, where I might need to go to fix this
Thanks
Quote:
Originally Posted by sarahjewellery
These are found in:
\includes\languages\english\YOUR_TEMPLATE\subscribe.php
Check that you have renamed "YOUR_TEMPLATE" to whatever your template name is and upload to the correct directory
Yes I checked that and it seems to be fine.Quote:
Originally Posted by gilby
I have no idea what may have caused this.
They are showing like this because they have not been defined.Quote:
Originally Posted by sarahjewellery
Zen-cart cannot find the definitions.
As they are defined in the file I mentioned....
There will be a reason Zen-Cart cannot find them
They have been put in the incorrect directory
What is the name of your template directory?
You need to also check that the other "YOUR_TEMPLATE" directories have been renamed as well. (There are at least six of them).
Are you using only english or do you have other languages defined?
I tried completely reinstalling the mod, but with no luck. It is still having the same issue, it also comes up with a big red warning
"A Newsletter-Only subscription has been registered with this email address. If you currently receive our newsletter, but do not have an account."
even though this address is not listed as a subscriber.
Is there a way that another file that could be interfering with this mod?
Something I have edited elsewhere?
Gilby,
Thanks for your help, it turned out I had misspelled the template directory name! How stupid of me, and to overlook it so many times!
How frustrating. Thanks
After uninstalling this, whenever I go to the "Send Mail", to try to email subcribers I can't, I get this message:Quote:
Originally Posted by gilby
I recall having to run an SQL change when installing this, so there must be something I need to run to uninstall it, right? I don't know what to run though and I am stuck with no email capability, which is really a big inconvenience as you can imagine :frusty:Quote:
Send Email To Customers
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 'as s left join customers as c on c.customers_id = s.customers_id' at line 1
in:
[select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join customers as c on c.customers_id = s.customers_id ]
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 am really new at this so please take what I did and consider the source.Quote:
Originally Posted by buildingblocks
My issue was very similar to yours. My illegal collation mix was between utf8_unicode_cla and utf8_general_cl.
I went into phpmyadmin and changed the Collation on the zen_subscribers table to utf8_general_ci on email_address, email_format and confirmed.
I had no data so there was really no risk for me. I suggest a backup though.
If I did something really stupid, I would appreciate being corrected!
I remember when installing this, I ran a SQL thing to uninstall it to check it could be done. That worked, but I can't find what I ran to uninstall this. Whenever someone subscribes now, they don't get added on the database.Quote:
Quote:
Originally Posted by gilby
What is the error?
After uninstalling this, whenever I go to the "Send Mail", to try to email subcribers I can't, I get this message:
Quote:
Send Email To Customers
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 'as s left join customers as c on c.customers_id = s.customers_id' at line 1
in:
[select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join customers as c on c.customers_id = s.customers_id ]
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 recall having to run an SQL change when installing this, so there must be something I need to run to uninstall it, right? I don't know what to run though and I am stuck with no email capability, which is really a big inconvenience as you can imagine
Does the latest version of this mod still work with 1.3.8a?
Also has this problem been fixed?
When the mod is installed, if a new customer tries to sign up, they can't because it won't accept the country from the drop down menu?
I had to uninstall the mod and overwrite all the files to get the create account to work again :(
I'd really like to use the mod, but can't unless this bug has been fixed.
Thanks in advance,
Joanne
I don't think its been fixed and I would stay away from this if you have 1.3.8a. I now can't send any email at all. Really great when trying to run a business. No one seems to know the answer.
OMG, that's awful! Did you uninstall it (make a copy of your subscribers database first). And then overwrite all the affected files with the ones from your original Zen download? That's what I had to do, and it works fine now thank God!!
Yep, I'll stay away from it, at least for now :S
I have a copy of the database from before this, but its a whole copy, I don't know how to break it up to just upload the affected part. You might be interested in trying mailchimp.com. Its free for less than 500 subscribers, and 15p/month after that. Great templates and tutorials. It also helps you design a subscribe box for your site. I think there is also an add-on for it but I haven't looked at that.
Open your database up. Use the search and find feature of whatever text editor you're using to find the following:
and highlight everything from the beginning of that line to the end of the following line:Code:DROP TABLE IF EXISTS `subscribers`;
Then all you have to do is log into your cpanel go to PHPMyAdmin select your store database, and click on SQL at the top of the page.Code:UNLOCK TABLES;
Paste what you highlighted above into the box and click GO, and poof your subscribers are back :D
Good luck!
Joanne
Sorry if this has been covered but i can't find it.
Installed NS and working on 1.3.9e except that a newsletter subscriber stays a newsletter subscriber (N) even when they register an account and subscribe to the newsletter. (Should change to (C)
Has anyone any idea why this doesn't change?
Or if it does for you, could you say so, then i'll know it's me :-)
Tia
Paul
I used a former version of Newsletter Subcription before and added a define page of Define_subscribe_confirm.php so that I can edit the confirm in Admin.
After I updated to version 2.2, Define_subscribe_confirm.php didn't work any more.
The confirm page reflects the content in Subscribe_confirm.php. How can I modify the code so that I can still edit the content of confirmation page in Admin under "define page editor"? Much thanks!!
Hello there nice add on like it allot onley thing is I dont need a sidebox couse I wan't it in a jquerry dropdown and on a page for people disabled javascript in their browsers I hacked it and put it in the header but it will not get threw validation at W3C.
I get this returned on both the dropdown div and the page from W3C:
Error Line 120, Column 80: attributes construct error
but things work I just need to find the problem couse i don't get whats wrong pls help!:frusty:
Site: F U C K T H E D R E S S C O D E . C O M
Hi everyone, I've tried to install this twice and each time it ruins my programming...
I am using 1.39 is it compatible with this version? Anyone have any feedback? Thanks!
First, thanks for this addon. It works very well.
I am using Newsletter Subscribe v 2.1.1 with ZC 1.3.9f.
I thought I'd let you know that there are two mispellings in unsubscribe.php. There are two instances of 'adres' instead of 'address'.
Thanks again.
In response to joyjoy's post above here are a couple of tips I have from my experience installing this mod.
1-Make sure all YOUR_TEMPLATE folders are placed in the correct places and renamed to the correct name for your template.
2- The most important thing. For all files that are replacing existing ZenCart files, merge the Newsletter changes into your existing ZenCart files, do not overwrite your existing files even if you think you haven't made any changes in them. If you're running a later version of Zen Cart than Newsletter was made with, then you could be overwriting changes in the newer version of Zen Cart.
I don't know what I'm doing wrong. But I have now tried to install this add 4 times. I have carefully opened every folder and renamed all that is necessary. I have even tried most recently to manually add each folder to it's proper directory - just in case.
It never works! It's driving me crazy because I really want this mod!!!
Is anyone else having problems? Have you been able to solve it?
It's not as if I'm not familiar with what I'm doing. I've installed a lot of add ons and this is the only one that I've had problems with.:frusty:
When I try to edit the table in PHPMyAdmin there doesn't seem to be a way to edit the table. How do I edit it? I can browse but that's it.Quote:
Originally Posted by CJPinder
Ok, I fixed the collation issue as far as I can see. Configuration and subscribers match but I'm still getting ther following error:Quote:
Originally Posted by robbinsgj
1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'locate'
in:
[SELECT s.email_address as customers_email_address FROM subscribers as s LEFT JOIN configuration as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP' ]
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.
Do you need to change to latin1_swedish_ci for every value or just for collation?
I have a fresh install on 1.3.9x and it appears that an email address is accepted as subscribed, but then it doesn't show up in the database and no sub is created. Please advise :) I've had this work perfectly on everything else I've done...very odd.
After uninstalling this, is there a way to reverse the database error its created? I cant send emails.
i know that version, it was written for 1.3.8a so handsup for you that you got it to work on the current version 1.3.9f. I suspect you did have a tad more editing to do than just change adres into address :yes:Quote:
Originally Posted by bpryor
I wouldn't recommend using version 2.1.1 on 1.3.9 version as it is not tested, i can see in the download section Judy has taken up the task to write the module to be compatible with 1.3.9 in a newer NewsLetter Subscribe version 2.2 series.
Excellent advise, this is the safest way to add modules to your store. Counterpart is unfortunately that most shop owners are better in selling products than in looking at php code, which creates sort of a gap sometimes :lamo:Quote:
Originally Posted by bpryor
I didn't look at Judy's later versions, but if you choose to use Newsletter subscribe v2.1.1 than this is definetly the only way to get a shot at succesfully implementing it. You need to know what you are doing as it was never written for 1.3.9+ so DO NOT overwrite existing files.
Again, i would recommend going with Judy's later versions in the v2.2 series as they were rewritten for the 1.3.9+ zen-carts
I agree with bpryor 100%Quote:
Originally Posted by nagelkruid
I'm running this on 1.3.9g with no problem. You have to compare and merge the files from the newsletter module with the files in 1.3.9g.
I am having some error when I tried to import a file of email addresses. It gave me this error message:
Then when I went back to look at the email addresses already in there, I see the � symbol all over. What did I do wrong?Code: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 '' at line 1
in:
[REPLACE INTO subscribers ( email_address, email_format, confirmed, subscribed_date ) VALUES ( '��������×�D�@��l�������������������������������� ����ÿ��������!����ÿ��������"����ÿ��������#����ÿ��������$����ÿ��������%����ÿ��������&����ÿ��������'����ÿ��������(����ÿ��������)����ÿ��������*����ÿ��������+����ÿ��������', 'HTML', '1', 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.
lauriesscraps.com/store
I think I got it figured out now, but would like to still know why it did this. Was it the type of document I was suing to import? It seemed to fix it when I changed it to a note pad doc.
First of all, thanks for this contribution.
I've installed the older version of this mod because I am running zc 1.38a. What I would like to know is, if there is a way to add a first and last name to each email I import. As of now each email has a name of "Newsletter Subscriber".
Yes there is but its not easyQuote:
Originally Posted by idle
You would need to add the required fields to the database
And rewrite a considerable amount of code to add these 2 fields.
I don't believe that anyone has done this before
As well when this has been asked previously
Most have pointed out that the less obstacles you put in a customers way then the more likely thay are to sign up for the newsletter
I wish I would have read this before I read the install. All of my files have been overwritten and I can't seem to get this to work. I've followed the instructions to a tee... Any suggestions now, after the install, would be greatly appreciated! Version 2.2Quote:
Originally Posted by bpryor
Latest version of zencart. :frusty:
Okay. I've been having a full on relationship with winmerge today and I've discovered after 3 installs and 3 backup restores that even though the install file states that admin/index.php and admin/customers.php have changes my files DO NOT show differences. Could this be a problem? I'd appreciate any and all help.
Lynn
http://marketcafe-online.com
If I remove the News letter-only subscription contribution from my site and return to using the standard log in on my site what will happen to my list of news letter subscription only subscribers?
Well.... Nothing they will still be in the "subscribers" table, assuming that you don't delete it.Quote:
Originally Posted by Astarkley
As zen-cart doesn't use it, they will be ignored, as if they didn't exist.
If you remove the mod it will be as if you had never installed it.
What did you expect, or hope to happen?
I just want to make sure I don't loose the email addresses that I collected through the subscribe to newsletter feature so that I can hopefully convert them to account holders. My site actually really requires more than just an e-mail address to fully benefit the customer. my web-site is http://letsseethemenu.com
Seen a few unanswered posts in this thread from people who are just unable to get it to even show let alone work. Here is my problem, i will explain as best i can;
I have downloaded Newsletter Subscribe 2.2 and meticulously uploaded all the files to their correct locations as per the file structure etc. All template based files are in the correct folders based on the name of my template.
My zencart version is 1.3.9h.
I log into my admin panel and go to tools - layout boxes controller and am informed there is a new module found, which i edit to appear on the left column.
As per the readme file i go to config - my store but there is no mention of it anywhere in there and my site shows absolutely no trace of it. No meta tags, no button, no link, nothing.
This is the first time i've tried to install this particular mod, so i'm hoping i'm missing something really obvious as plenty of people clearly have it working.
Many thanks
Matt
Zen cart has had a over haul so you need to take the core files this module uses and merge them with the file that zen cart uses. This will fix your problems.Quote:
Originally Posted by Matthammer
Hi, managed to fix this. Merge not required.
Thanks
Your answer assumes that everyone knows what you mean by "merge". And how do you merge by the way? And exactly what core files are you talking about?Quote:
Originally Posted by countrycharm
Can you elaborate and be specific?
Great...could you not have told the rest of us how you managed to fix it, and help out others on the forum?Quote:
Originally Posted by Matthammer
The problem I am having is this is what I see when I go to admin/tools/send email:
1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'locate'
in:
[SELECT s.email_address as customers_email_address FROM zen_subscribers as s LEFT JOIN zen_configuration as q on LOCATE( s.email_address, q.configuration_value) >= 1 WHERE configuration_key = 'NEWSONLY_SUBSCRIPTION_TEST_GROUP' ]
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.
So, I can't even send emails to anyone. I think that is the only issue with this module that I am having. I am finally seeing it under Layout Boxes Controller and have successfully added the newsletter sidebox to my template...but if you can't send any emails, then it does no good.
Does anyone know how to edit the text within this newsletter module?
The generic "Enter your email address to subscribe to our Newsletter." could be changed to offer something in exchange for a subscription (free report, coupon, etc.) which would be much better from a marketing standpoint.
Thanks!
Modifications are made to the following core files:Quote:
Originally Posted by organelle67
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
If you have made other changes, or have added other modules add on's, that uses these core files that are mentioned here,
I highly recommend using a merging program, such as WinMerge
(http://winmerge.sourceforge.net/) to merge the files together. Most problems are due to files not being in the right place. In other words people didn't change the custom folder name to match theirs.
I had the same issue and found you have to go to the table structure and change the collation for the individual fields as well!
I had the same error message and I had to go into MySQL and edit the fields that were set as latin1_swedish to latin1_generalQuote:
Originally Posted by organelle67
I have been trying to get this mod to work with COWOA for the last couple of days and I know that there is documentation about COWOA and this mod having compatibility issues due to the fact that COWOA clients are still entered into the database, but as they function completely separate other than that variable, I figured I could work out a way to make them play nice - and I think I did it.
I just wanted to post what I did here in the hopes that someone who has actual php knowledge would take a look and confirm that it won't cause conflicts in my coding.
What I did was go into the includes/modules/pages/subscribe/header.php and in the "check if email address exists in CUSTOMERS table or in SUBSCRIBERS table" section, I added
underneathPHP Code:$check_cust_COWOA_query = "select count(*) as total from " . TABLE_CUSTOMERS .
" where COWOA_account = '" . zen_db_input($COWOA_account) . "'";
$check_cust_COWOA = $db->Execute($check_cust_COWOA_query);
and then I changedPHP Code:$check_cust_email_query = "select count(*) as total from " . TABLE_CUSTOMERS .
" where customers_email_address = '" . zen_db_input($email_address) . "'";
$check_cust_email = $db->Execute($check_cust_email_query);
toPHP Code:if ($check_cust_email->fields['total'] > 0) {
I followed the same steps in admin/subscription_manager.php.PHP Code:if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA == 'false')){
Then I created a test COWOA order, signed up for a subscription and everything worked perfectly. I got a confirmation email and was able to confirm my subscription even though I had completed a COWOA order with the same email address.
I know that the mindset is that a COWOA client will most likely not want a subscription but after so many years in the customer service field, I wouldn't be surprised if a handful of them do. People can be so weird sometimes.
I have the newsletter module in my header but I can't seem to figure out how to get it to the right and down in the middle.
http://frompropertorocker.com/fptr_test/
I am sure it's probably really simple and I am just missing where to go lol.
Thanks in advance!
If you still need help with this, I'm not great at coding but I can show you how to adjust the css - it's really easy with FF.Quote:
Originally Posted by nolsowski
I looked at your site (which is fabulous - I love the stars on your sidebox headers!) and didn't see the newsletter subscribe box.
Thanks Kamelion. I forgot I shut it off when I was working on the header. It's up but it's hard to see now but it's at the top still lol.Quote:
Originally Posted by kamelion0927
If it's possible to move to the right and to the bottom that will be awesome! If not that's ok and I will just put it in the sidebox.
Thank you for the compliments of my site and for your help. :)
Ok. I see what you're going for!
I think I have mine in about the same position that you want yours.
The first thing that you're going to need to do is go into includes/templates/your_template/common/tpl_header.php and add some <div> tags to your code which you can then utilize in the stylesheet.
In includes/templates/your_template/common/tpl_header.php, your code should look something like this:
<div id="subscribeWrapper">
<?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
?>
</div>
By placing the <div id="subscribeWrapper"> before the code and the </div> after, you can tell the stylesheet which section needs to be moved.
Next, open up your stylesheet.css and anywhere you want add:
subscribeWrapper{}
Then you can add padding and margins as applicable inside the {}.
I highly recommend using a Firefox add-on called Firebug if you don't already because you can actually adjust the CSS on your site through Firebug to see what it looks like before you change the stylesheet. It saves a lot of time when making adjustments to CSS.
Just an FYI, I'm pretty new to all of this too so if I didn't explain myself clearly, don't feel bad asking for further explanation.
Good luck!
Thanks a bunch! I got the first part done pretty easily but on the second part I have a question. Where did you add the code in the stylesheet? I am lost on where to even put it. lolQuote:
Originally Posted by kamelion0927
Nvm lol. I got it now. Almost lol. Just need to play with the code to get it to the bottom now. :)Quote:
Originally Posted by nolsowski
Okay I was wrong. I am going to need your help lol.
I have been playing with it in the firebug and it keeps messing up my logo. (I don't have an actual header. I made my header to go in the logo since it wasn't fitting right when I named it to go in the header) Does that make a difference now? Sorry I just remembered that and now it probably won't work?
Nope - the code for the subscribe header is completely separate from the rest of the header. It all depends on where you put the code.Quote:
Originally Posted by nolsowski
Think of the header (or any other code) as a Lego wall, the divs as small pieces of stuck together Legos and each piece of code as an individual Lego. If you have a bunch of different code in the same div, they're going to move together - just like a bunch of constructed Legos. (Stupid analogy I know, but the most visual one I can come up with on this little sleep.)
In looking at your site, I'm not showing the subscribeWrapper CSS settings. Do you have #subscribeWrapper{} on your stylesheet?
Quote:
Originally Posted by kamelion0927
That does make sense. I didn't put the subscribeWrapper in the CSS yet because I am not sure where in the CSS to put it lol.
I just put it in now so hopefully it's in the right place lol