BuddyPress.org

My hosting is retarded, I told them I would put a wordpress on each of 5 cpanel account they grant me to keep things neat an orderly…

Hosting: NoOOO!!! Attribute your domains/subdomains on just 1!!!!
Everyone knows better than me!

Yea they didn’t remove the groups. Tried yesterday. since I have 5-6 domains on this account where do I find the groups?

View post on imgur.com

My site has a good 15,000+ users, of which about 100+ online in BP area at any given moment (so no caching etc)

Constantly tweaking things for performance. Finally checked out the MySQL slow query log and it’s a lot of stuff. But a solid 80% of it area queries like this

# Query_time: 3.036380  Lock_time: 0.000062  Rows_sent: 0  Rows_examined: 772130
SET timestamp=1607682328;
SELECT DISTINCT a.id  FROM wp_bp_activity a  WHERE
(
        (
                a.content LIKE '%@bobtho<%'
                AND
                a.hide_sitewide = 0
        )
)
AND a.is_spam = 0 AND a.type NOT IN ('last_activity') ORDER BY a.date_recorded DESC, a.id DESC LIMIT 0, 21;

Query time is 3.2 seconds, some are upwards of 5+

I think it’s coming from here https://github.com/buddypress/BuddyPress/blob/d2223de16c4b525906aaa89597a6ccc30515f58d/src/bp-activity/classes/class-bp-activity-activity.php#L380 and particularly when a user presses their “My Mentions” tab, thus its loading all of their activities that include their “@ username” text

My CPU load is *always* high, I’ve upgraded my server earlier in the year:3.4 GHz 4 vCores and 16 GB RAM so it’s not bad

Basically, I’m wondering if anything can be done about this? Since my slow-query log is filled with these types of queries (specifically it seems to be this “@ username” search) – can any optimizations be done, either in BP or something I can hack onto it?

So this has been an on and off issue I have struggled with using buddypress. Several users haven’t received an activation link. Whether it’s the fact that the link itself looks super spammy or some email servers have security issues with wordpress sending sketchy linksI have no idea. All I can say is with captcha plugins there really is no reason to force an activation link. A toggle feature should be added to buddypress to switch between auto account activation and email activation. I just had 5 people today say that the activation email was nowhere to be found. It makes it all the more frustrating when you are running paid ad’s to get sign ups on your site while this issue is happening. I’m on wp version5.5.3 and buddypress version 6.3.0 installed on the Arcane gaming theme by skywarriors.

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