[kevinjohngallagher]

I’ve spent the last week working with a client on a rather large WP/bbP setup. One of the real joys of this project is that it’s large enough for me to get some time in for more than asthetics and QA. Hence, a few more posts her this last week and some code, and some BackPress help.

Anyway, one of my junior developers came up with an interesting stat the other day that I’ve been looking into, namely Deep Integration and it’s hit/performance. I’m sure almost all of this will be obvious to a great many of you, but I thought I’d throw out some figures.

Single Loading of software after install

WordPress2.9.2		16 database queries

WordPress30			19 database queries

bbPress0.9			09 database queries

bbPress1.0.2			16 database quieres

Single Loading of software after setup

WordPress2.9.2		19 database queries

WordPress30			23 database queries ***1

bbPress0.9			10 database queries

bbPress1.0.2			18 database quieres

Now the first thing I noticed is that WP3.0 took a leap in queries. Once it takes you 20+ queries to load a simple homepage with no plugins my spider sense is tingling. Turns out that WP3.0 is somewhat sruggling with it’s new menu system. ***1 It takes 6 queries minimum, plus 1 query for each taxonomy type used in the new menu (apart from hardcoded links with don’t get an additional query). That’s a heck of a leap for something as simple as a menu. I mean, menu’s are rarely dynamic – they don’t change that often. For this particular website, as will probably be the way for the others I’ve moved to WP3.0, I’m looking at a minimum of 8 database queries simply to load the data needed to display the name and link in a menu. To be clear, that’s over 30% of database queries on a clean install of WordPress that are being called by this.

As cool as the drag/drop facility is, make every menu item a custom link and you’ll save a minimum of 2 db calls per page load.

Even better, hardcode the actual menu and save yourself 8 database calls per page load (you can hardcode an array for the walker class to iterate through and produce the same result)

Single loading of software after basic/core plugins:

Now, I believe that no WordPress (nor bbPress) install can run as expected these days without certain plugins. Your thoughts on this may vary ofcourse but I find that I need a minimum of WP-Super-cache, XML-sitemaps, WP-security-scan, wp-pagenavi, headspace/All-in-one, WP-stats, and probably a few others that I can’t remember off the top of my head. Oddly for bbPress I need more plugins.

WordPress2.9.2		23 database queries

WordPress30			27 database queries ***1

bbPress0.9			18 database queries

bbPress1.0.2			29 database quieres

That’s quite a leap. But I’m confident that I could bring down the bbPress Queries with some time spent considerably, and I could enable caching from WordPress. I’m not posting this data in itself as definative stats for everyone, so there could be optomization made for sure.

Deep Integration of WP3.0 and bbPress1.0.2:

WP3 & bbP1			56 database quieres

56! With virtually no caching availible (as a plugin, for the average user with no .ini or shell access).

56! On every page (+/- a few queries).

Deep Integration of WP3.0 and bbPress1.0.2 – after first pass:

WP3 & bbP1			43 database quieres

Ok some quick theme changes and delayed/circumvented loading of certain things and I’ve brought it down considerably.

But the fact still remains that this is a truly crazy amount of database queries per page load.

Anyway, after presenting this (in a better looking format) to the IT director of the client, I’ve managed to re-assign myself 2 weeks to come up with a planB. We want something that allows us the functionality of Deep Integration, but without the MASSIVE overhead. I have an idea down on paper, but right now I just wanted to post a few figures and give folks a heads up.

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

Edit: If you want to see something fun, try this:

Add to your bb-config.php and your wp-config.php

In bb-config.php and wp-config.php add the following line:

define('SAVEQUERIES', true);

Then add the following code to your footer.php in your theme (right at the bottom)

wordpress footer

global $wpdb;

echo "[pre]";

print_r($wpdb->queries);

echo "[/pre]";

bbpress footer

global $bbdb;

echo "[pre]";

print_r($bbdb->queries);

echo "[/pre]";

*** replace the square brackets [] html brackets (they’re not showing up correctly)

[chrishajer]

If you don’t want a table prefix, I suppose you could go into the bbPress code and eliminate all the references to the WordPress table prefix in the installer (and possibly elsewhere.)

It would be much easier to rename the WordPress tables and use a table prefix than hack the bbPress code. You tried once and did not have a good result. Maybe you need to try again and figure out where it went wrong if you really want integration between bbPress and WordPress. Either way, it’s going to require some work on your part due to a decision you made earlier to eliminate the WordPress table prefix.

[chrishajer]

bbPress is not a plugin for WordPress (unlike BuddyPress, which IS a WordPress plugin, and includes forums that are based on bbPress.)

You install bbPress along side WordPress (or by itself even, if you want) but it does not become part of your WordPress installation like a plugin.

Related recent post:

https://bbpress.org/forums/topic/instalation-folder#post-70542

[chrishajer]

I think it would probably work if you changed the user check to reflect bbPress users and not WordPress users and levels.

_ck_ posted something similar a while back on the WordPress.org trac site about blocking long query strings. Maybe she will post here about this.

simple WordPress and bbPress security plugin to block long requests

https://core.trac.wordpress.org/ticket/8152

[gerikg]

I use deep integration for WP themes that have their own option. When you change something in the option bbPress follows.

[gerikg]

If you don’t enter a prefix, bbPress assumes you don’t want the integration.

[pagal]

Can I use this wp plugin for bbpress?

< ?php

/*

Plugin Name: Block Bad Queries

Plugin URI: http://perishablepress.com/press/2009/12/22/protect-wordpress-against-malicious-url-requests/

Description: Protect WordPress Against Malicious URL Requests

Author URI: http://perishablepress.com/

Author: Perishable Press

Version: 1.0

*/

global $user_ID;

if($user_ID) {

if(!current_user_can(‘level_10’)) {

if (strlen($_SERVER) > 255 ||

strpos($_SERVER, “eval(“) ||

strpos($_SERVER, “CONCAT”) ||

strpos($_SERVER, “UNION+SELECT”) ||

strpos($_SERVER, “base64”)) {

@header(“HTTP/1.1 414 Request-URI Too Long”);

@header(“Status: 414 Request-URI Too Long”);

@header(“Connection: Close”);

@exit;

}

}

}

?>

And tell me how can I make my forums more secure?

Nedd Tips and Tricks!!

And did anyone make any security concern plugin for bbpress?

Thanks,

Pagal

[masterlock1]

I’ve recently ungraded to WordPress 3.0(Multi-User). The instructions referenced here: http://wpbbpthemes.org/integration/ are for an earlier, single-user version. Any feedback would be appreciated. Thanks.

[kevinjohngallagher]

Great! Screenshots make life so much easier.

Ok so you physically know the files are there, but can’t load them in the browser (we get a 404).

If you’ve had htaccess issues before, I’d have a look there first, but really if it’s loading bbPress it shouldn’t be an issue (always good to rule things out though).

My gut, growing by the day sadly, tells me it’s a permissions issue. Which is not to say you’ve done anything wrong. Make sure that the “my-templates” directory and all directories/subfolders are at 0755.

Test again. if things work, then change everything under the “my-templates” directory to 0644, and confirm working.

Finally, and this is out on a limb a little, check you’re not running any caching plugins in wordpress.

If that doesn’t work, we’ll see what we can find in the back (the back is a mythical place apparently)

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

EDIT: Actually, do you have some form of htaccess command to change everything from http://www.shoeynet.com to just http://shoeynet.com ?

That might not be it, but it’s something else to knock off the list.

[kevinjohngallagher]

Hi there,

Installing with a preexisting wordpress install is absolutely fine, and you don’t need buddyPress.

I’d suggest using this excellent tutorial:

http://wpbbpthemes.org/integration/

[shoeyn]

It’s probably my htaccess file because I’ve had problems with that in the past with other installations, but what would I have to change for it ?

and I’ve added the screenshot to the first post on my wordpress install

http://shoeynet.com/2010/07/publishers-wanted/

Everything which is greyed is not necessary

[chrishajer]

The files are not where you think they are, or the permissions are wrong. Or you have something weird going on with your WordPress .htaccess file. But if a physical file or directory exists on the server (like your forums directory) WordPress won’t handle the request for it.

Can you post a screenshot from your FTP program showing the location of all the theme files in relation to your bbPress installation?

[kevinjohngallagher]

Don’t worry about Deep Integration. If you don’t know it, you’ve not got it, and that makes life easier

If you can’t load the stylesheet of the theme you want to use in your browser (and therefore independant of both wordpress and bbpress – as you’re essentially just loading a text file from a server), then that’ll be the issue.

Activating the theme you’re after would be great, as would telling us what folder it’s in and what it’s called

[shoeyn]

No I can’t

What’s deep intergration ? (Knew to this)

bbPress 1.0.2 and WordPress 3.0

[kevinjohngallagher]

Can you load the stylesheet of the theme you wish to load directly into the browser (by typing the URL into the address bar) ?

Are you using Deep Integration?

What version of bbPress and WordPress are you using?

Kev

[ethanthekiwi]

I am running WordPress 3.0 on a Turnkey Linux based server that is my own (not hosted). I downloaded the latest version (1.0) of bbPress and put it in /var/www/wordpress on my server. I went to mysite.org/bbpress (that’s not my actual domain, but it’s an intranet site anyway so it doesn’t matter) and went through the installer. I created a mysql database and everything else. I skipped integrate with WordPress (for now) and the installer worked. I went to mysite.org/bbpress and I could see the front page of the forum and everything looked fine. When I try to log in using the Key Master username and password I got from the install, I get sent to a page with:

Warning: Cannot modify header information – headers already sent by (output started at /var/www/wordpress/bbpress/bb-config.php:1) in /var/www/wordpress/bbpress/bb-includes/backpress/class.wp-auth.php on line 273

Warning: Cannot modify header information – headers already sent by (output started at /var/www/wordpress/bbpress/bb-config.php:1) in /var/www/wordpress/bbpress/bb-includes/backpress/class.wp-auth.php on line 273

Warning: Cannot modify header information – headers already sent by (output started at /var/www/wordpress/bbpress/bb-config.php:1) in /var/www/wordpress/bbpress/bb-includes/backpress/class.wp-auth.php on line 273

Warning: Cannot modify header information – headers already sent by (output started at /var/www/wordpress/bbpress/bb-config.php:1) in /var/www/wordpress/bbpress/bb-includes/backpress/class.wp-auth.php on line 273

Warning: Cannot modify header information – headers already sent by (output started at /var/www/wordpress/bbpress/bb-config.php:1) in /var/www/wordpress/bbpress/bb-includes/backpress/class.wp-auth.php on line 273

Warning: Cannot modify header information – headers already sent by (output started at /var/www/wordpress/bbpress/bb-config.php:1) in /var/www/wordpress/bbpress/bb-includes/functions.bb-pluggable.php on line 232

I went and deleted everything and started over with the same result. I don’t know if it means anything, but I didn’t get an email from the site with the Master Key password either. Can anyone give me an idea of what I might be doing wrong? I not a coding expert, but I can usually figure these kind of things out. I would really like to use bbPress as it looks like the best forum for my users (which includes a wide range of people many of whom are not technologically savy). If you need any more technical details let me know. Thanks in advance.

[shoeyn]

I’ve integrated bbpress on top of my wordpress installation

http://shoeynet.com

http://shoeynet.com/forums

No matter what I do, I cannot get the themes to work, all permissions are right and they are all in the right place, but I think it’s conflicting, I think wordpress is trying to take ownership of the theme files instead of bbpress

Can someone please help

(Because of issue, I’ve taken out link to forums from wordpress page)

[chrishajer]

Where is the menu you’re talking about? If you want a link back to your WordPress site in your header, just edit the template file header.php and put the link wherever you want it.

[kevinjohngallagher]

I don’t believe you can.

I’m sure that bbPress requires a WordPress table prefix for integration, at least in the installer.

[FMA]

I don’t want to change anything to my table-prefix’. How can I resolve this problem, then?

[kevinjohngallagher]

Not really. At least not easily, and there is no existing and easy to use plugin. That said, if you’re dilligent enough and have enough PHP skills you could probably garnish a solution from the threads _ck_ links to here:

Extra dropdown field in registration page

[EDIT chrishajer]

If you have bbPress integrated with WordPress (sharing database and logins), then I strongly suggest using WordPress for registrations as you can theme and plugin to your hearts content there.

[kevinjohngallagher]

Howdy,

I’m after some feedback folks, and I’d really apprecaite anyone who could spare some time to jot me down some quick answers:

• If you use Deep Integration for a bbP/WP install, could you please list the reasons why?

• What data, if any, do you pull into your forum via a WordPress function?

• What WordPress plugins are displayed on your forum?

Any and all data from any level of bbPress user would be really really helpful.

Thank you,

Kev

[alex_ht]

Have installed the latest bbpost version and successfully integrated it with my wordpress site. I am looking for someone to integrate bbpost into my existing wordpress theme (cubit). Please post a bid.

Integration must be clean and meticulous. Css not as important – I can do that later myself.

PayPal payment preferred.

[chrishajer]

I recommend uploading all the WordPress files again. Looks like something happened on the transfer.

If that does not resolve it, please direct your question to the wordpress.org/support forums since this looks to be a WordPress issue.

[chrishajer]

There are no line numbers in this file:

http://svn.automattic.com/wordpress/tags/3.0/wp-includes/wp-db.php