Newsletter-Only Subscriptions for v1.3x

[picou]

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

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

[NotGoddess]

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_

[DrByte]

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.

[Ryk]

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.

[NotGoddess]

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

-Ng_

[bucktoothmama]

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?

[flakrat]

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?

[DrByte]

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/showth...150#post216150

[ericpeng]

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