Thread

Hi I have the forum 2.1 and have noticed the following irregularity.

I tied to register myself into the forum, where I have the require self activation setting ON.

I have received the email to activate with the link, which I have clicked and gone through to the page where it says the account is now activated.

Your membership account has been activated and is ready for use.

However when I go to login to the forum it tell’s me that

Your membership account has not been activated yet.

I have logged in as a super admin and gone to the admin/ members and groups/ activate pending members and I am still listed as a pending member.

please could you tell me what i’m doing wrong or which setting I have wrong.

I’ve had a look at the database at the following tables and there seems an irregularity:

exp_members                     199   MyISAM   latin1_general_ci   70.2 KiB   -
 
exp_member_data                   202MyISAM   latin1_general_ci   6.4 KiB   -
 
exp_member_homepage               202   MyISAM   latin1_general_ci

Thank you
Kelli

Ps I can send emails from the communication panel and I am using ExpressionEngine 1.6.4 - © Copyright 2003 - 2008 - EllisLab, Inc.
Script executed in 0.1753 seconds   13 SQL queries used
Build:  20080626

any help would be appreciated.
thank you
Kelli

after further investigation of the tables
I seem to have a duplicate member in the exp_member_homepage database and an additional member also with this table who is not listed in the exp_members table which equates to the discrepancies.

Would it be advisable to delete the duplicate member in the exp_member_homepage and delete the extra member int the exp_member_homepage.

thank you for your help.

Kelli, if you are going to make changes to your database, please make sure you back up the tables before modifying them.

The good news is that only the exp_members table has an auto_increment field.

See if removing that extra row fixes the problem.

Hi Sue,
So I managed to delete the extra member and duplicate members in exp_member_homepage, exp_member_data and the all three tables are equal,
I’ve looked around the site, loged in as super admin etc and all seems fine,

I activated the pending member, however when the page refreshes with activated member, presumably there should be the name of the activated member which there isn’t.

I receive an email advising me that the member is activated,
but when I try an log in as the member

I am told that I have not been activated yet and my membership is still pending.

thank you Expression Engine support staff for your help.

I further tested it by creating another new member and received the activation email which I clicked and went to the screen
‘Thank You!

Your account has been activated.

You may now log in and begin using it.’

I then go to the login page and enter my new member username/ password

and receive the following message:

Your membership account has not been activated yet.
Return to Previous Page

Also I checked the database to see if it added the new member correctly and all 3 tables exp_member, exp_member_data, exp_member_homepage are all showing an equal number and an increment of one (the new member)

thank you

Any extensions being used?  And if you go in and take a look at exp_members- those new registrations AFTER they click the email- what member_id are they?  And if you go to ‘Admin- Members and Groups- Member Prefs’- what do you have as the default member group assigned to new members?

Hi Robin
Thank you for looking into this post for me,

the two new testing members that I added are sequentially numbered 946 and 947 within the exp_members table

FYI there are within the CP Home ›  Admin ›  Members and Groups ›  Activate Pending Members,
an additional 5 pending members who have recently joined the forum, but are still pending.
There are numbered: 941,942,943,944,945.

Within the
CP Home ›  Admin ›  Members and Groups ›  Membership Preferences
I have the following settings:
Allow New Member Registrations?
Yes    
Require Member Account Activation?
self activation via email
Require Terms of Service
Yes      
Allow members to set their own localization preferences?
If set to “no” all dates and times will be localized to the master site default.
Yes    
Enable Membership Captcha
Yes  
Default Member Group Assigned to New Members
If you require account activation, members will be set to this once they are activated
pending
Default Member Profile Theme
Default
Profile Triggering Word
When this word is encountered your URL it will display your member profile area. The word you choose can not be the name of an existing template group
member

I will try and change
Default Member Group Assigned to New Members
If you require account activation, members will be set to this once they are activated
pending
to
members,

if this works then I misunderstood what this means, I thought that once a new member clicks the link they go from pending to a fully registered member.

best
Kelli

And guess what it now works I’ve managed to log in one of my test memberships as a member,

SO this is a case closed.

Thanks for the prompt.

Kelli

Heh- yep, we may need to tweak the wording on that one.  It’s tripped a few people up.  Pending is basically pending- and it’s where they go when they’re pending.  That setting is for where they go once they’re ‘real/full/non-pending’.

But- glad that got you squared away.  I’ll go ahead and close this puppy out!