Newsletter-Only Subscriptions for v1.3x

[Ken Joy]

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

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!!

[sunnyokanagan]

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

[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

[Astarkley]

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?

[jmp04]

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?

[nagelkruid]

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

[shanesoine]

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

[shanesoine]

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.

[elbert06]

Great, this works, thanks for your help!

[elbert06]

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!