[udidol]

Hi,
I have a bbpress forum on my website which was spammed with messages. There are 27,000 spam topics on it. I want to delete the forum entirely, but since there are so many topics, when I try to delete it the request gets timed out.

I would like to delete most of the posts directly from the database with an SQL query. Can anyone provide an SQL query to delete these messages?

As far as I could tell, all of the messages have the same title and same author name, if that helps (I didn’t look through all of the 27,000 posts).

Any help is appreciated, thanks!

[Robin W]

ok, so it’s more a site than a bbpress issue.

so more fault finding needed.

try this

Check Email

[John James Jacoby]

I understand the need for this, but this is coming from bbPress so there is only so much we can do. bbPress has no way to to blanket unsubscribe someone from all of their forums/thread email subscriptions. If bbpress had a way to unsubscribe globally, then we could look into it but going topic by topic, which is how they have it setup does not work. Simply put bbPress doesn’t have the utilities to make it reasonably possible

The bbp_topic_subscription_user_ids filter can be used to remove users from the array of users to be notified about new replies to topics.

The bbp_forum_subscription_user_ids filter can be used to remove users from the array of users to be notified about new topics in a forum.

On the Memberpress side, or in a separate add-on, they can filter those arrays, remove “inactive” members from those emails, and problem solved.

I’d also argue that you actually don’t want to blanket unsubscribe anyone from anything, because if they ever re-subscribe, they’ll want to get all of their previous history back; right? If you purged all those subscriptions when their membership expires, that would kinda stink for them.

[John James Jacoby]

The problem of conditionally loading the PHP files will go away when we can start to officially support autoloading for versions of PHP greater than 5.2.

With BuddyPress, we did move to supporting autoloading when it’s available. bbPress has fewer files, and is a simpler piece of software, so my preference would be to keep it a bit more pristine and not include the same conditional support until it’s a general requirement for running WordPress.

Anything we can do to make bbPress more performant is definitely encouraged, so I appreciate you noticing, and taking the time to start the discussion here.

[Fabian]

1) It is true and I’ll show you some more precise benchmarks on this for a concrete example. Take the filter bbp_map_meta_caps, it’s within a filter recursion, where the filter fires it self again. The recursively fires 4 times with bbpress only. Now if another plugins does the same, it could get up to 16. Plugin run times include each other through the filter api. In worst case you can’t just add them to each other, they bias by some non-linear function that is definitely not O(n).
Your point is true, that you can’t blame a plugin for being slower in conjuntion to others. But, you as a developer, should avoid that other plugins can slowdown your own plugin, by minimal intrusion into the WordPress plugin API. And bbPress does not have this minimal intrusion. Of course it is a big software product, but there is high potential to conditionally hook into WP only on pages it needs to.

2) No its not completely irrelevant. I wasnt clear enouh here, I’m not referring to file count, but yeah -how you said- file size or LLOC. Were not talking about vulcanizing scripts. You’re right, the PHP interpreter got very fast and it should not matter, but consider:

a) Only the inclusion of bbpress main file makes PHP allocate about 600 KB. Thats a lot, considering 0 output bytes. And this happens on every request, every REST.

b) Think about who runs a WordPress site, not people that have a dedicated high performance server. Usually its a webspace in a VM. These systems can power hundreds of sites, so the webserver does not just read 500 files at the same time, but lets say 10000. This lowers the chance to find the same PHP code in some cache between subsequent requests. The code size per request starts to matter here.

b) It is a style thing, I dont want my programs to load 1MB code without using it. And yeah, there are many plugins that just follow WordPress style to include everything, but this does not mean it is a good style to follow. Unfortunately, there is no well known code metric that covers this. WP was created in darker times of PHP, without autoloaders. Why do we have them now? I dont get it why so few plugins properly use them, it takes a day to refactor your plugin and another to test.

bbPress is not doing bad. It could just be more minimal if the forum is just a smaller part of your website. I dont expect 25 plugins to allocate 0 memory, but I expect 25 plugins not to clog my dashboard and frontpage, where I do not want them to load. I want them to do what they are supposed to do on specific pages within the front- and backend.
Its true that woocomerce is the worst.
I could optimize it though. It only loads on the shop frontpage, on the checkout page, on product pages, specific ajax actions and REST endpoints. The cart can be XHR, or one can keep on loading the plugin once a cookie is set. This technique makes the wp-admin dashboard fast too.

(I’ll back with the benchmarks)

[lovechard]

What I got from memberpress:

“I understand the need for this, but this is coming from bbPress so there is only so much we can do. bbPress has no way to to blanket unsubscribe someone from all of their forums/thread email subscriptions. If bbpress had a way to unsubscribe globally, then we could look into it but going topic by topic, which is how they have it setup does not work. Simply put bbPress doesn’t have the utilities to make it reasonably possible”

[lovechard]

What I go from memberpress:

“I understand the need for this, but this is coming from bbPress so there is only so much we can do. bbPress has no way to to blanket unsubscribe someone from all of their forums/thread email subscriptions. If bbpress had a way to unsubscribe globally, then we could look into it but going topic by topic, which is how they have it setup does not work. Simply put bbPress doesn’t have the utilities to make it reasonably possible”

[lovechard]

@robin-w yes, they are not removed entirely because many people come back and I do not want their information removed completely. The emails are coming from bbPress though, not memberpress.

[Kutakizukari]

.bbpress ARTICLE
{
	width: auto;
}

[MakarkinPRO]

I have 10 forums. I want restricted access from Guest/NotPaid users. And if user want access to, he paying via CreditCard (PayPal ATM processing).

I installed:

WooCommerce
YITH WooCommerce Subscription (free)
bbPress Private Gorups

But I can’t connect things together. I thinking it that way:
1) I create a privite gorups where wordpress’s User Roles is PaidSubscripber. BTW:When user just login/signup to my BBpress he have a User Role named just a Subscriber.
2) After he addint subscription item to the card and paid for that, his WordPress Role is SHOULD change from Subscriber to PaidSubscriber, but I cannot find that option into YITH WooCommerce Subscription (free).

Questions:
Am I thinking in the right direction?
May be YITH WooCommerce Subscription (free) doesn’t support of changing user role for a paid period of time (I set 1 month)?

THx

[websmyth]

We’ve been experiencing an email issue on a bbPress forum for a while. The forum is setup to notify all users (around 700) of new topics and replies and uses the bbPress No Spam plugin to handle this.

We’ve performed lots of troubleshooting and, after having spoken to WPEngine, have narrowed it down to the email causing a timeout on submission of a new topic or reply. The site uses Mailgun which was installed by the previous developer in order to try and tackle this issue, but it looks like the timeout is being triggered before the emails are hooked up to Mailgun so it doesn’t look like changing the Mailgun configuration would solve the issue either.

WPEngine have suggested that we might need to throttle the email batches from bbPress as that might prevent the timeout. I’ve been searching for a plugin that might do this but I’ve only found generic WordPress mail plugins and it seems this is more bbPress specific.

Has anyone come across this issue and found a way to resolve it?

[Milan Petrovic]

1. That is simply not true. I developed many plugins for bbPress, and I always do extensive benchmarking of bbPress and various plugins, and if you have 25 plugins or if you have 5 plugins, bbPress has the same impact on WP regardless. If two websites add 0.1 seconds slowdown, you can’t blame one of the plugins for what other is doing.

2. That is completely irrelevant to loading performance. It is possible to merge all files any plugin has into one huge file. A number of files don’t have too much impact on the loading, and it is even recommended to have a lot of smaller files to help with the code organization, improve loading of what is needed when it is needed (for the most part). WordPress loads about 200 files on average for each page request, and even more on the admin side, and I have seen plugins that load 100 or more files. Size of files have more impact on performance, then the number of files. And with modern servers using SSD discs and a lot of memory, files loading is negligible.

The biggest impact of performance of any plugin has to work with the database in any way (getting posts, filtering). And yes, bbPress up to version 2.5 was not best optimized, and it was on the slower side when dealing with large topics or large forums. Version 2.6 (currently in Beta/RC stage), has significant performance improvements related to database operations, loading posts and processing them.

PHP has Opcache, and other performance related tools for a reason: PHP is not compiled, it is interpreted, and that is always a slower method for doing things, and PHP needs help to make things faster. It is a good thing to have and use Opcache or Memcached. For instance, my website without Opcache uses 60MB for PHP process on average, with Opcache that goes down to 12MB. WordPress without Opcache uses about 20MB on its own, bbPress adds about 5MB, WooCommerce adds closer to 10MB, BuddyPress around 6-7MB. Huge and complex plugins always need memory to work, you can’t expect to run 25 plugins and keep memory to a zero. That is why we have systems to optimize PHP, we have cache plugins.

Once the bbPress 2.6 is released, I will do a new benchmark to compare 2.5 to 2.6 and see how much gains are there when using bbPress with a forum having a large number of topics and replies. But, from current testing I am doing with 2.6, it is much faster than last 2.5.

Milan

[Fabian]

Yes its 0.1 seconds comparing a WP wihtout any plugins, and WP+bbpress. Its not negligible, I expect websites to respond within <0.5 seconds for a good user experience.

There are 2 issues (which apply for most other WP plugins):

1. The impact of bbpress gets bigger with more plugins enabled, because activated plugins have hidden dependencies to each other.
Lets say we have another plugin with 0.1 seconds slowdown, and bbpress with the 0.1 s, the total site slowdown is usually greater than 0.2 s. By using the add_filter() API, plugins actually call each others functions.

2.) Each request bbpress includes almost 40 scripts, the PHP parser parses all of them (lets take opcache apart), and then does not generate a single byte of HTML. So its just wasting server disk I/O, and CPU.

[Robin W]

can I just confirm that this happens then with both the bbpress shortcode [bbp-lost-pass] AND with the wp-admin lost password ?

[lovechard]

^^^ Whoops, I mean bbPress version 2.5.14

@robin-w Yes, they are integrated with bbPress but said that they cannot assist, that this is a bbPress issue. Thanks for your help, I appreciate others helping me figure this out! 🙂

[lovechard]

I am using bbPress Version 2.9.1. I just don’t understand how it’s not automatic. I feel like members who cancel should be automatically unsubscribed after cancellation. Leaving the forums unrestricted to non members for them to unsubscribe to after than cancel would defeat the purpose of having a private forum on my private paid membership site.

[tonicoslo]

Hi! I have a Kunena 4 forum. Is there a way to import it to bbPress?

[theacademicperson]

I previously used a plugin for the voting functionality on my bbPress forum, but it was not maintained for more than 2 years. Also it didn’t have the sorting function of it. The voting option was also not prominently visible – causing problem is accessibility. So I discarded it and tried to find another one, but there is no such good plugin currently available. Also this should be a core functionality of bbPress itself.

[theacademicperson]

Hi friends,

I know I’m posting on a topic that was asked many times on this forum before (including my post from the last year).

There need to be a voting option (upvote and/or downvote) in the forum topics. It is a must to have a functionality to automatically arrange the topics based on voting by viewers.

Almost all the popular interactive forums on the web contains this feature…Stackexchange, Reddit to name a few. Others have a voting system without any rearrangement of the posts based on it…Google plus, Facebook etc.

I admit bbPress is a great forum builder on the greatest CMS at this moment (WordPress)…but it (and all forums build on it) lacks this critical feature.

As I already said this feature is being requested for a very long time, but it wasn’t added on the updates of bbPress.

So it is my earnest request to please add this feature.

You can see how many people has been requesting this by just doing a quick search in this forum – https://bbpress.org/forums/search/vote/

[MakarkinPRO]

I have plugin that do it for posts and pages. But is is possible to make the same for Topics on BBPress at least?

THx.

[fum]

I typed wrong the names of the files in the previous post, this is the correct name of the files uploaded on the server:

bbpress-es_ES.mo
bbpress-es_ES.po

Thanks and greetings.

[Robin W]

which version of bbpress and wordpress?

[Robin W]

can I just clarify that your site takes a tenth of a second longer to load with bbpress – yes ?

[Fabian]

Hi,

I have bbpress installed with a url prefix, everything is under /forums/. I noticed when I just access my frontpage, the plugin causes a site slow down of ~100ms. I have 25 plugins in total and I compared bbpress page load time with the page load time with the other 24 plugins activated.

bbpress does not render anything outside /forums/, so 100ms, I’d say even 20ms, CPU time per request is not justified.

I did a profile of my WordPress setup, which revealed that the main file ‘bbpress.php’ include()s 36 others scripts, takes up to 4MB of memory. Most of the time is waste in the ‘init’ hook, ~40ms.

Can you please fix this?
I tried conditional Plugin loading with Plugin Organizer, but it seems to break the rewrite to the /forums/ URL and it just redirects to the frontpage.
So basically, if the request it not within /forums/, bbpress should only set the rewrites, and this should be done within a couple of milliseconds.

Thanks!

[fum]

Hi, I have installed bbpress and uploaded the bbpress-es.mo and bbpress-es_US.po files in

wp-content> language> plugins

but it doesnt works.
I have added this line to wp-config.php

define (‘BBLANG’, ‘es_ES’);

But nothing was happened, all help is welcome ..!
Thank you..!