[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.

[Pascal Casier]

I’m sure all threads here get noticed, but for some of them we really have no answer.
Just to be correct, not having upvote is not ‘an issue’ but I see your point for this ‘feature request’. I know it has already been discussed but if I understood well, we need to wait for the next major version of bbPress where (thanks to the change to how topics and replies are stored) it might be possible to think of upvoting.
So just to ensure you this did not go unnoticed.
Pascal.

[theacademicperson]

My WordPress version is 4.7
My website link is http://www.theparadigmshiftgroup.com
I have already searched for my question in bbPress support forum (where I am posting now), there are previous threads on this question but the plugin mentioned at that time is now unsupported now (bbPress like topics, last updated 2 years ago). Another thread on the same topic don’t have reply. So I decided to bring this matter into the attention of bbPress authors again. If bbPress already contains this feature, please let me know as well.

bbPress don’t have a voting up feature built in. So the topics get sorted by just last activity and not popularity. A forum seems incomplete without a voting option for topics and replies.

I tried different plugins for this feature. There are many plugins on voting but they are mostly for WordPress posts, not bbPress topics and replies. Some plugins are able to put a “Vote Up” option above the topic, but it doesn’t help the topics to get sorted based on it. Some plugins only shows “vote up” written and instead of a button. Moreover these plugins only can vote topics and not the replies.

Please also include a feature to show the number of votes besite the topic in feeds. Because people choose which topic to read in the feed page.

I always found this community very helpful. I am sure this issue will get noticed.

[Helmuts]

here should be a solution https://wordpress.org/support/plugin/bbpress-votes/ (if you’re still here or to other bbpress users) .. it should be working, I’m still trying to make it work for my forum http://www.lustjobs.com/forums/ (voting works – trying to understand how to display karma on user profiles).

[timsilva_]

I dealt with some of these issues about a year ago. I was migrating from SMF 2* to bbPress and I had tons of issues with formatting in posts and missing data. I ended up hiring Michael Z Noble (http://wwww.michaelznoble.com/ – The 4 w’s is intentional 😉 ) to write a custom migration script to help me through all of these issues (as well as transfer a bunch of data like signatures, up/down votes, thread view counts, avatars, etc, into various bbPress/BuddyPress plugins/functions). The utf8mb4/utf8mb4_unicode_ci/character set issues were particularly tough for me to get through. I ended up switching to a new host that had a newer version of MySQL in order to successfully complete the migration. In short, if you aren’t a senior dev, hire a dev. 😉

Best of luck my friend! 🙂

[antoinemayer]

Hi everyone 🙂

I want my bbPress threads to be automatically marked as “solved” if the question (first message) gets 50 upvotes (yeah, I know that’s weird) and the upvotes/downvotes to get blocked. Yet, I want the thread to remain “open” even while it is solved, allowing users to keep on writing answers.

Is there some code (something like “if $upvotes>=’50’ { $threadStatus=’Solved’ };”) I could use to achieve that?

[Bingo Bongo]

Heh –

Music on the homepage – voted for by our Outfit Members….democracy in action 😉

[azadc1508]

-2
down vote
favorite

I am working with bbpress. I have installed the bbpress in my website. But now I am facing very weird issue.The forum is sending me to different page instead of the topic I click. I have uninstall and reinstlal the plugin. But that is not working here is the link of that forum

http://www.amanswebsite.com/forum-index/

Try to click on the any forum you will get what the issue I am facing

Thanks

[b1n]

I’m using a “from zero” made template, and the editor either the Text or the Visual ones appear..

There’s any function my template must have? I have no functions in functions.php but through that bbpress uses in header what it needs

Here’s my site:
http://www.d2evo.com/f/t/testando-up-down-vote/

No need to register.

Thanks

[Pascal Casier]

@BryanWalters,

What exactly are you looking for ? Some plugins for ranking:
https://wordpress.org/plugins/bbpress-votes/
https://bbpress.org/forums/topic/voting-on-user-submitted-posts/
https://wordpress.org/plugins/universal-star-rating/
https://wordpress.org/plugins/rating-widget/
https://wordpress.org/plugins/kk-star-ratings/
https://wordpress.org/plugins/ec-stars-rating/
https://wordpress.org/plugins/wp-postratings/
…

I don’t use any of them, but for sure if you don’t want to code, there are enough options.

Pascal.

[MattConway]

Thanks for looking into this Pascal. Unfortunately being logged in does not make any difference.

On the poll with the longer wording, I can select a button, and it goes grey when I press vote, but the number is not registered, and if I refresh, the vote is lost.

On the other poll identical in every way, with the same log in, just shorter wording for the options, behaviour is as I would expect it; and the vote is remembered.

[Pascal Casier]

Make sure you are logged-in ! I was able to click a button, but my vote is not valid and the results are shown.
Pascal.

[MattConway]

Hi @peterwsterling – Thanks for getting back to me so quickly. Is it OK to ask a question here?

Is there a character limit to answers?

Please take at look at the test poll I set up here: http://www.walthamforestforum.org/forums/topic/poll-test-4-identical-to-problem/

I can select an option but clicking “vote” has no impact.

The otherwise identical test poll here: http://www.walthamforestforum.org/forums/topic/poll-test-5-please-ignore/ that has cut down answers operates OK.

[shades404]

Hi Casiepa,

Is this the “ultimate fix”?

I changed the line but it does not have any effect. I also tried the “fix” by timsilva_ but that doesn’t work either. I revert back to 4.3.1, disabled all plugins but bbPress and the problem remains. Before the upgrade there were no problems.

I’m using quite a lot of bbPress enhancement addons but i don’t think they interfere

• bbP private groups 3.0.8<
• bbPress Do Short Codes 1.0.3
• ppPress Votes 1.1.0
• GD bbPress Attachments 2.3.1

Since Im a keymaster I didnt notice is but got complains from user there topics were gone. Also – they can actually create new topics and they are saved but they just cant see them. They got the imfamous “Oh bother!” message but the freshness information bar says they actually were the last that posted something.

Now – if I make that user moderator everything seems to be working as it should – but hey – i dont want to apply that workaround.

Our problem has something to do with the upgrade and I guess something to do with rights. The only rights-plugin being used is bbp private groups but people confirmed that that plugin is compatible..

Also change the permalink to default – no effect aswell

Please advice..

[Robkk]

@bob1361

You can just use BuddyPress since you have that installed.

Also try to leave the plugins that you want to keep activated. There are a couple plugins that you have that have similar functionality.

Groups
bbP Private Groups
BuddyPress

Voting system
WP ULike
bbPress Votes

bbcodes/shortcodes
bbPress2 BBCode
GD bbPress tools

Unread Posts
bbPress Go To First Unread Post
bbPress New Topics
bbPress Unread Posts v2

Quotes
bbP Quotes
GD bbPress Tools

[Bob1361]

Hi Casiepa and thx for your answer 🙂

I already tried this operation several times without results …

This is my activate extension :
Akismet, bbP private groups, bbp style pack, bbPress, bbPress Enable TinyMCE Visual Tab, bbPress Go To First Unread Post, bbPress New Topics, bbPress New UI, bbPress Quotes, bbPress Unread Posts v2, bbPress Votes, bbPress WP Tweaks, bbPress2 BBCode, bbPress2 shortcode whitelist, BBSpoiler, BuddyPress, BuddyPress Captcha, Emojin, GD bbPress Tools, Krown Portfolio, Mandrill For WordPress – Email form under Post, oAuth Twitter Feed for Developers, Revolution Slider, TinyMCE Advanced, User Role Editor, Widgets on Pages, WordPress Social Login, WP Emoji One, WP Maintenance Mode, WP ULike, WPBakery Visual Composer

Perhaps one is inconsistent ?

I modify CSS too, but i think it’s not a problem ?

[Zapekanski]

Hey there guys. I am completely new to WP but, as far as I have figured out, this is a pretty perspective platform for my particular purposes. I am planning to open online interactive tutorial basing upon my Bitcoin-devoted site, its main mission is (the site is in Russian right now, but in a few days I’ll be adding an English version). We’re now developing a mobile app as well, but it will be deployed a bit later. The site is now in its earlier backed-up version, and I am explaining why.

A friend of mine did all the job and, basing on WP (i don’t know which version it was), he made a move from our CMS to WP. Yesterday I have made an extreme mistake and now the whole site is gone. As far as I had an old version of it backed up (on the old CMS), i have restored the one, but I need the WP version (lots of Bitcoin earning features were attached to it) Now I have no connection with that drupal-bitcoin-enthusiast guy, bit I need badly to restore the new version of the site. But what should I start with to implement this? I understand this is a dumb question, but I am reading manuals right now and I can’t find an answer for that. Please explain me what should my steps be. Thanks in advance.

[pazzaglia]

I know. I use the “bbP private groups” plug-in. Takes a bit to set-up, check that you don’t accidentally set ALL the forums to private with a user account in a different browser – that’s what happened to me with “out of the box” installation.

Vote me in for native implementation.

Ciao,

L

[Robkk]

Sorry for the late reply, there are a couple of ways to do this.

Easiest way to do this, might be to install this plugin. And use the supplied shortcodes in the plugin.

https://wordpress.org/plugins/voter-plugin/

The supplied shortcode are one for custom post types, which you can use for bbPress’s custom post types, (topic)

[voter_plugin_top_voted type=topic num=15]

[Robkk]

@stagger-lee

I have seen this list but it is not the same as Feature plugins are for WordPress core.

Im trying to spruce up the page on the bbPress codex.

Not of things on list has anything to do with me personally, just using other popular forum scripts as reference.

Anything that BuddyPress already has as a feature and putting it into bbPress is a BIG decision to make, this could shy away from the plugin integration with BuddyPress in bbPress, but it would make bbPress stand on its own compared to other forum solutions though. Most of the features people want could be added by just installing BuddyPress with bbPress. I am starting to think if users want something like Vbull or IP Board they install should install BuddyPress to add any social network features. If users want a simple forum just use bbPress.

Here is what I think of your plugin list, it is just my opinion, my opinion could change depending on how you reply to how I feel about this. Maybe tell us a reason of why to incorporate these features into core vs a plugin. I just want to know what you think, and please do not just tell use that this forum is doing this and that bbPress should have do it also, make it an interesting discussion.

• Live preview – maybe bring TinyMCE back, as long as it doesn’t have issues
• Report content – Josh Eaton’s plugin I think personally is pretty darn good and well developed to stay being a great plugin for awhile. Might have to see how his plugin favors in the 2015 survey for any core considerations though.
• Ignore User – I don’t know really know, this might need some additional functionality somewhere else, maybe plugin territory.
• bbPress moderation panel separate from backend –  I could see improvements on front-end moderation, maybe not exactly similar to the way the backend is set up, but I have ideas.
• Notifications – BuddyPress can add this..
• Make topics/forums read, unread (dont know if it is already in the core) – Not in core, toss up if in core or not, lots of plugins to choose from.already, do not know which one is the most optimal for most sites.
• bbPress TinyMce plugin – Maybe bring TinyMCE back, as long as it doesn’t have issues
• Reply titles – I don’t see a benefit from this, there is already a plugin for this though.
• View counts – I had this implemented on one of my forums using WP PostViews, after awhile I got to thinking that the voice and reply count really do show how popular a certain topic is, especially the voice count. Because the higher the voice count amount the more participation from users and not just back and forth between two people. Plus this will bulk up your database with a bunch of data.
• Topics for posts (very important even if not used on all installations) – Something like this is set for core. The creating a new topic for each blog post and linking to the topic where the comment form is gold. Entirely replacing the comments is where I had thoughts about this and I started to question possible issues that might come forth from this, and also the set up needed to make this work flawlessly.
• Online / Offline status – Don’t know really, I don’t really care either way, it is neat though.
• bbPress Polls (not shortcode based) – Maybe someone should just fork _ck_’s version of polls and make it work for bbPress v2, but this in my opinion this should stay plugin territory.
• Attachments – bbPress definitely needs more support for the import of attachments from other forum solutions, but managing them might shift to BuddyPress because they have the attachment API now, and BuddyPress might handle it better. I could see a simple image upload button in toolbar though.
• Move topics / replies between subforums – Yeah probably needs to be core. Maybe just topics with its own replies, not single replies??
• Avatar management – Same thing with attachments, needs more support for the import of avatars, managing them might be considered a toss up too, maybe BuddyPress/plugin territory, maybe core.
• Like / Vote topics, replies (I personally would never use this one, but..) – Probably plugin territory, I have seen some great plugins for this that are compatible with bbPress though. This also gives the user to have more choices on what to use, a 5 star rating, thumb voting, up down rating, like only topics. There are lots of choices.
• New plugin that makes it easy to add custom fields and add them where you need (this one is not referenced by other forum scripts).- I think you could use Advanced Custom Fields, but I am not entirely sure where you are going with this one??

Take some of those plugis from your list and give them to bbPress core developers. Or ask original developers to sign some of you on list of plugin Authors. For those developers who dont have much free time you have some plugins literally made from one-two PHP files. Just as it is a GPL take ownership from todays developers, or cooperate with them as co-maintainer Author.

Well this is tough sometimes too, contributing is one thing but taking ownership is another. Some devs might not see eye to eye, some have probably have gotten most of their income based on a very popular bbPress plugin.

There are plugins that I have suggested merging into core because they seem to improve areas that bbPress already has, the plugin seemed simple enough to consider thinking about since it is very commonly requested, and also that it would make life easier in some cases. I have also contacted a few developers if they wanted to contribute some have said they would like to see what they made into core, and others have not replied back.

Also some plugins could be very small, that might not mean put it in the plugin anyway.

There is not a lot of core devs in bbPress as one might think to start taking over some plugins while bbPress would have a bug that needs to be fixed, testing, code improvements, and other features added to core that may not exactly be a plugin on WordPress.

If you mean just any other active plugin developer to ask them to take over stuff, well I can’t really tell what they are good at besides making their own plugin. And I don’t want to seem bossy by asking people to do stuff that they might not agree to or have time to.

All those names of developers are very active in core community. Developers of bbPress plugins are not.
Either they abandon plugin and lose lust, dissapear.

WordPress core is very active compared to bbPress, but they are two different things. One is a plugin the other is the entire CMS. Other forum solutions are CMS’s to themselves but bbPress is just a plugin.

If there are some plugins that are abandoned and do not have an alternative/fork that you think the plugin should be resurrected and be contributed to, you can say which plugins here.

I think I got most of your points, if I missed one point it out. Try not to be rude at all or come off as rude, just have a decent discussion.

[Stagger Lee]

Here is a list in my opinion should have under Author names at least one nam of bbPress core developers. Not of things on list has anything to do with me personally, just using other popular forum scripts as reference.

– Live preview (live or button for another window/popup)
– Report content (reply)
– Ignore User
– bbPress moderation panel separate from backend
– Notifications
– Make topics/forums read, unread (dont know if it is already in the core)
– bbPress TinyMce plugin
– Reply titles
– View counts
– Topics for posts (very important even if not used on all installations)
– Online / Offline status
– bbPress Polls (not shortcode based)
– Attachments
– Move topics / replies between subforums
– Avatar management
– Like / Vote topics, replies (I personally would never use this one, but..)
– New plugin that makes it easy to add custom fields and add them where you need (this one is not referenced by other forum scripts).

And some more, other people can have other lists. Most important is that at least one bbPress core developer stand on Author list and guarantee plugin will work with latest bbPress version. Not in same minut maybe, nobody is a Superman, but few days after new bbPress version got out.

[Prabin]

Hi there,

I am using both bbPress and buddyPress plugins in my site and I want this feature:

any logged in user can vote to the topics/replies and using shortcode or any trick, I want them
to show-up in certain page. I looked up most of the plugins in wordpress but couldn’t find my match.

Any help ?

[mendesac]

Let’s vote! 😀

[Robkk]

i think any rating plugin should work with bbPress but you would have to manually configure most of them in the bbPress templates in your child theme.

you can follow the very bottom of this topic and use the thumbs rating plugin.

you could probably use CSS to make the blocks actually look like thumbs or something.

Request: Voting

there is also this from a really popular developer , usually some of his plugins are good for bbPress.

https://wordpress.org/plugins/wp-postratings/

random list of post rating plugins

wordpress.org/plugins/voter-plugin/
wordpress.org/plugins/voting/
wordpress.org/plugins/kento-vote/

Are there any other options? Could the programmers possibly consider making it a standard part of bbPress? It does seem like such a standard function nowadays.

This really looks like it should be plugin territory, there are already so many options to choose from WordPress plugins and some quite different , its kind of good for people to have options on this.

[planetearthlings]

Hi All…

Is it possible to create additional fields for forum posts in bbPress. For example we want to be able to have people vote up/neutral/down on something someone has written to track whether the idea is trending up or down in terms of community interest and support. We also want to be able to add different categories and/or tags to each post. Is this something that is native within the groups/forums or is there an plugin to add this functionality?

Thanks,
Greg