Newsletter-Only Subscriptions for v1.3x

[kamelion0927]

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.

[towerhealth]

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

[kodybear70000]

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

[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

[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');

[SaraJacobson]

@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)

[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

$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

$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

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

to

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,

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

should actually be

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).

[kodybear70000]

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!

[timmy852]

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

[gsdcypher]

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.