WordPress database error: [Unknown column 'a.is_spam' in 'where clause']

[rbahumi]

Hi,

After upgrading from buddypress version 1.5.6 to 1.6.1,
I am getting the following error on the activity page:

WordPress database error: [Unknown column 'a.is_spam' in 'where clause']

Checking this "where clause", I see that it refers to the is_spam row in the bp_activity table (the relevant file is /bp-activity/bp-activity-classes.php).

Is there an update available to the bp_activity DB table?

[boonebgorges]

Make sure you're run the BP update wizard. You should see a notice asking you to do so at the top of the Dashboard when logged in as super admin. (Check the Network Admin, if you're running Multisite.)

[rbahumi]

Thank you for your quick replay.

I am not running multisite, and getting this error message as super admin on the Dashboard (​https://surf-space.com/wp-admin/options-general.php?page=bp-components):

You do not have sufficient permissions to access this page.

Other pages on the admin dashboard work normally. I can access site settings and also other plugins settings.

[rbahumi]

This 'You do not have sufficient permissions to access this page' error is generated by this file:

wp-admin/includes/menu.php, after user_can_access_admin_page()( a function defined in wp-admin/includes/plugin.php) return false:

if ( !user_can_access_admin_page() ) {
        do_action('admin_page_access_denied');
        wp_die( __('You do not have sufficient permissions to access this page.') );
}
$menu = add_menu_classes($menu);

Even after removing this if condition, I get the following new error message as super admin on the admin Dashboard (​https://surf-space.com/wp-admin/options-general.php?page=bp-components):

Cannot load bp-components.

Please advice.

[boonebgorges]

You're sure you're logged in as a super admin?

It's possible that your BP package was corrupted, so that there are missing files. Try downloading again, replacing your existing wp-content/plugins/buddypress directory with the new one.

[DJPaul]

Please can you also confirm you've run the Upgrade Wizard

[rbahumi]

Ok, this is my bad here...
I haven't seen the update popup, and tried updating from another location in the Admin Dashboard. I appreciate your replays guys, and cancelling the ticket.

Thanks, and sorry,
Roei.

[boonebgorges]

Thanks, and sorry,

No need to apologize - glad to hear it's working, and that it's not a larger bug!