Newsletter-Only Subscriptions for v1.3x

[NotGoddess]

Oh, in case anyone is wondering, the wishlist so far is:

Additional query groups for testing newsletters.

Ability to import/export subscribers (so if you want to use zen for subscriptions, but want to use a more flexible newsletter program to actually send them).

Adjust unsubscribe so it will prefill email field when email is sent (user still has to confirm).

Fix the newsletter script itself (occassionally errors out sending large groups) or at least note what emails were sent so manual fixes can avoid duplication.

Add cc to admin email + config. maybe a 'new' list on index page or manager page.

[wildgarden]

I have installed the newsletter subscribe add on and it's been working well so far but I was trying to create a test account using the install patch. Anyway I was getting a syntax error with my code and clever me (!) with no knowledge of mySQL went into phpmyadmin and deleted the whole query_builder row thinking this would solve my problem but now i'm getting an error message saying:

1146 Table 'wildgard_shop.shop_query_builder' doesn't exist
in:
[select query_name, query_string from shop_query_builder where query_category like '%email%']

So i'm thinking I need to restore this table but how do i do that? HELP PLEASE!

[wildgarden]

Don't worry about the above. I figured it out on my own. I just had to insert a create table query :$ crisis adverted!

[NotGoddess]

Good to hear you came through it okay.
-Ng_

[nielest]

sorry for the repost. server lag.

[nielest]

Does anyone know where all the emails are stored when a new subscriber subscribes. I mean in the ftp server, is there a particular txt file, etc that logs all the emais down onto 1 sheet.

thanks!
Niele

[kookiewookie]

Hi.... i am using zencart 1.3x and newletter only ....2.2 but i get an sql error when eidting and saving something in the clients information ( admin/customers.php )

Error is:

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 'confirmed = 1 WHERE customers_id = '2'' at line 4
in:
[UPDATE soemprefix_subscribers SET email_address = '[email protected]', email_format = 'TEXT' confirmed = 1 WHERE customers_id = '2' ]
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 have no clue...what is wrong here..

[NotGoddess]

Does anyone know where all the emails are stored when a new subscriber subscribes. I mean in the ftp server, is there a particular txt file, etc that logs all the emais down onto 1 sheet.

thanks!
Niele

The email template itself is in email/email_template_newsletter_subscription.html
The english text for the template is in includeds/languages/english/(your_template)/subscribe.php

[NotGoddess]

Error is:

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 'confirmed = 1 WHERE customers_id = '2'' at line 4
in:
[UPDATE soemprefix_subscribers SET email_address = '[email protected]', email_format = 'TEXT' confirmed = 1 WHERE customers_id = '2' ]
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.

There is a comma missing.
Edit customers.php at at the end of line 274, add a comma:

	email_format = '" . $customers_email_format . "', <----

The entire query:

$db->Execute("UPDATE " . TABLE_SUBSCRIBERS . " 
	 SET	email_address = '" . $customers_email_address . "',
	email_format = '" . $customers_email_format . "',
               confirmed = 1
	 WHERE	customers_id = '" . (int)$customers_id . "' ");

Sorry!

-Ng_

[nielest]

The email template itself is in email/email_template_newsletter_subscription.html
The english text for the template is in includeds/languages/english/(your_template)/subscribe.php

Thanks for your reply Not Goddess, although i think i've not explained myself clearly enough. Alow me to try once more, i sincerely thank you for your time.

What i wanna know is where the emails from the newsletter subscribers get stored on the ftp server? Like if i enter my email in the subscribe list where does it get written to on the FTP, i ask this in hopes of editing that file to add more emails from an external email set i've accumulated over the years of my clients.

I hope this helps.

thank a million!
Niele