Newsletter-Only Subscriptions for v1.3x

Ok, I reloaded the orriginal file by ftp and all is fine!
One of those misterious things...
Thanks

Not been able to locate this in the thread, but have got this error message in a ZC1.3.0.2 as soon as I click the email button.```
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 ':admin_id' at line 1
in:
[select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from zen_admin where admin_id = $SESSION:admin_id ]

I'd appreciate any advice on this.

Ryk:

Not been able to locate this in the thread, but have got this error message in a ZC1.3.0.2 as soon as I click the email button.```
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 ':admin_id' at line 1
in:
[select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from zen_admin where admin_id = $SESSION:admin_id ]

> 
> I'd appreciate any advice on this.

That is a reference to this thread:
<http://www.zen-cart.com/forum/showthread.php?t=38281>

If you use that, you also need to make edits to audience.php (in catalog includes section...email seems to draw from there rather than admin)

-Ng_

Actually, the code NotGoddess posted a link to is "already" built-in to v1.3.0.2.

However, if you're getting that error, you likely missed upgrading your /includes/functions/audience.php file.

An odd one that as I'd updated (twice) with the most recent version which I downloaded this evening - unless it failed to transfer via FTP.

However, following the edit, everything now works fine! Thanks.

Just an update-
I'll be putting out the final release this week. Apologies for the delay, but RL takes precedence. :(

-Ng_

NotGoddess:

I can do that. It's actually a good idea to allow a page (or sidebox) with allows both subscriptions and removal at once (I've been depending on the 'unsubscribe' link supplied with the cart).

If you'll give me a day or so I can get it out for you-I have to rewrite the subscribe/unsubscribe processing to properly using multiple submits.

-Ng_

I am also looking for code for a page like this. Has it been posted somewhere?

Any news on the updated version?

Also, has anyone used the Zen Cart newsletter system to send the newsletter to over 1000 users?

If so, have you had any problems with the script timing out or other problems?

flakrat:

Also, has anyone used the Zen Cart newsletter system to send the newsletter to over 1000 users?

If so, have you had any problems with the script timing out or other problems?
Yes, and yes. Alternative: http://www.zen-cart.com/forum/showthread.php?p=216150#post216150

after subscribe successful, press refresh on the borwser
or click more than once on the link to confirm subscription in email
then;
Warning: require(includes/templates/template_default/templates/tpl_subscribe_header.php) [function.require]: failed to open stream: No such file or directory in C:\wamp\www\includes\modules\ilync\subscribe_header.php on line 20

Fatal error: require() [function.require]: Failed opening required 'includes/templates/template_default/templates/tpl_subscribe_header.php' (include_path='.;C:\php5\pear') in C:\wamp\www\includes\modules\ilync\subscribe_header.php on line 20

is this normal, or did I do anything wrong ??

Eric

ericpeng:

includes/templates/template_default/templates/tpl_subscribe_header.php) [function.require]: failed to open stream: No such file or directory
I'd start by making sure the indicated file is actually on your server ...

Hi,

Just wondering if this mod is good to go with v1.3.5 or should I save myself some time and energy (maybe even frustration) and wait for the update?

Cheers,

Colin

I just reinstalled it after the upgrade and am having some troubles...

is it not compatible with v1.35? or am i just too tired..

I haven't tried it on 1.3.5 but I have it running perfectly on 1.3.0.2 sites. May I remind people that before loading any mod it really should be habitual to do a file compare.

Obviously, those mods which create completely new files are a different matter, but anything that touches core files, or even previous overrides, needs to be checked first.

I hear you loud and clear...

works fine on all my 1.3.0.2 sites as well...

it was about the 10th mod i've installed tonight.

gonna give it a fresh start tomorrow. just wondering if anyone had gotten it perfect, to eliminate the wonder...

thanks again.

I'm checking 1.3.5 compatibility now (It'll take a few hours for full check).

I'm still completely bogged down with work but since this is a security I'll move things around and get any changes out as soon as I can.

-Ng_

@ericpeng
Just copy the tpl_subscribe_* files in your templates/yourtemplate/templates/ directory into template_default and you'll be fine (no need to overwrite the unsubscribe template...you do that in your own template).

Due to an initial misunderstanding of how things work those files weren't added to the default_template folder.

ericpeng:

Warning: require(includes/templates/template_default/templates/tpl_subscribe_header.php) [function.require]: failed to open stream: No such file or directory in C:\wamp\www\includes\modules\ilync\subscribe_header.php on line 20

-Ng_

Thanks NG,

when its ready to go, I'll install and help spread the word...

NotGoddess,

Installed your Newsletter-only mod today and it all works fine .. at least it isn't doing anything strange that I've spotted yet.

Did a careful comparison of files for those I know I've changed and that changed in the 1.3.5 update and after going crossed-eyed it all worked.

Thanks for the mod,

Pete

There don't seem to be any conflicts with zc1.3.5, other than the template_default issue mentioned earlier.
I'm trying to get the new release out-I thought it would be sat/sun but I ended up having two emergencies to handle. I'm going to work on it tonight, but unsure if I'll get it out as I'm exhausted (5hrs sleep out of 48hrs = bad) and will likely need to (try) to sleep early. Tuesday night-wed is the best bet.

-Ng_