audradh:
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_
