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…
