Newsletter-Only Subscriptions for v1.3x

[NotGoddess]

Yes, actually it does.

Looks like on one (or more) of the statements I'm doing "insert into query_builder ...yada yada' where it should be:

"insert into " . TABLE_QUERY_BUILDER . " ..... "

I here's a replacement file. This goes in:
/admin/includes/functions/extra_functions/subscription_manager.php

-Ng_

[NotGoddess]

Here is the pages/subscribe/header_php.php file with those changes mentioned in a prior post.

I will incorporate all of these later into a patch.

remember to backup prior to installing.

-Ng_

[woodlandsprite]

oh ho! And that did the trick - no errors on the recent "update" and the test email group is now availible in the emal tool :)

You're wonderful

[NotGoddess]

Good. I'll build another release and/or get those patches on my site tonight.

[audradh]

I am running the old version of subscribe (1.1 I think it is) on Zen 1.2.7
I think the SQL tables are the same on the new version, so I am going to ask my question here.
In the admin panel->Tools->Subscription Removal I find some addresses are duplicated. I am fairly sure that those addresses are the accounts that existed when I installed the module. I also suspect that I caused the trouble. It was a while back, but I think I ran into a bit of trouble when I ran the initial SQL query and ended up running it twice or some such ignorant thing.
Looking in phpmyadmin I find 2 tables, a customers table and a subscribers table. The offending customers are, indeed, listed in both tables. In the customers table they are simply listed as being subscribed to the newsletter by way of a "1" in the Newsletter field. In the subscribers table those same customers have 2 separate entries in which the customers_id is the same in each entry, but the subscriber_id varies, a lower number (presumably the original) and a higher number (presumably a subsequently created value.)
I could simply sort the table by email address and delete half of the entries, but I wanted to be sure I am not aggravating the problem further. Which entry should I retain, the lower subscriber_id value or the higher, or no matter?
Is there a simple SQL query that I can use to effect the cleanup? You may have gleaned that I am SQL illiterate (just another livin'-on-the-edge Zenner playing w/ danger she knows not of...)

Thanks for any help, and feel free to kick me off this thread if the new version has taking a path so different as to make my post irrelevant here,

Best,
Audra

[NotGoddess]

Audra,

Let me rephrase so as not to misunderstand. By duplicate you are meaning one in the customer table and one in the subscriber table, correct?

This is not an error-you see both contribs keep ZenCarts structure and method intact.
So customers have an entry in both tables, while news-only subscribers are only found in the subscriber table.

Are you experiencing other issues that caused you to look into this?

-Ng_

[NotGoddess]

On my site is a patch comprised of the files above to address the update sql errors and subscriber notification glitch.

I'll be releasing the manager patch tonight/tomorrow.

-Ng_

[audradh]

No, there are two entries for these customers in the subscriber table as well as the one entry in the customer table.

[NotGoddess]

No, there are two entries for these customers in the subscriber table as well as the one entry in the customer table.

Okay, you say you aren't too sql-savvy, but can you use phpMyAdmin? If so, this is the easiest way to fix this. We're going to get rid of the customers and re-insert them.

First, check and make sure you still have the customer transfer file that came with that contribution called subscribe_transfer_data.php
It's probably in your root directory, altho directions might have had you put it in admin.

Select the subscribers table. Click on the export tab. Check the 'export data' box and 'complete inserts' (you can leave others as what they are). Export all data and save as a .sql file on your computer. (we're making a backup of the data, just in case.

Verify that you do indeed have a backup. :)

Now select the [sql] tab and enter this query:
SELECT FROM subscribers WHERE customer_id NOT NULL
(I'm working from memory. It might be IS NOT NULL or <> NULL)

What should come up is a list of all the customer accounts. You can look at the customers_id column to be sure. Click on that to sort by it.

Now you have a choice depending on how many customers you have.
If you don't have too many, you can check the box on each duplicate record (so one is checked, one is not), then at the bottom of the list you should see the option to delete the checked boxes.

If you have too many, first verify that your query only brought up customer accounts, then change the SELECT to DELETE and run it. This will delete ALL customer info in the subscribers table. If you do this then you need to run the subscribe_transfer_data.php program again (just point your browser to that page).

-Ng_

[barco57]

i tried to send my newsletter out, using "all newsletter subscribers" and I got the following error:

Please wait .. sending emails ..

Please do not interrupt this process!
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 '[email protected]'' at line 1
in:
[SELECT count(*) as count FROM zen_subscribers WHERE email_address = '[email protected]'[email protected]']
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 just don't know what to do next to fix it, actually I should say I don't know what to do first to fix it.