Skip to:

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

  • OrlandoDS


    posting another comment with email notifications enabled…




    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


    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


    • 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] 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…

Viewing 2 replies - 1 through 2 (of 2 total)
Skip to toolbar