[honestscott]

Hi,

My bbpress 1.0.2 forum is causing a lot of slow queries, and I had to shut it down because my host Monster Host was Throttling my account big time.

Is there a fix for this, I am not running many plug-ins that would use the database except for bbpm, but I tried disabling this plug-in, and I still get clobbered with slow queries and CPU throttling.

I hate to have to shut the forum down, but I am not a php coder or a database administrator.

I tried moving my sites to a semi-dedicated server (to get more server resources) but their Myphp interface clashed somehow with all my WP databases.

I was on NTC hosting and their support team told me it was a problem with my WP sites, although I did get one blog to work half way decent, but my bbpress forum would not.

I was using Blue Host when I created my sites, so I went to Monster Host (their sister company) and loaded my files and DB’s and they came up just fine, but I am back to the DB strangulation with slow queries.

I check the slow queries log on my server and I see a lot of forum queries in there, but the logs don’t really pin-point a cause (plug-in or script).

Here’s a list of the plugins I have on my forum:

ajaxed quote

adsense for bbpress

bbcode buttons

bbcumulus

bbpm

bbpress signatures

bb-smiles

check for updates (not activated)

delete all bozos

mass delete users

members online

php4bb

super search

approve registration

bb-avatars

bbcode lite

bb twitter (not active)

google analytics

human test

moderator notification

new user notification

restrict registration

I would appreciate any, and all ideas so I could save my forum from the trash bin.

Thanks for your time,

Scott

[chrishajer]

Can you post your code and a link to your site (post the code at pastie.org or equivalent, since it will be munged here)? There are probably many people who could benefit from your solution. Thanks

[thors1982]

I ended up using the custom php/sql.

Much easier should have done that from the start, would have saved a ton of time too.

Also, I will have to look into the performance… because I am using a 3rd party program that integrates into wordpress… then using bbpress to integrate into wordpress so all the users need to be created at the same time etc. If they log in one needs to login to all three.

I am using the bbPress Integration plugin right now, which may or may not be working I didn’t set this part up.

But thanks, the forum posts on the homepage is working perfectly now.

[chrishajer]

Reference for the performance hit kevinjohngallagher mentions:

https://bbpress.org/forums/topic/the-cost-of-deep-integration

[kevinjohngallagher]

If you’re running bbPress1.0.1, bbPress1.0.2 is a very minor upgrade (less than 100 lines of code) and include some bug fixes.

bbPress1.0.3 / bbPress1.1 shouldn’t break that many plugins. My last trunk download caused some theme issues (minor), but up until the end of April there it was stable and looking might fine.

I strongly suggest you make a local copy of your current forum, and install the latest version from the trunk; and test against your plugins. Given the list that you have, there’s a good chance some may fail; and others like “Subscribe to Topic” won’t really be needed.

When/if this new bbpress plugin comes out, will there be a way to convert my bbpress installation into teh plugin or otherwise make it compatable?

None of us have any idea. Matt announced that the bbPress plugin was going to happen in January, then left the project. Any other information you can garnish from the WordPress blogs updates will give you more information than people involved with this project have been given.

Either way, i’m not panicing. Just irked by the lack of communication, as you’re not alone in asking, and i feel for the bbPress users who are in a form of limbo.

[kevinjohngallagher]

The bbPress Live plugin by Sam, was released and last updated around bbPress1.0alpha3.

It appears to me that the plugin makes a wrong call (possibly a bbPress to BackPress issue – as there were major changes for bbpress1.0alpha6) because it returns an empty set. On top of that, it’s aimed for WordPress before WP2.7, which itself had a large number of under the hood changes.

I’d be surprised if this plugin was even close to being fit for purpose these days; and without a doubt the solution is to pull the information from the Database directly.

bbPress and WordPress are 2 stand-alone software solutions that can share the same database/logins. Leveraging this data without adding the overhead (and potential issues) of the other will make life easier in the long run

(not to mention save 50+ SQL calls every time you load a bbpress page)

[kevinjohngallagher]

Hi Adam,

Make sure you take a backup of your MySQL data at every oppertunity when talking to your host.

If you can get one from PHPmyAdmin great, if not ask your host for backups.

Don’t overwrite them, and rename them with the day/time and after which correspondance you got the backup.

When this is all sorted, load the .sql backup into a text editor (and you can sift through the code). Might not be pretty but you’ll at least see the extent of the issue.

If it’s gone south, and the host can’t help, you’re in for a long slog. That said, one of the positives here is that the bbPress table structure (while a bit… not optomized – bad english for bad table design) is easy to read and replace/backup. I’ve had to do it myself, and we can offer tips if it comes to it, but it’s not as bad as it sounds if you get some forum of backup/old DB.

[kevinjohngallagher]

Though I missed the Trolling comments, it saddens me.

I’m disappointed by Matt’s approach to bbPress these last 6 months, and indeed quite shocked at his approach to the WordPress community over this capital_P_dangit() debacle; but I like to think I have that opinion separated between the man and the Automattic Employee.

I think it’s benefitial to point out these miscommunications. The hope is that they are seen, eventually, as a catalogue of errors, and so we can learn and improve. If my comments are being used as a soapbox for people to vent; then I apologise.

Chris, please feel free to close and/or delete this topic as neccessary.

Kev

[chrishajer]

I think _ck_’s method, which does not require integration, seems pretty clean. You can get just the information you want without a lot of overhead.

[thors1982]

Thank you for your quick reply

bbPress 1.0.2

WordPress 2.9.2 (Plan on upgrading this soon but have another plugin not working with 3.0 yet)

bbPress Live 0.1.2

I downloaded bbpress live from:

https://wordpress.org/extend/plugins/bbpress-live/

Thanks for that link as well (I am definitely going to look into that route), because I have been fighting with bbpress Live for a while now.

I am wondering if its a issue with XML-RPC, but that doesn’t really make sense because I have other applications using the XML-RPC fine, and they are both turned on in the admin sections.

Thanks again for your help

[chrishajer]

Also, without a plugin you can do something like this:

https://bbpress.org/forums/topic/heres-how-to-show-bbpress-info-inside-wordpress-without-full-integration

[chrishajer]

What version of bbPress and WordPress are you using, and where did you download bbPress Live (what version is that)?

[thors1982]

I am trying to display the recent posts from bbpress on my wordpress blog.

I tried using BBpress Live but it isn’t displaying anything at all. I tried using both functions

bbpress_live_get_forums()

bbpress_live_get_topics()

I was echoing and using print_r to display the results… nothing. Also the widgets are not displaying anything either.

Anyone have any ideas on how I can get the recent posts on my wordpress blog?

[adammurphy]

Hey Chris,

thanks for taking the time to look at this – I really appreciate it. I’ll take it up with my host. If it were the case (as I suspect), that whatever the problem is, the data is now corrupt and I’ll need to do a clean re-install, is there some way to extract the posts and repopulate bbpress?

[chrishajer]

Can’t create/write to file ‘/tmp/#sql_e93_0.MYI’ (Errcode: 22)

That is a problem with MySQL. That is something your host needs to address. MySQL cannot write to that MYI file on the /tmp partition for some reason. This is something they need to resolve.

I’m afraid your problems are larger than bbPress. The trouble with bbPress and your earlier loss of categories and the plugin problem in WordPress are all symptoms of a larger problem and something your host needs to resolve.

Are you on a Windows host? I can’t find reference to it on Linux at all. It could be something as simple as out of space on the device, but it’s something for the host to resolve.

[chrishajer]

Friday 9th July:

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

matt states that bbPress has been upgraded to latest trunk version

Where did that come from? I didn’t see that posted online.

The code running here is certainly not updated to the latest trunk. From the source of the page:

[meta name="generator" content="bbPress 1.1-alpha-2453" /]

When it’s updated, the BackPress fix will be in.

[kevinjohngallagher]

Sorry, posting quickly on phone.

Thursday 1st July:

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

Westi states that the 3 months old bug has been fixed. And will be applied to bbPress at the next patch.

Wednesday 7th July:

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

Matt states bbPress powered forums at WordPress.org has been upgraded to the latest version of bbPress and BackPress.

$this->shitty->bug() is not present. yay.

https://wordpress.org/support/topic/422478

Friday 9th July:

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

matt states that bbPress has been upgraded to latest trunk version

$this->shitty->bug() is still present and in it’s 3rd month. booo.

Might it just be miscommunication? Yes, I agree it is.

Is this bug fixed somewhere out there? Yes, I agree it is.

Is it close to commical that it’s been where for 3 months? Yes, it is.

Is something wrong with at least one of the statemetns from Matt? Given that one contradicts the other? Yes, it is.

Honestly, is it so damn hard for an Automattic employee to also update our BackPress version as well as the bbPress version? I mean, do they not know that bbPress is dependant on BackPress (definately possible)? Is it an issue of shame or embaressment at a bad decision thats coming back to haunt them, or just a mistake that gets made constantly over the last 6 months?

[chrishajer]

Where did Matt say he fixed the code/encoding issue?

We are still running r2453 here, not the latest version r2458. The BackPress fix didn’t happen until BackPress r312 on Jul 1 2010 by Westi. When the code is updated here the problem will be fixed. If you check out a new revision, the problem will be fixed in your installation.

Here is an example forum using r2458 with the BackPress fix and you can see that the code is formatted properly.

http://bbpress.chrishajer.com/trunk/topic.php?id=3#post-7

[chrishajer]

I would not try and reinstall – just try to figure out what went wrong and fix it. It will result in less work in the end, and may help someone else depending on what you find.

bbPress will not update anything on its own. WordPress won’t either (although WordPress will tell you about available upgrades.)

I think you should explain the weird issues you had and how your host fixed them. Seems likely that that’s related. Either the host did something, or you did something. Nothing happens by itself.

You can always log in to your host with FTP and get a directory listing of running plugins in the my-plugins directory.

[chrishajer]

Crossed posts – you edited yours after I posted mine.

To have different counts for different things, you need a plugin.

I think this will work:

https://bbpress.org/plugins/topic/front-page-topics/

[chrishajer]

It’s located in your admin section, under Settings > Reading

http://www.example.com/forums/bb-admin/options-reading.php

The option looks like this:

http://chrishajer.com/bbpress/items-per-page.png

[ts230]

Is it possible that a long topic, that has like 100 posts is split up into pages of 15, like most board softwares do? I haven’t found the feature yet, or is this part of the bbPress core? Any help is appreciated. If it helps, I’m using bbPress 1.0.2.

[adammurphy]

Hello,

I had bbpress installed and working very nicely – integrated with wordpress and working as a private forum for to allow guests to discuss our upcoming wedding. All was going well, but I’ve suddenly found that I can’t get into the forum or the administrator section because the installation error screen is coming up:

Oh dear!

bbPress is already installed.

Perhaps you meant to run the upgrade script instead?

I have had some weird issues recently which my hosting provider may or may not have “fixed” by rolling back to 6th July. So I have 2 questions:

1) Does anyone have any idea what might have caused this? I haven’t touched either the WP or bbpress installations at all. I assume nothing in bbpress would update automatically and break older versions of wordpress (I’m still on v2.9-ish). I realise this is a ludicrously weak bug report but I’m a bit lost right now and I can’t get into bbpress to check what plugins are active, which version I’m on etc…

2) If I do need to just cut my losses, wipe it clean and reinstall, is there a way to backup everyone’s comments and then repopulate the fresh bbpress with them?

Any help most appreciated,

Adam.

[chrishajer]

To check out via subversion:

svn co http://svn.automattic.com/bbpress/trunk/ ./testdirectory

[chrishajer]

I think the best thing to do in your case would be a test installation of the latest trunk release of bbPress (not the packaged 1.0.2 release.) There’s no way to know if all that is going to work on the latest version of bbPress, but I suspect most of it will.

I would copy over your database, then install bbPress with subversion. Then copy over your template and plugins. Then test. If it all works, then go ahead and upgrade your 1.0.1 installation.

Regarding when bbPress becomes a WordPress plugin, it doesn’t really matter. Use what works for you (right now, that’s a standalone installation, as you have here.) That code you have installed is never going away. If a time comes in the future where you can move to bbPress as a WordPress plugin, then go ahead and do it. But use what works for now and don’t wait for any version coming in the future.