Skip to:
Content
Pages
Categories
Search
Top
Bottom

New User Registration Problem: Invalid Activation Key

  • Avatar of simple-man
    simple-man
    Participant

    @simple-man

    Hi,

    I created a test account using regular buddypress registration form.

    On the “Activate Your Account” page, it said we have sent an email to you to activate your account.

    I logged into my email, and clicked the link in the email to activate the account.
    I keep getting this message:
    ———————————–
    Invalid activation key
    ———————————–

    I even copied the key directly from email link and entered in to the activation field, still keep getting the “invalid activation key” message.

    I then deleted the account from backend and resisted the new account again.

    Again, it is same problem: invalid activation key.

    What is the problem? How can I fix it?

    Please advise.
    Thank you.

Viewing 16 replies - 26 through 41 (of 41 total)
  • Avatar of simple-man
    simple-man
    Participant

    @simple-man

    Please advise about the following:

    Q1: How do I access the database that stores the account “activation key”?
    Q2: How do I verify if search for a particular account “activation key” in the database?

    Can I do the above in the account zip file that I downloaded from the server?

    Thank you very much.

    Avatar of simple-man
    simple-man
    Participant

    @simple-man

    Please advise about the following:

    Q1: How do I access the database that stores the account “activation key”?
    Q2: How do I verify or search for a particular account “activation key” in the database?

    Can I do the above in the account zip file that I downloaded from the server?

    Thank you very much.

    Avatar of simple-man
    simple-man
    Participant

    @simple-man

    Here is now another phenomenon happening:

    1. New user clicks on the account activation email link
    2. The activation page displays error: “Invalid Activation Key”
    3. User can still login using the username and password selected during account registration

    Q: So what is going on here? Does it mean that the account activation email was never needed in the first place?
    Or
    Does it mean that somehow the account is activated even though the the page displays the error “Invalid Activation Key”?

    So how do I fix this issue? Is it possible to disable the activation email?
    Is it possible to chnage the “Invalid Activation Key” message to something like the following:
    —————————————————————————————-
    Now you can login using the username and password you selected during account creation.
    —————————————————————————————-

    Thank you!

    Avatar of simple-man
    simple-man
    Participant

    @simple-man

    Thank you for your response @barney92

    Now I am finding that:

    * Sometimes the user is able to login using id/pw selected during account registration even if the activation message (after clicking the link in the email) is : Invalid Activation Key

    AND

    ** Other-times the message is still “Invalid Activation Key” and the user is NOT able to login using username/pw created during account registration.

    What a mess! It is now 2 weeks and can’t figure out what is going on.

    Really need some help here please.

    Avatar of simple-man
    simple-man
    Participant

    @simple-man

    Any suggestions please?

    Avatar of justsayno1
    justsayno1
    Participant

    @justsayno1

    I am having this exact issue. I am a developer and I know how to run through the steps mentioned here..

    What I have tried is to find a user that is stuck in not being activated and running putting this on one of my pages:

    <?php                                                                                                        $user = get_userdatabylogin('busaany'); echo $user->ID;                                                                                                    echo get_user_meta( $user->id , 'activation_key', true );
    ?>

    This yeilded an activation key:
    2429b4ee92830f6557b5b5be271b5078defe

    So I tried to plug that into the activation key url as such:

    http://bounty.co.nz/activate-account/?key=2429b4ee92830f6557b5b5be271b5078defe

    This brought me to the invalid key page as mentioned by others… This is a major issue and I am getting all sorts of stress/grief from my client. I am 100% committed to fixing this issue myself if that is what has to be done. But I was hoping that my putting this here could give the buddy press devs some more info on what is going on. This use HAS signed up, this use HAS tried to go to this link and it failed first time.

    I have used a plugin called buddypress pending activations to try and remedy this and trouble shoot it. It allows me to figure out who is being caught and it is a non-trivial amount of users. The user remains in the pending regardless of visiting that link or entering the code into the box on the page…

    Any leads? I will be getting this locally set up and try and debug buddypress as I am certain this is buddypress thing now not a server issue. But if you can get me any help or direction that would be great. If I can fix this I will let you guys know and we can get this resolved in the core.

    Regards,
    Justsayno1

    Avatar of justsayno1
    justsayno1
    Participant

    @justsayno1

    Sorry that first code block got ugly:

    
    <?php 
                                                                                                            $user = get_userdatabylogin('busaany'); echo $user->ID;
                                                                                                            echo get_user_meta( $user->id , 'activation_key', true );?>
    
    Avatar of justsayno1
    justsayno1
    Participant

    @justsayno1

    Arg!

    
    <?php 
     $user = get_userdatabylogin('busaany'); echo $user->ID;
     echo get_user_meta( $user->id , 'activation_key', true );?>
    
    Avatar of simple-man
    simple-man
    Participant

    @simple-man

    @justsayno1

    Any progress in finding solution to this issue?

    Thanks.

    Avatar of justsayno1
    justsayno1
    Participant

    @justsayno1

    No not yet sorry… I’m still having trouble re-creating the issue. I thought I was seeing it but then I realised that I was accidentally including some extra characters on the end of an activation key. I have set up a local version of the site and I have been trying to work my way into the crux of the functions doing the work and can’t seem to find anything wrong… I’m more and more thinking that the users who have reported this are doing something wrong or it is something to do with click through from the link.

    I will keep you posted as I need to fix this issue myself, if I can’t find it. That is the issue at the moment I can’t seem to reproduce it myself. Every time I sign up it works. but I have users that seem to be stuck in “pending activation” some of which might be due to lack of actually trying to activate.

    Avatar of OrlandoDS
    OrlandoDS
    Participant

    @orlandods

    Hey,

    I’m had the same problem and resolved the issue;

    Cause of the problem

    Wordpress database error Unknown column ‘signup_id’
    column: signup_id missing from database table wp_signups

    Solution

    create primary key column titled ‘signup_id’ by entering the following sql statement at the mysql prompt:

    ALTER TABLE 'database_name'.'wp_signups' ADD COLUMN 'signup_id' INT NOT NULL AUTO_INCREMENT;

    Problem History

    Error: Invalid Activation key
    Also, manage signups view is empty, but I have attempted to register multiple users

    system

    • LAMPP
    • WordPress Version 3.6.1

    Unsuccessful Resolutions:

    • activate 2012 theme
    • deactivated all plugins
    • deleted + reinstalled buddypress

    Known Database Issues:

    • the field user_activation_key is empty in table wp_users
    • the field activation_key is NOT empty in table wp_signups
    • column signup_id is missing from table wp_signups
    • there is no PK or FK column for table wp_signups

    apache error log

    Found some useful output from apache log file, which is what led my solution:

    [Wed Apr 23 20:58:19 2014] [error] [client xx.xx.xxx.xxx] WordPress database error Unknown column 'signup_id' in 'order clause' for query SELECT * FROM wp_signups WHERE active = 0 AND activation_key = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx' ORDER BY signup_id DESC LIMIT 0, 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, bp_template_redirect, do_action('bp_template_redirect'), call_user_func_array, bp_screens, do_action('bp_screens'), call_user_func_array, bp_core_screen_activation, bp_core_activate_signup, BP_Signup::get

    To the BP devs, I hope that’s enough to solve the problem at the application code level, instead of the database hack I used. I have a feeling the error might be due to using an old WP version, as the error appears to stem from the core WP files and not the BuddyPress files…

    Avatar of OrlandoDS
    OrlandoDS
    Participant

    @orlandods

    posting another comment with email notifications enabled…

    Avatar of stwc
    stwc
    Participant

    @stwc

    @simple-man this issue has been fixed by the 2.1alpha patch here: https://buddypress.trac.wordpress.org/ticket/5563#comment:24

    Thank goodness. It was an issue with a missing field in my wp_signups table, which was there either because I downgraded from a Multisite install or because I have Gravity Forms installed. All seems well now.

    Avatar of stwc
    stwc
    Participant

    @stwc

    @OrlandoDS see above… maybe this is the fix for you too.

    Avatar of simple-man
    simple-man
    Participant

    @simple-man

    @stwc

    Thank you for the update.

    I will soon install and test.

    Avatar of bummedbride
    bummedbride
    Participant

    @bummedbride

    Hello everyone! I still can not find a resolution to this “invalid activation key” – has anyone had any success? My Buddypress website works fine for most but there are still several of my members that are experiencing this issue?

    Has anyone found any fixes?

    Thanks!

Viewing 16 replies - 26 through 41 (of 41 total)

You must be logged in to reply to this topic.