Newsletter-Only Subscriptions for v1.3x
I've upgraded the original 1.2.7 Subscribe! contribution, merged in the 1.2.7 newsletter_unsubscribe contribution, and added quite a number of new features of my own.
The end result is Newsletter Subscribe V2.0
Please let me know what you think and report any problems you may have.
-Ng_
Re: Newsletter-Only Subscriptions for v1.3x
The contribution is now in the downloads section, under 'Other Modules'. Updates will be placed there, so please download from that section.
Thank you for the quick approval!
-Ng_
Re: Newsletter-Only Subscriptions for v1.3x
Hello All,
This mod sounds brilliant, so I had to try it. So far, I am at the install stage on the Subscription Manager. This is what comes back when I press the button:
1146 Table 'thegemtr_zc2.query_builder' doesn't exist
in:
[DELETE FROM query_builder WHERE query_description = 'Returns name and email address of all Customer Account subscribers and all Newsletter-Only subscribers.']
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 not sure what to do, I am guessing it could be a SQL setup thing. Any help would be gratefully received.
Regards,
Russ
Re: Newsletter-Only Subscriptions for v1.3x
It would have been a pleasant first to discover all the testing actually uncovered everything. *sigh* I forgot to hold update the database installation so it calls for the table name (prefix + query_builder). Give me 10 min and I'll post an upgrade.
Re: Newsletter-Only Subscriptions for v1.3x
I was about to install this add-on. I guess it is a good idea I checked the support forum first :) Thank-you Notgoddess for this add-on, it looks like a good module. When you say you're going to upload an update, is that going to be on the downloads page or this thread? Is there going to be a second file on the download page? Thanks again.
Re: Newsletter-Only Subscriptions for v1.3x
I've uploaded the updated contribution but updates have to be reviewed by the staff.
You can wait until you see version 2.0.1 or grab it from my website:
http://www.notgoddess.com/scripts/newsletter-subscribe
Re: Newsletter-Only Subscriptions for v1.3x
Hiya,
Thanks for getting back to me. Just to say it is working A.O.K and is chuffing brilliant!!
Regards,
Russ
Re: Newsletter-Only Subscriptions for v1.3x
I found one typo in this excellent contribution. A SQL error appeared when I deleted a customer account.
admin/customers.php
On line 343, change
where customer_id = '" . (int)$customers_id . "'");
to
where customers_id = '" . (int)$customers_id . "'");
(changed customer_id to customers_id)
Re: Newsletter-Only Subscriptions for v1.3x
Quote:
Originally Posted by alanpace
I found one typo in this excellent contribution.
Thank you for finding that!
I've added the correction and upgraded the version to 2.0.2
-Ng_
Re: Newsletter-Only Subscriptions for v1.3x
Thanks for the contribution NG. I am looking to do a mass import of newsletter only subscribers. Is there an easy way to do this?
Thanks