[newz12]

I have hired someone to look at the database and this is his comments:

==========================================

so, basically your query is processing too many records in a couple of tables wp_posts(1’980’935 records) and wp_postmeta(10’818’678). It matches and returns 57’639 records.

The core query is:
select SQL_NO_CACHE wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (wp_posts.ID = 515125 OR wp_posts.post_parent = 515125);

which returns 399’291 record for 2.1s
which is a huge join

Then the extra “where” conditions add extra time. The query bellow:

select SQL_NO_CACHE wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (wp_posts.ID = 515125 OR wp_posts.post_parent = 515125) AND wp_postmeta.meta_key = ‘_bbp_forum_id’;

reduces the returned records to: 57’639 and in fact the rest of the where statements do not change the final result but are only adding more time for processing.
The query takes about 3s.

Both queries above are well indexed and are execucuted in the optimal way.
With this amount of returned records matched against the 2 big tables (~11mln and ~2mln records in each) executon time of less than 3s can not be achieved.

is this forum using a custom php code developed in house?

ME: It is using bbPress, which runs on WordPress

the thing is, this code is not optimal in term of database design
because it’s using a couple of wordpress general storage tables
to store the forum posts and threads
as you can guess this 2 tables have a lot more data in it along the forum data
from other hand the query you sent has too many “where” conditions
which are not relevant at all

AND CAST(wp_postmeta.meta_value AS SIGNED) NOT IN (‘515120′,’515123’) ) )
AND wp_posts.post_type IN (‘topic’, ‘reply’)
AND (
(wp_posts.post_status = ‘publish’ OR (wp_posts.post_status = ‘pending’ AND wp_posts.post_author = 0) OR wp_posts.post_status = ‘closed’ OR wp_posts.post_status = ‘hidden’)
OR
(wp_posts.post_author = 0 AND (wp_posts.post_status = ‘private’))
)

non of this are changing the final result at all, but are slowing the core query with extra time

in short – there is not an easy “magic” fix in the database side
as I said the core query is well indexed and runs optimal by the SQL engine
the only thing can be done is to change the query a bit
but we can hardly get it under 2.5s
and this will require PHP code changes

ME: What would be your suggestion to achieve a similar performance with database?

get rid of the WP
the WP pluggin you use is a forum implementation on top of WP
understand that, but you are expecting something by this WP pluggin that it can’t provide

with storring everyhing in a couple of tables – that can’t be done

won’t even comment:
AND CAST(wp_postmeta.meta_value AS SIGNED) NOT IN (‘515120′,’515123’) ) )

this part
wp_postmeta | CREATE TABLE wp_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
meta_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
meta_value longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (meta_id
)

as you can see meta_value field is a longtext!!!
you can imagine how can you filter by this field
without index
scanning millions of records by a field that holds huge strings
in same table wp stores all sessions, etc..

just to imagine how much extra data is stored in wp_postmeta table
here is a some stats by meta_key and the number of records (top 20 or so):

| external_image_id | 100828 |
| external_place_lat | 100845 |
| external_place_lng | 100862 |
| external_upload_batch | 110848 |
| amazonS3_cache | 121546 |
| _bbp_activity_id | 199233 |
| filter | 239951 |
| id_field | 239952 |
| __defaults_set | 239974 |
| _bbp_post_id | 1418227 |
| _bbp_topic_id | 1426899 |
| _bbp_author_ip | 1426899 |
| _bbp_forum_id | 1426909 |
| _barcelona_vote_up | 1732202 |
| _barcelona_views | 1732206 |

in fact this WP pluggin is using mysql as a simple storage and not as a relational DB
as I said above it’s a bad DB design problem
because it’s a just a pluggin/extension of a CMS system

==========================================================

Basically he is telling me that we won’t be able to achieve good loading time, because it is running on WordPress and the database design is a problem.

What do you think, is there hope?

We run a forum with 1.4 million posts and almost 100k members, if it can give you an idea.

[ico33]

Hi, in my site I noticed a strange issue after last WordPress update. It seems to have problem with “cache”.

For example, if I log-in through the Home Page, after click in sign-in, the page refresh but it seems that the log-in didn’t work. If I press F5 to refresh the page, here I can now see the log-in effectuated.

I thought about my caching plugin, and I wrote to the assistance of my provider. They exclude the problem is in caching plugin, they found this:

The issue appears to be caused from the latest WordPress upgrade that was automatically applied within your website.

Code:

sitename@esm9 [~/public_html]# wp core version
4.7.4

There seems to be conflict between a plugin of yours that is creating this strange behavior within the website.

To find which is the responsible plugin, you may start deactivating them one by one and after that checking the functions that were not working as expected. Once they work this will indicate which plugin caused the issue.

I did what they suggest, and when I deactivate BBPRESS, everything works! So, what to do??

[forums1234]

bbPress – Version 2.5.12
Wordpress – Version 4.7.4

My friends have been joining my forums. They get an email stating they’ve joined from MailChimp. They return to the site and their user name and password are requested.

I get a message stating they’ve joined.

Here’s the problem. They never get an email to activate their Username and Password.
A. Does bbPress have that feature?
B. Does MailChimp not forward that sort of email?
C. Is there a way to add Username and Password during signup in bbPress?

Thank you in advance.

[jayhova4x4]

What is the best practice to achieve a unified profile page for people who have both BBpress and Buddypress installed as described in this post?

[cjerrells]

Hi,

I’ve been having difficulties setting up a private BuddyPress group with associated forum:

1. If the forum is set as “private” then I get the error “This group does not currently have a forum.” on the group’s Forum page.

2. If the forum is set as “public” then the forum does appear there, and the group’s access controls seem to stop non-members accessing it. However new topics and replies generate BuddyPress activities which are visible to non-members.

WordPress 4.7.4
BuddyPress 2.8.2
bbPress 2.5.12

I was advised on trac ticket #2752 (here) to try the fix on trac ticket #2599 which updates forum privacy when the group is saved. I tried this, but it just set the forum as private, triggering problem #1.

As mentioned on the trac ticket linked above, I have tried the Repair tools and various changes to group/forum privacy.

I can’t seem to find a setup that gives me a private group with a private forum. Can anyone please advise me on how to debug this?

[sagetopia]

I’m seeing issues that seem to only affect public forums (private or hidden work as expected). Public forums don’t appear in the admin ‘All’ list view, although they do appear under ‘Published’. Attempting to view the single page for a public forum gives a 404 when logged in. When not logged in, it gives the following fatal error: Fatal error: Uncaught Error: [] operator not supported for strings in .../plugins/bbpress/includes/forums/functions.php on line 1855 Looking at that line, the get method of WP_Query returns an empty string if no matching key is found. That explains the [] operator error and adding a default empty array to the call does fix the issue for non logged in users. However, the root cause must be higher up the call chain because it doesn’t fix the permalink problem.

[sajay]

I have a conflict with the visual editor in bbpress and the Ecwid plugin.

With Ecwid enabled:
When I enter text into the visual editor and try to submit I get “ERROR: Your reply cannot be empty. “. Also the inert image icon does not work.

With Ecwid disabled
Everything works as expected.

[finishlikepre]

Hey Robin,

I know this is a long shot, but do you by chance take any freelance work?

I’m still having trouble with this because I’m using a plugin (Ultimate Member) that redirects every link from the bbPress User Profile over to the Ultimate Member User Profile. I contacted their support and they said there is no workaround for this. They said the only way to access the bbPress User Profile (to edit, view, etc) is to disable the Plugin. They also said that in order to work around this, it’s going to take customization of the bbPress plugin itself. So I need to find a dev that can do that for me.

So do you take freelance jobs?

Thanks!

[finishlikepre]

Ahh that was my problem! I was in the wp-admin dashboard. Which you’re right…is terrible. I see the fields created by your plugin now in the bbPress dashboard. Thanks so much for your help, Robin!

[benmess65]

Hi,
I amusing WordPress 4.6.5 with bbPress 2.5.10. Just recently I am starting to get 50 or 60 users a day registering when I had only a handful for many months previously. None of these ‘new’ users are activating their account. I know that activation emails are going out because I registered myself with a gmail account, received the activation email and applied a password. My admin email account (not the gmail one) received a message telling me that the user had changed the password, thus telling me that that user had activated. None of the over 200 spam email accounts have followed that process, so I want to remove them from my list.
I was under the impression that bbPress automatically removed registered users that did not activate, but I still have over 200 sitting there and I cannot see which ones should be active and which ones are not, because they all just have “Subscriber” role against them.\
How can I tell which users have activated so I don’t remove valid users and only remove the spam ones.

[Stephen Edgar]

@suparixi No need, each version you have installed will show an update is available when bbPress 2.6 is released

[Pascal Casier]

Hi,
There are some things that could be done on this page:
https://codex.bbpress.org/layout-and-functionality-examples-you-can-use/#27-custom-redirect-after-login

Hope it helps.
Pascal.

[Pascal Casier]

Hi,
Probably seen as spam ? Check any ‘Pending/draft/spam’ under replies, in Akismet, or any other plugins that could block this.
If you don’t find it, deactivate all plugins except bbPress and try again. Also switch to a default theme to see if that helps.
Pascal.

[Pascal Casier]

Hi,
If I may add my part too:
– If you post something, you will never receive it yourself. As you know what you have posted, you will not receive the message yourself (I hope this has not changed in the latest versions)
– You are NOT using BuddyPress, right ? Only bbPress. Because BuddyPress might have other settings and then you might be better checking with the support overthere.
– As Robin indicates, users need to SUBSCRIBE to a forum to receive the notifications for TOPICS that are posted in the forums.
Hope this helps.

[lovechugh]

Hello experts,

One of my client have a website called : seriesratings.com.

He needed a forum, that’s why he added the bbPress plugin. the site was using Post Ratings plugin already to rate the posts.

when he installed the bbPress. the Post ratings plugin crashed, it is not working. I don’t know what happend. I uninstalled the bbPress plugin and the problem was still there.

Does anyone know, what would have happned, and how can I solve this problem.

Thank you very much in Advance : )

Best Regards,
Lucky

[Robin W]

just before we go down that road, is this in user profile or in bbpress profile? the first you get to from dashboard (and is horrible) – the second you get to by clicking any username

[KenTheriot]

A user posted a new topic in my bbPress forum. that worked just fine. I registered as a Subscriber so I could test user experience, and tried to reply to his topic/thread. But after I hit “Submit,” the topic reloaded and the reply was not there. The status still reads: This topic contains 0 replies, has 1 voice.”

What could be the reason why the response is not being published?

Thanks!

Ken

[finishlikepre]

No only bbPress 🙂

[horsmanzach]

Hello, I am running WordPress 4.7.4 and bbPress 2.5.12.

My forum can be found on https://thehulkpress.com/forum . The page looks exactly how I want it to there, but when I click on the forum channel the page background changes to white. I’ve tried a variety of different css codes to change the rest of the pages to black, but can’t seem to find the correct block of code. Can someone suggest a way to change not only the first page, but the rest of the pages’ background to black? Thank you

– Zach

[pluplik]

Hi.
I moved my localhost site to my domain.
All went great except bbpress.
When I load the forum page it doesn’t work and show an error page not found.
Tried to delete forum page and recreate, tried to uninstall bbpress and install again. No luck.
I think its has something to do with the database but not sure.
Followed the tutorial to install.
Permalinks I refreshed it.nothing so far.
Thx for help.

[softgenic]

I manage to do this by PHP code but I am now facing one small issue the freshness time that’s coming through bbpress recent topic widget is different as compared to the freshness that’s coming through <?php printf( __( 'Last Post: %1$s', 'bbpress' ),bbp_get_topic_freshness_link( array('post_id' => get_post_meta( get_the_ID(), '_bbp_last_active_id', true )) ) ); ?> so can you please let me know how to atleast make sure the freshness time is correct?

[magnaweb]

Hello, I have a bbPress forum on my website. I am running WordPress 4.7.4 and bbPress 2.5.12.

The way I want the entire forum to look can be found on https://thehulkpress.com/forum. However, you’ll notice when you click on the one channel available that the background of the page goes to white instead of staying black. I’ve searched numerous posts and have attempted to change all css fields that make sense to a black background. I have a feeling that the Divi theme that I am running is perhaps overriding this and I may need to change something in the php files, however I am not sure where to look for that. Would anyone be able to point me in the right direction? Thanks for your time,

– Zach

[Stephen Edgar]

There are quite a few performance improvements coming in bbPress 2.6 (to be released soon)

Many of these improvements have been made to support the implementation of bbPress 2.6 here on the WordPress.org support forums.

You can read more about this here https://bbpress.org/forums/topic/bbpress-2-6-beta/

If you have a test site, or could set one help, testing 2.6 would help us help you 🙂

[yo35]

@Robin W: thanks for your answers. The “bbPress – Do Short Codes” plugin do the job.

However, there is still a problem: bbPress seems to have a kind of postprocessing that adds several <p></p> tags within the post content, including the sections that result from shortcode processing. Is it possible to disable this behavior?

[stefaanc]

Hello Pascal,

The way you described it, feels exactly like the feature I was looking for. I installed it, but nothing seems to happen right away (using [bbp-single-forum id=$id]). That’s probably because I use bbpress 2.5.12, and not the beta version. Do I understand it correctly that you would have to make a different plugin for the 2.5.12? Or should the “$translated_text == ‘Oh, bother! No topics were found here.'” be changed? — so far, it looks like that text is exactly what appears, preceded by ‘this forum is empty’.

Looks like this is going to be resolved, very good — impressive support!

Thanks,
Stefaan