Newsletter-Only Subscriptions for v1.3x

Quote:

---

Originally Posted by nolsowski

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

---

Anywhere in the CSS is good. I just added mine to the header section of the stylesheet.

And when I'm first positioning something, I usually just add the #divname{} so I can play with it on Firebug before adding the final specifications.

Quote:

---

Originally Posted by kamelion0927

Anywhere in the CSS is good. I just added mine to the header section of the stylesheet.

And when I'm first positioning something, I usually just add the #divname{} so I can play with it on Firebug before adding the final specifications.

---

Ok I put it in the header section also.

Quote:

---

Originally Posted by kamelion0927

Anywhere in the CSS is good. I just added mine to the header section of the stylesheet.

And when I'm first positioning something, I usually just add the #divname{} so I can play with it on Firebug before adding the final specifications.

---

I got it! Thanks so much!

Your site is the one I keep going to for inspiration lol. I have it bookmarked and I am always looking at your site trying to figure out how you did things lol.

Quote:

---

Originally Posted by kamelion0927

Anywhere in the CSS is good. I just added mine to the header section of the stylesheet.

And when I'm first positioning something, I usually just add the #divname{} so I can play with it on Firebug before adding the final specifications.

---

Can you tell me where you went to change the "Newsletter" to your different words?

Quote:

---

Originally Posted by nolsowski

Can you tell me where you went to change the "Newsletter" to your different words?

---

Ah, thanks! :blush: I've redone my site so many times, I think I'm finally getting the hang of it. (Hopefully :P)

Anytime you want to change the wording on anything, it will always be in includes/language files.

To change the wording in the header for this mod, you would want to go to includes/languages/english/extra_definitions/your_template/newsletter_subscribe_defines.php.

I'm glad you got it working! This one was kind of a bugger to get into the header the way I wanted to. You might want to check how it looks in IE too - I had some compatibility issues with CSS between IE and FF.

Just wondering what other users are using to bulk unsubscribe

Each time I send out a newsletter I get 200 to 300 "bounces" where customers have changed their email address and not changed the email address in the database

Probably a once only purchaser anyway

I can put them thru the newsletter unsubscribe one by one Uggg!!

I can use a script tp update the customers table
Then a similar script to remove them from the subscribers table
Trying to keep both in sync is a tedious pain

Anyone found an easier way?

Hi,
I've just tried to install the mod, all seemed to be going well but I now have 2 problems....

Firstly, what is the sidebox called? I have a couple of very similar options coming up in sidebox controller and I don't know which is which!

Secondly, when I go to 'send an email', I get this error message:

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.

Can anyone help?

Quote:

---

Originally Posted by towerhealth

Hi,
I've just tried to install the mod, all seemed to be going well but I now have 2 problems....

Firstly, what is the sidebox called? I have a couple of very similar options coming up in sidebox controller and I don't know which is which!

Secondly, when I go to 'send an email', I get this error message:

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.

Can anyone help?

---

I got the same problem- Jag gissar att du är svensk så jag tar det på svenska. -- Välj english som språk i admin när du installerar så blir det rätt i databasen. Väljer du swedish så får de felet.

I found this is another thread and it worked

Quote:

---

Originally Posted by DrByte

Try going to Admin->Tools->Install SQL Patch and paste the following into the window and click the Send button:

Code:

---

alter table subscribers change email_address email_address
 varchar(96) NOT NULL default '' UNIQUE collate 'latin1_general_ci';

---

---

Still don't know the name of the sidebox I need though!!! Any ideas?

Still having trouble. Looking at the instructions, I wasn't able too rename by YOUR_TEMPLATE folder in includes/templates as there was another folder in there already called that. Perhaps this is why I can't get the module to work. PLEASE HELP!!! :blink:

Quote:

---

Originally Posted by towerhealth

I found this is another thread and it worked



Still don't know the name of the sidebox I need though!!! Any ideas?

---

The sidebox is called subscribe.php.

:censored: I can't seem to get this to even show up on my site now!!!

I uploaded and configured it on www.giftsforhimorher.co.uk which I use as a test site and got everything working fine.

I've uploaded it today to www.tower-health.co.uk and can't even get it to show up in the admin panel where it should.

Can someone PLEASE PLEASE PLEASE help?! :cry:

Hello all-

I've been busily plugging away at zen cart for a few weeks now and have been managing but now I have what seems like a huge problem.

I downloaded and installed the Newsletter-Only add-on for 1.3.9 (not an upgrade) and moved the folders based on the category tree. Something must not have been in the correct place for my folders because the admin screen went blank and I couldn't access it at all. I moved some things around and then the admin came back with the option to install. I did that and then went to tools/layout boxes. All the settings are gone from the list. It looks like it is pulling from the wrong file. All of the options for featured items, specials, etc are no longer functioning either. Does anyone know how to fix this?

I have removed all the files for the add-on and uploaded the back up files that were overwritten.

I would lreally like to fix this and then try this add-on again. Has anyone had any trouble with the way this category tree is set-up? I did change the YOUR_TEMPLATE to my template name.

Any help would be greatly appreciated. Thank you.




I

Greetings!

BIG problem here.... I installed the newsletter_subscribe module 2.2.1, and received this error message when creating a test customer account and subscribing to the newsletter:

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 ':customer_id:, :email_address:, :email_format:, '1', now())' at line 3
in:
[INSERT INTO subscribers (customers_id, email_address, email_format, confirmed, subscribed_date) VALUES ( :customer_id:, :email_address:, :email_format:, '1', now())]

I restored my site backup, and went to restore the database when I realized that customers have created accounts since I installed this module, and now if I restore the database, I'll lose those customers.

Can you help? Would you know what's causing this error message? As you can understand, this is critical as I'm in the middle of promoting a contest, and customers are getting this error message after clicking "sumbit" to create their account.

I'm using Zencart 1.9.3h
site URL is www.houseofjoypublishing.com

Thanks!
Ken

Ken,

There's an error in -includes\modules\YOUR_TEMPLATE\create_account.php where the bindvars were not being assigned.

I've uploaded a patch (2.2.2) but here's the patch (6 lines to change):

332,334c332,334
< $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
< $db->bindVars($sql, ':email_format:', $email_format, 'string');
< $db->bindVars($sql, ':email_address:', $email_address, 'string');
---
> $sql = $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
> $sql = $db->bindVars($sql, ':email_format:', $email_format, 'string');
> $sql = $db->bindVars($sql, ':email_address:', $email_address, 'string');
344,346c344,346
< $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
< $db->bindVars($sql, ':email_address:', $email_address, 'string');
< $db->bindVars($sql, ':email_format:', $email_format, 'string');
---
> $sql = $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
> $sql = $db->bindVars($sql, ':email_address:', $email_address, 'string');
> $sql = $db->bindVars($sql, ':email_format:', $email_format, 'string');

@towerhealth

You need to either rename the YOUR_TEMPLATE folder to match your template (classic or whatever) before you upload or if you already uploaded go through the directories and where you see 'YOUR_TEMPLATE' move the files there into your template folder.

There used to be default files in place but at some revision they were removed, probably so people didn't get confused on which one they were editing, or so they didn't accidentally overwrite a file they may have already changed (tho since it overwrites other files anyway I'm not sure why...).

Also - see patch in post above- there was an error in the 2.2.1 version. I've uploaded a 2.2.2 version but it might be a few days before it's reviewed/accepted.

NotGoddess (who can't remember the email for her other acct)

Quote:

---

Originally Posted by kamelion0927

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

PHP 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); 


---

underneath

PHP 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); 


---

and then I changed

PHP Code:

---

if ($check_cust_email->fields['total'] > 0) { 


---

to

PHP Code:

---

if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA == 'false')){ 


---

I followed the same steps in admin/subscription_manager.php.

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 found a hole in my logic.

First,

PHP Code:

---

if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA == 'false')){ 


---

should actually be

PHP Code:

---

if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA->fields['total'] == 0)){ 


---

but even if this field is changed, it will let any subscription go through.

I created an account, placed an order and when I sign up for a newsletter subscription, it will still go through even though I specified (I thought) it shouldn't in the code.

Oh well. It isn't a huge deal, but now it's personal. If someone with coding knowledge has time, I would love to know why a subscription request is going through when it shouldn't (i.e. what I'm doing wrong in the code).

Hello all-

I've been busily plugging away at zen cart for a few weeks now and have been managing but now I have what seems like a huge problem with my admin function. I installed the Newsletter-Only add-on for 1.3.9.

After I installed I went back to the admin pull down menus and clicked on some of the options, but nothing is showing. All the settings are gone from the list. All of the options for featured items, specials, etc are no longer functioning etc. If I had to guess, and I'm not that familiar with this, it looks like one of the uploaded files changed the location of my admin settings. Does anyone know how to fix this? I can't figure out how to uninstall this program either and I have been searching for an answer for almost 3 days.

I have removed all the files for the add-on and uploaded the back up files that were overwritten but that did not fix the admin. The site is working just fine.

After the upload I went to Customers tab and clicked on 'Subscription Manager'. I got a warning at the top that the contribution has not been installed. Instructions said to install in order to update the tables and sql queries.

The instructions then said: Under 'Tools -> Layout Boxes Controller' you'll find the sidebox, which you
can arrange just as you would any sidebox. (This is when I realized there were no options or settings anymore. I click on a menu pull down item and there is nothing there.

It does say:
Boxes Path: /home/forthe14/public_html/includes/modules/ ...

I'm not sure if this was the previous path.

I'm desperate. I already uploaded a ton of products to my site and made so many changes via the admin screen.

Can someone help me? Thank you!

Quote:

---

Originally Posted by Ken Joy

Greetings!

BIG problem here.... I installed the newsletter_subscribe module 2.2.1, and received this error message when creating a test customer account and subscribing to the newsletter:

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 ':customer_id:, :email_address:, :email_format:, '1', now())' at line 3
in:
[INSERT INTO subscribers (customers_id, email_address, email_format, confirmed, subscribed_date) VALUES ( :customer_id:, :email_address:, :email_format:, '1', now())]

I restored my site backup, and went to restore the database when I realized that customers have created accounts since I installed this module, and now if I restore the database, I'll lose those customers.

Can you help? Would you know what's causing this error message? As you can understand, this is critical as I'm in the middle of promoting a contest, and customers are getting this error message after clicking "sumbit" to create their account.

I'm using Zencart 1.9.3h
site URL is www.houseofjoypublishing.com

Thanks!
Ken

---

check do you have 2 file name create_account.php in mod dict

hi,

i am trying to get the sidebox to NOT display on a certain page.
made the following edits to the includes/templates/my_template/sideboxes/tpl_subscribe.php but it does not work. any ideas?

// test if box should display
if (in_array($current_page_base,explode(',','special_offers'))) {
$show_subscribe = false;
} else {
$show_subscribe = true;
}

thanks.

Quote:

---

Originally Posted by SaraJacobson

Ken,

There's an error in -includes\modules\YOUR_TEMPLATE\create_account.php where the bindvars were not being assigned.

I've uploaded a patch (2.2.2) but here's the patch (6 lines to change):

332,334c332,334
< $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
< $db->bindVars($sql, ':email_format:', $email_format, 'string');
< $db->bindVars($sql, ':email_address:', $email_address, 'string');
---
> $sql = $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
> $sql = $db->bindVars($sql, ':email_format:', $email_format, 'string');
> $sql = $db->bindVars($sql, ':email_address:', $email_address, 'string');
344,346c344,346
< $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
< $db->bindVars($sql, ':email_address:', $email_address, 'string');
< $db->bindVars($sql, ':email_format:', $email_format, 'string');
---
> $sql = $db->bindVars($sql, ':customer_id:', (int)$_SESSION['customer_id'], 'integer');
> $sql = $db->bindVars($sql, ':email_address:', $email_address, 'string');
> $sql = $db->bindVars($sql, ':email_format:', $email_format, 'string');

---

Sara, THANK YOU THANK YOU THANK YOU :clap:

That code fix did the trick, and all is well !!! I received your other e-mail and will answer privately there. Thanks SO MUCH for a great module and your great help!!

Hello.
I have installed the Newsletter Subscription contribution but haven't been able to get the subscription sidebox to work.

Can you tell me the proper path to the sidebox files please?

Z-C v.1.3.9h

Hello,

I'm having problems with the subscribe sidebox, it doesn't look the way it should. No buttons, only text. When you subscribe it works fine but I know it should look different and better then it does now. I might have different files in the wrong locations. I use zencart 1.39 en subscribe 2.2.2. The template I use is called 12541, and on top of that I use a Dutch language pack. When I set the default language to English it has the same result Could you please have look at my shop at http://www.7ehemeldeal.nl/shop and tell me what I do wrong

waiting desperately for your help

Elbert

I'm sorry if this is posted in the wrong area but I have never been able to figure out how to post a message properly. My issue is that my newsletter will not send to the customer subscription list all at one time however if I am able to send an email to individual customers one at a time. Can any one help me with this?

Hi all, ive added the Newsletter subscribe 2.2.2 addon:

http://www.zen-cart.com/index.php?ma...roducts_id=106

And tested it by adding an email of my own, confirmation of subscription etc... comes through fine and activates no problems.


When i go into "Newsletter & Product Notifications Manager" to send and email, and click "Send" on the template I have created i get the following 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 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.


This also happens if i go into Customers -> Subscription Manager, then try to send an individual email to one account and also going to Tools -> Send Email, results in the same error.

Any ideas where or why its broken?

Quote:

---

Originally Posted by elbert06

Hello,

I'm having problems with the subscribe sidebox, it doesn't look the way it should. No buttons, only text. When you subscribe it works fine but I know it should look different and better then it does now. I might have different files in the wrong locations. I use zencart 1.39 en subscribe 2.2.2. The template I use is called 12541, and on top of that I use a Dutch language pack. When I set the default language to English it has the same result Could you please have look at my shop at http://www.7ehemeldeal.nl/shop and tell me what I do wrong

waiting desperately for your help

Elbert

---

you need to make sure the language files that come with the add-on are copied into the correct directory in this case: includes\languages\dutch\extra_definitions\12541\newsletter_subscribe_definition s.php

You can then amend the defines to the dutch wording you like it to be

Hi running 1.3.9f and have installed newsletter 2.2.2
I have double checked that all the files uploaded correctly but when i go to admin/customers/subscription manager I get a 404 error??

Sidebox appears fine in tools/layout boxes controler

In my ignorance I assume this means that the sql script has not run??

Would be very grateful for some help.

Thanks Shane

Please ignore my post - appears i was too blond to notice the 3 files in the admin folder - working fine - though not sure why the modified button i inserted did not come thro - sure i can fix that.

Great, this works, thanks for your help!

Quote:

---

Originally Posted by nagelkruid

you need to make sure the language files that come with the add-on are copied into the correct directory in this case: includes\languages\dutch\extra_definitions\12541\newsletter_subscribe_definition s.php

You can then amend the defines to the dutch wording you like it to be

---

Top! This works, thanks for the help!:clap:

HI, I just added Newletter Subscribe v 2.1.1 for Zen Cart. I'm using 1.3.9 I don't see a heading or any buttons I just see text:

BOX_HEADING_SUBSCRIBE
BOX_SUBSCRIBE_DEFAULT_TEXT
HEADER_SUBSCRIBE_DEFAULT_TEXT
HEADER_SUBSCRIBE_BUTTON

I went through your readme file several times and I don't see anything discussing this. I'm using the side box.

Any help would be greatly appreciated.

Quote:

---

Originally Posted by screamingfingers

HI, I just added Newletter Subscribe v 2.1.1 for Zen Cart. I'm using 1.3.9 I don't see a heading or any buttons I just see text:

BOX_HEADING_SUBSCRIBE
BOX_SUBSCRIBE_DEFAULT_TEXT
HEADER_SUBSCRIBE_DEFAULT_TEXT
HEADER_SUBSCRIBE_BUTTON

I went through your readme file several times and I don't see anything discussing this. I'm using the side box.

Any help would be greatly appreciated.

---

this:
http://www.zen-cart.com/forum/showpo...postcount=1028
also applies to you, you will need to rename the template folder to the template name used on your site

I thought I changed them all, but there was one that still needed to be changed. Thank you, that worked.:clap::clap::clap:

Confirmation emails are not sending. Is there something I need to update or change?

Hi All,

Is there a way to change the sign up form text? Instead of just having newsletter I'd like to change it to something else?

Thanks:cool:

Is it a really big deal to be able to send to customers in a certain city, or group? Group would be fine. I could import all addresses from a certain city with a group field set to that city name?

I think as a Mod, it would be highly useful with widespread implementation.

Quote:

---

Originally Posted by screamingfingers

Hi All,

Is there a way to change the sign up form text? Instead of just having newsletter I'd like to change it to something else?

Thanks:cool:

---

I'm sure if you go to admin/tools/developers tool kit/ and do a search for the string "Enter your email address to subscribe to our Newsletter." you will obtain the same results that I do.......

includes/languages/english/extra_definitions/classic/newsletter_subscribe_definitions.php

Hello Zenners
The unsubscribe sidebox from the newsletter only module gives a wrong output. When I try to unsubscribe I can't fill out the email adress (no field to put it in) and when I press the button "afmelden" (= unsubscribe) then it takes me to login page, what am I doing wrong?
I've tried reinstalling but that did not help.

The email address is a genuine newsletter only subscription address in my admin subscription manager.

Please have a look at:
http://www.7ehemeldeal.nl/shop/index...ge=unsubscribe

thanks for your the help

Elbert

Quote:

---

Originally Posted by elbert06

Hello Zenners
The unsubscribe sidebox from the newsletter only module gives a wrong output. When I try to unsubscribe I can't fill out the email adress (no field to put it in) and when I press the button "afmelden" (= unsubscribe) then it takes me to login page, what am I doing wrong?
I've tried reinstalling but that did not help.

The email address is a genuine newsletter only subscription address in my admin subscription manager.

Please have a look at:
http://www.7ehemeldeal.nl/shop/index...ge=unsubscribe

thanks for your the help

Elbert

---

Stupid me! :oops:I must be a blond.............There is a box to put your e-mail address in only you can't see because of the colour scheme. So, next question, where do I alter the colour of the email address box.....

elbert

Quote:

---

Originally Posted by elbert06

Stupid me! :oops:I must be a blond.............There is a box to put your e-mail address in only you can't see because of the colour scheme. So, next question, where do I alter the colour of the email address box.....

elbert

---

edit includes/templates/YOUR_TEMPLATE/templates/tpl_unsubscribe_default.php

add a background color to the style tag...
$content .= zen_draw_input_field('addr', $addr, 'style="width:20em; background-color:#FFF;"');

Quote:

---

Originally Posted by davewest

edit includes/templates/YOUR_TEMPLATE/templates/tpl_unsubscribe_default.php

add a background color to the style tag...
$content .= zen_draw_input_field('addr', $addr, 'style="width:20em; background-color:#FFF;"');

---

Great! This works, what would I be without all you top zenners out there!

Thank you for the input!

Can I ask a question can someone please tell me how to change the "newsletter" button at the top to a button that matches my site. I can not find it anywhere for the life of me. My eye's are officially crossed. Can someone please help me.

Hi,

I use zen cart 1.39h and installed this great module. Everything works exept when a former newsletter-only subscriber decided to create an account. Then the next message appears on the frontend:


1062 Duplicate entry '[email protected]' for key 'email_address'
in:
[INSERT INTO subscribers (customers_id, email_address, email_format, confirmed, subscribed_date) VALUES ( 12, '[email protected]', 'HTML', '1', now())]

In the admin the customer appears in the customerslist.

What went wrong? :dontgetit

Lieke

I just installed newsletter subscribe/unsubscribe 2.2.2 in Zen Cart v1.3.9h and everything seemed to go fine but when i clicked on: Tools/Send Emails I got this error message:

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.

I'm still a novice at this so can anyone explain where I went wrong?

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

Quote:

---

Originally Posted by lweldon

I just installed newsletter subscribe/unsubscribe 2.2.2 in Zen Cart v1.3.9h and everything seemed to go fine but when i clicked on: Tools/Send Emails I got this error message:

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.

I'm still a novice at this so can anyone explain where I went wrong?

---

gettting the same error, I tried changing the collation in the phpmyadmin and the error is showing???????????

Quote:

---

Originally Posted by stevefriedman71

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

---

gettting the same error, I tried changing the collation in the phpmyadmin and the error is showing???????????

i dont know php that well sooo...

On this page, I'd like to remove the HTML and TEXT-ONLY radio buttons...

Please tell me how to do this, thanks!

p.s. I want it to automatically select html.

Figured it out. :cool:

Hi,

I've just installed this contribution. Everything is working fine, expect my 'send email' function under 'tools' is not functioning.

It says: 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 znc_subscribers as s LEFT JOIN znc_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.


Which part of the settings have i not set?
Appreciated if someone could me on this.

I've attached a pic for reference as well.

Gotta preface, I'm a noob, but:

This MOD is FREAKING BRILLIANT for sure! I am so happy to have found this one as it is going to make my life easier in the short run, and I think give customers a very prudent choice about whether or not to give us their full info, but to still be involved with the store.

THANK YOU x 100! And if I may buy you (and the other developers) a drink next time you are in Indy : )

Now, my only question: As bizarre as it sounds, is there an easy way to offer un-subscription, other than directing folks to the unsubscribe page / link (which isn't by default a part of the sidebox, but is easy enough to link to). I just want to make people who do subscribe from the side box or as a result of an email link, to feel that visually it is so easy to unsubscribe that subsribing is a no brainer. Perhaps an integrated page where entering the email and clicking a button in the sidebox or page which says 'unsubscribe' - right next to the subscribe button would effectively get them the reverse of a subscription.

That's a long way to say where is the unsubscribe functionality I guess. Any thoughts are appreciated, I can certainly work with it as is -- GREAT MOD.

JJ

Quote:

---

Originally Posted by cpoet

Hi,

I've just installed this contribution. Everything is working fine, expect my 'send email' function under 'tools' is not functioning.

It says: 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 znc_subscribers as s LEFT JOIN znc_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.


Which part of the settings have i not set?
Appreciated if someone could me on this.

I've attached a pic for reference as well.

---

I have ALMOST the same as you....
The difference is in colour
My website is here

Quote:

---

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.

---

Quote:

---

Originally Posted by stevefriedman71

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

---

How do you do this?

Kind Regards Casey
Personalised Address Labels and more...

Quote:

---

Originally Posted by stevefriedman71

you have to go to phpmyadmin and check the tables. one table has the wrong collation. change that tables collation

---

I got this working. Changed all tables in phpAdmin to latin1_general_ci
which included the ones for the modules:
Poll Box
Rewards Points
News Box

I also changed newsletter and subscriber

I then went to admin >> Customers >> Subscription Manager, uninstalled it and then re-installed and it all works fine.

Kind Regards Casey

I have started another thread but I think this is the tread I should list in. I think the newsletter module is causing the problem.
Here is the problem. The newsletter module is working like it is suppose to. I can send newsletters to the ones who want them, I just can't send out regular emails to any customers who is not sign up. In other words a customer that is not sign up for the newsletter I can not send them a regular email when I select admin/send mail.
I mean if a customer bought something from me and paid for that item and I notice afterward the item is out of stock that they bought, now I need to email the customer to let them know whats going on but this particular customer is not sign up to our newsletter the system will not let me email them for some reason.

That was a long thread to read!!! As anyone figured out how to add the unsubscribe link to the newsletters?

I did not try before installing this module, so I am not sure it's supposed to be there in the first place.

The Email Options>Newsletter Unsubscribe Link in my admin is well set on true.

Apart from adding it manually when sending newsletters, I couldn’t find any solution in the forums.

Thanks!

Hi!

I have downloaded the zip file and try to install. But i can't find any sql in the package that allow me to update the database.

I have download all the version in the listing but still can't find one. Can anyone help?

Quote:

---

Originally Posted by Thannaree

That was a long thread to read!!! As anyone figured out how to add the unsubscribe link to the newsletters?

I did not try before installing this module, so I am not sure it's supposed to be there in the first place.

The Email Options>Newsletter Unsubscribe Link in my admin is well set on true.

Apart from adding it manually when sending newsletters, I couldn’t find any solution in the forums.

Thanks!

---

Zen Cart automatically adds the unsubscribe link to "html" newsletters regardless whether you use this mod or not

Text only emails are the problem.
Zen adds an unsubscribe link, but it requires the user to login.
Again regardless if you use this mod or not.

Quote:

---

Originally Posted by kwan_kwan08

Hi!

I have downloaded the zip file and try to install. But i can't find any sql in the package that allow me to update the database.

I have download all the version in the listing but still can't find one. Can anyone help?

---

goto...
admin->customers->Subscription Manager
Click the "Install" button
This automagically does the sql required

Quote:

---

Originally Posted by countrycharm

I have started another thread but I think this is the tread I should list in. I think the newsletter module is causing the problem.
Here is the problem. The newsletter module is working like it is suppose to. I can send newsletters to the ones who want them, I just can't send out regular emails to any customers who is not sign up. In other words a customer that is not sign up for the newsletter I can not send them a regular email when I select admin/send mail.
I mean if a customer bought something from me and paid for that item and I notice afterward the item is out of stock that they bought, now I need to email the customer to let them know whats going on but this particular customer is not sign up to our newsletter the system will not let me email them for some reason.

---

Does :blink:anybody have and answer for this?

Code:

---

Zen Cart automatically adds the unsubscribe link to "html" newsletters regardless whether you use this mod or not

Text only emails are the problem.
Zen adds an unsubscribe link, but it requires the user to login.
Again regardless if you use this mod or not.

---

Thanks for confirming this. However, I've tried again, both in html and text-only, and the link isn't there. I use the latest ZC. Do you know what could cause this?

thanks gilby.

I just figured it out. I can't find the admin->customers->Subscription Manager because i have install user access control module. That's why i can't see it in the customer menu.

I have enable it and able to intall it.

Thanks

Hi all,
This is my first time posting a question here. Sorry it's the question has already been addressed before in this thread but I wasn't able to go through >100 pages in this thread to find my answer.

I've followed the installation instructions & everything seems to work well, except that I couldn't find the Newsletter sign-up box/form at the header or sidebox. Is there any error made or omission by me?

Thanking in advance for your help & guidance :smile:

Quote:

---

I've followed the installation instructions & everything seems to work well, except that I couldn't find the Newsletter sign-up box/form at the header or sidebox. Is there any error made or omission by me?

---

1) I think that you have to physically click the install button for the subscription manager mod via admin->customers->subscription manager before it is activated.

2) Next, under admin->configuration->layout settings you must check out the item labeled "Show Newsletter-only subscription field in header?" and make sure it is set appropriately to determine whether the sub mgr is located in the header or as a sidebox.

3) If it's set as a sidebox in #2, did you try to turn on the sidebox in admin->tools->layout boxes controller? You should have a sidebox something like sideboxes/YOUR_TEMPLATE/subscribe.php" which needs to be turned on with the appropriate settings.

HTH.

Jason

Thanks Jason so much for your guidance... didn't expect a response so soon :smile: I'm ok with Step 1 & 2 below but couldn't find the subscribe.php in the Layout Boxes Controller... what would possibly have gone wrong?

Quote:

---

Originally Posted by lindenboy

1) I think that you have to physically click the install button for the subscription manager mod via admin->customers->subscription manager before it is activated.

2) Next, under admin->configuration->layout settings you must check out the item labeled "Show Newsletter-only subscription field in header?" and make sure it is set appropriately to determine whether the sub mgr is located in the header or as a sidebox.

3) If it's set as a sidebox in #2, did you try to turn on the sidebox in admin->tools->layout boxes controller? You should have a sidebox something like sideboxes/YOUR_TEMPLATE/subscribe.php" which needs to be turned on with the appropriate settings.

HTH.

Jason

---

When you copied the add-on files to your server are you ABSOLUTELY SURE that you found EVERY instance of YOUR_TEMPLATE and change it appropriately to the actual template name?

I say this for 2 reasons: 1) This appears to be the reason behind many add-ons not working upon installation and 2) Because there are SEVERAL locations within the subscribe add-on files structure which require you to change the default template folder name (YOUR_TEMPLATE) to your actual template name. One in particular that I just looked at is buried in "includes/templates." This happens to be where the sidebox contents are location. Without this path being correct, the admin console wouldn't know you added a sidebox.

When you finished installation and pulled up the layout boxes controller, were you greeted with a message at the top that said something like "new sideboxes found?" If not, you definitely did not copy over the correct file structure.

As a newb myself, I can confidently stress that making sure the file and folder structure is correct is the #1 priority when installing add-ons; I have about 10 under my belt to date, all of which work flawlessly. #2 by the way is simply following the instructions to a T.

HTH.

Jason

i installed all the files but i have the follow error message.

ERROR: The email template file for (/home/muytruch/public_html/email/so/email_template_) or (/home/muytruch/public_html/email/so/email_template_subscribe.html) cannot be found.

any idea of how to fix it ?

Hi I'm having the same problem as Integrity Designs on the page before... i just have no idea what i've done to cause this error message and re-uploading the files doesn't seem to be doing the trick so I imagine i'm putting something in the wrong place? If anyone's got any clues I'd greatly appreciate it...

Error when going 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 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.

Quote:

---

Originally Posted by CheekyCockney

Hi I'm having the same problem as Integrity Designs on the page before... i just have no idea what i've done to cause this error message and re-uploading the files doesn't seem to be doing the trick so I imagine i'm putting something in the wrong place? If anyone's got any clues I'd greatly appreciate it...

Error when going 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 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.

---

Small update: After some more searching I have ventured into phpMyAdmin and checked out the collation settings. In 'subscribers', the collation for email_address, email_format & confirmed are all set to 'latin1_swedish_ci' which i'm lead to beleive is correct.(?) But every other collation setting in my database is set to 'latin1_general_ci'. I imagine this could cause an 'illegal mix' as the error suggests?

Hopefully this helps, I have absolutely no idea what I just said.

Me again. I was brave and changed the 3 swedish collation settings to general... and it now seems to work. Which is good news, but I'd still like someone to let me know what I did wrong... and actually how I fixed it if anyone has a clue!

Thanks

Hey guys, I did the installation and is working very good but the only problem that i have when i make an email to send to the customers i use html and it only send text, so i can't not send images or colors. please help me.

i install to see if i can fix this problem a new editor but i see and i use the editor but when i sent is only text.

Please help me to fix it.

Hi, I got a problem when I tried to install this module on v1.3.9h.
I have copied all the files to Zen cart folders, and when I clicked the botton <Install> at Admin panel, the below messages came out and I had nothing to do with it.

------------------------------------------------------
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
in:
[ CREATE TABLE IF NOT EXISTS zen_subscribers ( `subscriber_id` int(11) NOT NULL auto_increment, `customers_id` int(11) default NULL, `email_address` varchar(96) NOT NULL default '' UNIQUE, `email_format` varchar(4) NOT NULL default 'TEXT', `confirmed` varchar(8) default NULL, `subscribed_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`subscriber_id`) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

--------------------------------------------------------------------------

I am using:

Database: MySQL 5.5.8
PHP Version: 5.3.5 (Zend: 2.3.0)
Server OS: Windows NT
HTTP Server: Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1
@localhost XAMPP


Can anyone help me out?
Thanks!

For all the "duplicate email address" errors that you are getting from your store - I looked into it and it was actually ignoring the UPDATE SQL statement in create_account.php, the reason that it was ignoring it look to be as it was checking to see how many customers_id's were present - as the customer isn't a customer yet it would always come back 0 - therefore try to INSERT rather than UPDATE

Made 1 tweak too:

includes/modules/YOUR_TEMPLATE/create_account.php

line 320 & 321 change to this

Code:

---

$check_subscribers_sql = "select count(subscriber_id) as total from " . TABLE_SUBSCRIBERS . "
                                                              where email_address = :email:";

---

just changed customers_id too subscriber_id in count statement

Working for me on 1.3.9h

Thanks
Sarah

Hi I hope im doing this is the right place.
I just installed this in version1.3.9h as well and I didn't get the error when installing it everything seemed to be working fine till I got to where you go to Tools/send email.

Then I get this message:

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 wzc_subscribers as s LEFT JOIN wzc_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.


If someone could point me in the right direction as to how to fix this they would be my hero. LOL

Thanks,
Suzanne

Please forgive me I did not see the post that was excatly the same as mine further up this thread.

The solution about changing the db setting from swedish to general does seem to be the solution. It worked for me as well.

Thanks again,
Suzanne

i am using zen car 1.3.9h
I wanted to send a newsletter and when i hit the send button this is what I got:

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 znc_subscribers as s LEFT JOIN znc_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.

Quote:

---

Originally Posted by shorti6877

i am using zen car 1.3.9h
I wanted to send a newsletter and when i hit the send button this is what I got:

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 znc_subscribers as s LEFT JOIN znc_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.

---

Look at the post right above yours. This has been answered at least a couple times before.

thanks i didnt realize it..i seem to have fixed it..now a new problem of newsletter only sending in text format..will need send in HTML ugh

Quote:

---

Originally Posted by shorti6877

thanks i didnt realize it..i seem to have fixed it..now a new problem of newsletter only sending in text format..will need send in HTML ugh

---

See here:
http://www.zen-cart.com/forum/showthread.php?t=163280

Quote:

---

Originally Posted by shorti6877

thanks i didnt realize it..i seem to have fixed it..now a new problem of newsletter only sending in text format..will need send in HTML ugh

---

I know what you mean. That issue took a bit more work but if you search through the forums, I know the answer is there. (I would just tell you how, but I fixed it so long ago, I can't remember.) :smile:

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

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

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

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

Anyone knows what's wrong?

Thank you in advance!

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

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

Quote:

---

Originally Posted by kwrosenzweig

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

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

---

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

PHP Code:

---

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


---

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

Cheers

Pacu

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

Thanks for replying, I will stick with it then.

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

Thanks

Quote:

---

Originally Posted by raunharman

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

Thanks

---

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

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

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

Quote:

---

Originally Posted by somi97

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

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

---

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

Quote:

---

Originally Posted by somi97

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

---

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

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

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

Thank you!

Zen Cart version v1.3.9d

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


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

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

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

Jeff

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

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

Does anyone know how I could fix this?

Thanks!
(We use ZC v1.3.9h)

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

Quote:

---

Originally Posted by msphamtastic

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

---

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

Quote:

---

Originally Posted by countrycharm

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

---

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

Quote:

---

Originally Posted by Thannaree

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

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

Does anyone know how I could fix this?

Thanks!
(We use ZC v1.3.9h)

---

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

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

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

Quote:

---

Originally Posted by SincoS

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

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

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
in:
[ CREATE TABLE IF NOT EXISTS zen_subscribers ( `subscriber_id` int(11) NOT NULL auto_increment, `customers_id` int(11) default NULL, `email_address` varchar(96) NOT NULL default '' UNIQUE, `email_format` varchar(4) NOT NULL default 'TEXT', `confirmed` varchar(8) default NULL, `subscribed_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`subscriber_id`) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Maybe there is a common mistake that i made

---

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

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

around line 114

change

PHP Code:

---

) TYPE=MyISAM;"); 


---

to

PHP Code:

---

) ENGINE=MyISAM;"); 


---