BuddyPress.org

The following query is failing after database migration on the activity page:

SELECT DISTINCT a.id
FROM wp_bp_activity a
WHERE a.type IN ( ‘activity_status’,’activity_quote’,’activity_photo’,’activity_video’,’activity_audio’,’activity_giphy’,’activity_update’,’new_member’,’friends_register_activity_action’,’created_group’,’joined_group’,’activity_update’ )
AND a.is_spam = 0
AND a.hide_sitewide = 0
AND a.type NOT IN (‘activity_comment’, ‘last_activity’)
AND a.privacy = “public”
AND a.user_id NOT IN(87,409)
ORDER BY a.date_recorded DESC, a.id DESC
LIMIT 0, 21

1054 – Unknown column ‘public’ in ‘where clause’

Any idea on how to fix this?

I have over 4000 active users on Buddypress – and it’s a Spam Magnet.

I’ve tried a few things I’ve found in past threads, but doesn’t seem to be working. Registrations are e-mail verified, and coming from gmail for the most part. The Spam users don’t seem to have the same IP range to ban, etc.

First people were just creating profiles. Then they started using the messages system. Disabled that. Then they started sending Friend requests to other users. Then they started replying to other users basic activity.

I’ve tried throttling, they just make more accounts. I’ve tried ReCaptcha on every messaging form. A week later someone still manages to reply to activity to a few hundred users in a day.

I’ve essentially disabled every single interaction possibility at this point, which severely hobbles the usefulness of buddypress in the first place.

Any ideas for something that actually works to stop spam?

My users aren’t getting the sign up email – It’ not even going to their spam folder. Is there something I need to do to enable it?

Also when they sign up, it says that the username is taken, even when it isn’t, but it creates the record of the sign up with the username

joshinshaker.com

Hello, On WP I want to change the status of a member who has become spam. Indeed, there was not registered his address … How to return to normal status.
When I pass the change on the extended profile from spammer to more active it is refused.
Thank you for your help.
cordially

Hi! We have had a lot of spam messages and have deleted them from the database with phpMyAdmin, but the new message icons do not disappear. How can we solve the problem?

Hi,

I’m having a few dozen database error entries in the apache log every day. First i thought the WP Cerber plugin could be the trouble maker. Since this entries are all connected with failed login attempts with wrong user names. Most probably Spambots. But the WP Cerber developer told me that this is a Buddypress issue. See this issue: https://wordpress.org/support/topic/wordpress-database-error-you-have-an-error-in-your-sql-syntax-5/#post-12366843

So i kindly ask for support here.

Such a log looks usually like this. A few attempts from always the same non existing user name before it gets locked by WP Cerber:

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE active = 0 AND user_login = ‘AveryZem’ ORDER BY signup_id DESC LIMIT 0, 1′ at line 1 for query SELECT * FROM WHERE active = 0 AND user_login = ‘AveryZem’ ORDER BY signup_id DESC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, cerber_wp_login_page, require(‘wp-login.php’), wp_signon, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, bp_core_signup_disable_inactive, BP_Signup::get, referer: https://bforartists.de/bfa-login/

The page is unfortunately already productive. So i cannot turn off addons wildly anymore.

Could you please help me to get rid of this errors please? ????

Kind regards

Arunderan