Verification Emails are NOT getting sent

Alex,

I have addressed my issue to your support department but they have not been able to clearly respond to my issues. I have asked them to escalate my ticket to you.

Yesterday, I generated over 200+ new members, but NONE of them received a verification email. Therefore every member was marked as PENDING.

I could not afford to lose more members because they could not access the member's area. So I went ahead and UNCHECKED the "Verify email" feature so that new members can log in.

But that leaves me with an existing problem...

PROBLEM: The existing members, who are PENDING, still Cannot log in.

Therefore, the only option I have is to MANUALLY click on each member, go to the "User Payments" tab, clicking the EDIT button for their subscription, checking the "Completed" box, and then clicking SAVE.

As you can see that is a LOT of manual work, especially for over 200 member accounts.

So I was hoping that there would be a MASS-export and MASS-import feature that could allow me to modify the "Completed" field value for ALL users at the same time.

Here's what I tried:

--> I exported all of my user data using the EXPORT function. I made sure to export the Payment data also
--> I opened the CSV file in Excel and found the "Completed" field
--> I noticed that all of my PENDING members had a value of "0" in the "Completed" field
--> I changed the Completed field to a value of "1" for all existing pending members and saved the file
--> I went back to my Amember Admin panel and clicked on the IMPORT function
--> Inside the IMPORT function, I'm wondering how to map all the original data I exported back into the database

Because I am only given a limited # of fields to import, whereas the EXPORT file contains many more fields including IP Address, Internal Member #, etc.

QUESTION: Is there a way to get all my data back, while marking every new member as "Completed", "Paid", and "Active"?

Is there an SQL statement I can use to perform all of this in MASS so that I do not need to manually go through each record?

Thanks in advance for your assistance.

HL

Hi!

STEP 1:
SQL Query you need is:

UPDATE IGNORE amember_members SET
status = '1'
WHERE status='0'

The above will make all the members to show completed status. Now the status of each member in the member record will show Active but not yet in the overview. They will still remain shown as Expired until the completed informnation exists in the member[data][status] information.

STEP 2:
You must also have products. Make sure that you have products in the amember_products.

If not, add the products i.e. subscriptions.

STEP 3:
Rebuild the database.

By rebuilding the database, all the completed payment information of members as well as the product/subscription mapping will be entered in the amember.member>data i.e. member[data][status] field.

Thereafter each member will be shown as "Completed", "Paid", and "Active" also in the overview and is then fully a registered member, regardless of email verifications, payments, etc... and has full access to their subscriptons.

Hope this helps.

I do not like the member[data][status] field and the import routines.
There are also many more tricks that I have discovered. Let me know if you need to know more...

Hi Alex!

In total I have imported about 40.000 users and got the status changed exactly described above. I have got my site running successfully. I had really no problems. Only after doing all the above, I did rebuilds.

Further, I did not rebuild the database all the time as it was eating all the CPU power for so many users. So I kept it like it is, i.e. the status changed manually. The users could wonderfully login.

Before the rebuilds, the users could not be searched through admin and did not apear correctly in the reports.

But the remaining worked fine until a moment came in the week-end when there was less load to allow rebuilds. Only then I triggered rebuild for scripts to calculate, what you suggested, and let it enter some extra information in this binary field.

Hi!

One thing what I did and that is not in my description above is

EMPTY THE DATA FIELD!

This field did and does create such a nightmare in my installation. The nightmares began with the imports and they are still going on. Its like flying an Airplane on bumpy winds!

I deleted the entire data field if starting from scratch or empty where the status is pending, before rebuilding. Since I was begining from scratch and this field was not containing much of information, I could do that.

In your case, you could delete i.e. make it empty for th case where status is pending.

In this field, there is a lot of garbage stored that creates disharmony.

When you rebuild, the entire data field is re-written from new.

Certain status situation will also get deleted, like verification email sent, etc. However your task is to get your users going, login and make them happy rather than otherwise...

Thanks Draj and Alex for the SQL suggestions.

Hi!

You are welcome. But did you make it work. Others could profit from it.

Supplementary Question:

How can I automatically IMPORT a range of User details and ensure that EITHER they receive a "VERIFY your email address" email Or at least receive the first SIGNUP email. I just can't get this to work automatically.

e.g.

If I import a load of users using IMPORT facility, In Import field
I allocate them a Subscription Type & PAYMENT (e.g. Free) and then load them ..

They are still left in STATUS: EXPIRED (Pending). also they do not receive a Subscition email as defined in the Setup/configuration or indeed in the Product options.

Any ideas?