BuddyPress.org

Cover and avatar imgs are not stored in the database. They are in the uploads directory and are organized by id.

If you are using a caching plugin, try deactivating it.
Try turning off cloudfare.
Compare your dev environment to your production environment.
Turn on WP debugging.
iow. you have to narrow it down doing all the usual things.

@welshlamb10 create file backup before using plugin https://wordpress.org/plugins/media-cleaner/

@danielafer use private community plugin or BP lock , it will help to keep your community private for logged in users.
If you do not want the private community approaches you can also use no-index.

function no_index_for_buddypress() {
    if ( is_buddyPress() ) {
        echo '<meta name="robots" content="noindex, nofollow">';
    } else {
    }
}
add_action( 'wp_head', 'no_index_for_buddypress' );

@flpagan Can you clarify whether you’re referring to the theme’s header or a default group’s or member’s profile header/ cover image?
If you’re referring to the theme’s header, please contact theme author.
If you’re referring to the cover images for groups or members, try this https://wordpress.org/plugins/buddypress-cover-photo/ – haven’t used it myself. Good luck.

@sjdeveloper check-in your error logs it will help to identify which additional plugin is creating the issue.

Debugging in WordPress

Awesome! Thanks a lot, for interested contributors, you can follow progress here: https://buddypress.trac.wordpress.org/ticket/8326

@miryd98 You can check https://wordpress.org/plugins/moderation-tools-for-bbpress/

Could you elaborate? Currently this is an already built in function in Buddypress.

Go to your wordpress dashboard followed by clicking on Users > Profile fields > click on the button called “Add new field group” and you got a new tab you can fill out with profile fields.

@globsticks if the plugin is going to change their hooks then you will also need to update your custom code as well, in general developers do not change hooks very frequently.

Your log is full of database query errors.
They seem to be caused by this plugin: WP_User_Frontend
And those errors affect BP but are not caused by BP, afaik.
You should ask the creators of WP_User_Frontend about your errors.
The sending of emails does not seem to be related to this error – and is most likely also not a BP issue.

[09-Jun-2020 20:37:10 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE id = 51’ at line 1 for query SELECT * FROM WHERE id = 51 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, WP_User_Frontend->plugin_upgrades, current_user_can, wp_get_current_user, _wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, wplr97_->wplg67rg, wplr97_->wplkzu6r, wplt4j15::wplno56a, xprofile_set_field_data, xprofile_get_field, BP_XProfile_Field::get_instance, BP_XProfile_Field->__construct, BP_XProfile_Field->populate

Hi, you can post on the official wordpress jobs board https://jobs.wordpress.net/post-a-job/

You can try https://wordpress.org/plugins/bp-better-messages/
As per plugin desc, they have Mass messaging feature

Maybe this plugin could help you with the notifications https://wordpress.org/plugins/bp-live-notification/