BuddyPress.org

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…

what Henry posted is correct way. scroll down to Add Classes By Filters

https://codex.wordpress.org/Function_Reference/body_class

@aberry100, @alanbeck,

if you have a basic php and css knowledge then you can give it a go. the easiest way is by creating custom post type call Video with tags and categories capability.

then code upload form and link it to your post type.

wordpress built in oembed is another benefit for your user to be able to embed videos from oembed supported sites.

Naijaping

Hi @friendsandcash

This string is in WordPress: wp-includes/user.php:153

<strong>ERROR</strong>: The password you entered for the username <strong>%1$s</strong> is incorrect. <a href=\"%2$s\" title=\"Password Lost and Found\">Lost your password</a>?

WP 3.9 original pot file

@mr-bronze

You could try putting the following in you child theme functions.php file

function bbg_enqueue_styles() {
remove_theme_support( 'bp-default-responsive' );
}
add_action( 'wp_enqueue_scripts', 'bbg_enqueue_styles', 5 );

For more info ( including important details ) see: https://buddypress.trac.wordpress.org/ticket/3881#comment:2

——————————————————————————————–

EDIT: I’ve just noticed that you have been told this answer before: https://buddypress.org/support/topic/upgraded-and-now-nav-and-sidebar-is-responsive/#post-150007

Please start your own Topic, rather than jump in on others, which can get confusing for those trying to fix a different problem.

In your New Topic please describe more thoroughly the actual problem you personally are having and what you have already tried, including links to the theme, plugin, snippet or tutorial etc., ( if possible, practical or appropriate )?

Check this one too

https://wordpress.org/plugins/bbpress-email-notifications/

Check if registration is enabled in your WordPress settings.

Thanks for the report, @rewindcaz.

A ticket was created and addressed here:
https://buddypress.trac.wordpress.org/ticket/5571

This will be added for v2.0.1 in the upcoming days.

@sarahs91 there have been changes to both BuddyPress and WordPress. Have you done some basic troubleshooting like changing theme to Twenty Fourteen/Thirteen? If it’s still an issue, have you deactivated plugins other than BuddyPress to check which is causing conflict in your registration?

here some ideas / projects :

https://buddypress.org/support/topic/buddydroid-buddypress-for-android/

5 Plugins To Turn WordPress Into A Mobile App

https://codex.wordpress.org/XML-RPC_WordPress_API
REST API Resources

hi,

Check the code of this plugin

https://wordpress.org/plugins/bp-disable-activation-reloaded/

hello @megainfo,

You’re right. I think the problem you described in #5569 is a side effect of #5553.

Thanks for your feedback, can you confirm this patch is solving your issue ?

@mldia
This is a random guess but:
https://wordpress.org/plugins/wp-linkedin-buddystream/

Hi @imath, @boonebgorges,

I think the problem is caused by bp_update_to_2_0().
https://buddypress.trac.wordpress.org/ticket/5569

@eddieb12180 Did you even try adding the styles I provided above? Of course you can make some changes in the registration page’s markup. Copy over the register.php file from https://buddypress.trac.wordpress.org/browser/tags/2.0/bp-templates/bp-legacy/buddypress/members/register.php into yourchildthemefolder/buddypress/members/ folder and make the changes you want to html tags available there.

I am using a non multisite WordPress.

@livsy

I registered a new user by myself a minute ago. And I saw in his profile – he has no role for my site

This shouldn’t happen.

What is your config ? The upgrade problem concerns a non multisite WordPress. Is it your config ?

“Viewing the sql tables” means that you’ll need to export it using PhpMyAdmin for instance and send it to me.

By the way, i’ve tested BP Disable Activation Reloaded and it’s not the cause of the problem. It’s “someone” else.

@livsy if you try to register a new account, this account should have the role you defined in WordPress settings.

I’m very curious about what happened during upgrade. If it were possible i’d really like to view the users, usermeta and signups tables!

Can you see the users with no role in your users list ?
If so, you can batch create roles for these users using the “change role to” select box on top of the users list.

i’m going to test BP Disable Activation Reloaded to see if the problem was linked to this plugin.

Hi! I am using BP Disable Activation Reloaded plugin. I deleted it (and all other plugins, except BP). But problem with user role still exists.
I set author role for new members in wordpress settings. It was a long time ago, before update to 2.0

@livsy

Just tested in WP 3.9/ BuddyPress 2.0, the role set for a new user is the one that is defined in the WordPress setting (wp-admin/options-general) > New User Default Role dropdown field.

hi @livsy

How were you doing before ? Once a user registered, you were changing the role before he activated his account ?

Or are you choosing a role different than Subscriber in the WordPress setting (wp-admin/options-general) > New User Default Role dropdown field ?

About the upgrade difficulties, were you using a plugin that was dealing with registrations, and if yes which one ?

Thanks for your feedback.