Support » Plugin: Network Subsite User Registration » Error Occurred During Activation

  • Resolved vistics

    (@vistics)


    I have configured subdirectory multisite.

    I have visited your demo site to see plugin functioning. I followed your email link with activation key, then got a page with user name and auto-generated password. This is where my current problem happens on my install…

    I have siteA (Main Site), Site B (subsite).
    I have install plugin and activated network wide. I have set siteA and siteB to plugin setting enable and subscriber as role and saved. This all seems to work fine. For either site the same happens –>> When I go to the registration page I get your generated account registration page. I then submit and receive a activation email. This email has a link with a key attached. I follow that link and get the following error.

    An Error Occurred During The Activation
    Could not create user

    That’s it – it all stops right there. What am I missing?

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Justin Fletcher

    (@justinticktock)

    I’ve had a look at where these errors get generated from an its due to the activation_key not being found that matches, so that would come from any of the three:
    1) cache
    2) page $_GET[‘key’]
    3) $_POST[‘key’]

    First thing you could try is clearing your cache out then check the link is formed correctly in the activation link with the Key argument present.

    Plugin Author Justin Fletcher

    (@justinticktock)

    It’s been over a month so I’m assuming that you found and fixed your problem.

    I’ll mark as resolved but if you need to discuss then come back here.

    I am having the same problem and I have cleared my broswer cache and wordpress cache using wp super cache plugin … and the activation link has the key argument.. but still it does’nt work… but mine does’nt even registers on the woocommerce my account, it’s just refreshes only and nothing happens.. can you please help…

    this is the error that shows up on the console in chromium =
    Failed to load resource: the server responded with a status of 400 (Bad Request)

    These are the errors I found when i turned Debug to true

    [01-Oct-2020 14:11:22 UTC] WordPress database error Unknown column ‘spam’ in ‘field list’ for query INSERT INTO wp_users (user_pass, `user_nicena>
    [01-Oct-2020 14:11:22 UTC] WordPress database error Unknown column ‘spam’ in ‘where clause’ for query SELECT COUNT(ID) as c FROM wp_users WHERE spam >
    [01-Oct-2020 14:11:35 UTC] WordPress database error Unknown column ‘spam’ in ‘field list’ for query INSERT INTO wp_users (user_pass, `user_nicena>
    [01-Oct-2020 14:11:35 UTC] WordPress database error Unknown column ‘spam’ in ‘where clause’ for query SELECT COUNT(ID) as c FROM wp_users WHERE spam >
    [01-Oct-2020 14:11:35 UTC] PHP Notice: Trying to get property ‘user_login’ of non-object in /var/www/thengasa.co.za/wp-includes/ms-functions.php on >
    [01-Oct-2020 14:11:35 UTC] PHP Notice: Trying to get property ‘user_login’ of non-object in /var/www/thengasa.co.za/wp-includes/ms-functions.php on >
    [01-Oct-2020 14:11:35 UTC] WordPress database error Unknown column ‘spam’ in ‘where clause’ for query SELECT COUNT(ID) as c FROM wp_users WHERE spam >

    Plugin Author Justin Fletcher

    (@justinticktock)

    Thanks for the note, I’ll have a look at this when I get chance. Before then have you checked that no other plugin is causing the issue ? You can deactivate them and check again…. the “spam” reference (without checking) sounds like you have other code running during the activation.

    Apparently since I changed my single wordpress installation to a multisite, I did not have accurate write permissions to my database and the database could’nt create the spam colum, since a spam colum is required in a multisite installation… so the problem got solved when I created the spam colum and deleted colum in my database.. Now I can register… Thank you sir.

    by the way I got the solution from here

    https://wordpress.org/support/topic/unable-to-add-new-users-3/page/2/

    • This reply was modified 8 months, 2 weeks ago by senathi.
    Plugin Author Justin Fletcher

    (@justinticktock)

    that’s good news and thanks for the link.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error Occurred During Activation’ is closed to new replies.