[_ck_]

Oh and looking at a MySQL performance guide for text search, apparently bbPress’s search is using ALL of the slowdown triggers:

order by

group by

and worst of all SQL_CALC_FOUND_ROWS

How long does this query take without the modifiers:

SELECT * FROM bb_posts WHERE post_text LIKE '%test%' LIMIT 5;

because that’s as fast as it can possibly get without an index and should be used as a baseline.

Looking at the original query, I believe they are causing a FULL scan of the entire table to rank and group it first. That’s going to be insanely slow.

You might be able to just use LIKE with a simple sort by post date DESC.

The largest bbPress install I have access to has nearly 100,000 rows and still only takes 0.04 seconds for that trimmed query. The original queries you posted take 0.5 seconds so that’s 10x slower.

[_ck_]

But keeping a full-text index can get rather huge, which is probably why bbPress doesn’t use it by default.

BTW, MySQL 5.1 apparently has some nice improvements in fulltext search.

If you have your own dedicated or vps server you can tinker with some mysql settings to speed things up. (You never did answer if you have mysql cache turned on)

[_ck_]

If I had the ability to delete accounts it would be for people who insist their “missing feature” is the most important

Fortunately they are smart enough to not let me delete accounts, lol. Your missing feature is the least needed feature for thousands of other people.

Let me express this for the 100th time (not just to you, to everyone). 1.0 is *alpha* – it’s not stable, it’s not final, it’s not even close to final. They are adding and changing things daily. Sam just changed something this morning.

The bb-sync author (fel64?) did a fantastic job. But bbPress changing is not their fault (or their problem unless they want it to be).

If they go and spend hours to make it work now under 1.0 alpha, it may break again tomorrow. And the day after that. They are still changing 1.0 alpha and will change it again.

You running 1.0 alpha right now for a live, active site is exactly one person’s problem, yours.

[cartmanffc]

a few days ago I successfully integrated bbPress with WordPress and installed this amazing plugin bbSync; for a few days it all worked seamlessly – every comment in WordPress was going to relevant topic in bbPress and if someone went straigtforward to forum and commented there their comments were included inside relevant post in Wordpres; just brilliant!

but…

I upgraded to WP 2.6.1 and integrated with 1.0 Alpha (trunk) and it all went wrong; it’s true, even in WP 2.5 + 0..9.2 there occurred some errors but integration between the forum and the site was perfect; and now it does nothing at all and all I get is the following error:

“Fatal error: Call to a member function on a non-object in /users/adado/www/fulham.pl/forum/bb-includes/functions.php on line 20”

it looks like the author of the plugin doesn’t maintain his project and it’s really sad ’cause this is THE PERFECT INTEGRATION of both applications

I would be in seventh heaven if I woke up one beautiful morning, checked the bbPress.or and.. there it is! a new built-in feature of bbPress 1.0 which makes what bbSync used to do

I’m PHP amateur so I cant’ do this by myself but I strongly believe there are some brainy people who could make life of many people happier; and looking at the list of plugins: bb Reputation, New User Notification, Post Count Plus, bbPress Signatures, Unread Posts… and many many more I’m talking about one specific person

all I’m begging for is one more plugin

please!

[soundofsilver]

I’m running WordPress 2.6 under root; bbPress under /forums and also using K2 1.0RC7 as my WordPress theme.

I have made a new page called ‘Forums’ on WordPress which is now in the navbar and have used the plugin ‘Page Links To’ to make this page point to /forums.

However, what would be the best way to get the blog acting like this one, for example:

http://onvertigo.com/ …. clicking ‘Forum’ lets bbPress load underneath the header.

There is a K2 theme floating around for bbPress but it doesn’t have the top nav…..

Any help would be appreciated!

[_ck_]

I thought I made a mini-plugin to fix this.

Yup, I did.

https://bbpress.org/forums/topic/registering-with-another-users-email

[_ck_]

I think that’s one of the default javascripts scripts loaded in the topic.php page.

It only shows in mini-track because it’s generated by a php file.

Most of the javascript in bbPress can be disabled and makes for faster loading pages (ajax goes away however).

So the answer is no, it’s not hacking. But you will see the attempts sooner or later – there are thousands of bots out there scanning sites and most people are unaware.

I’ll put in some code to exclude bb-includes in the next mini-track.

[Sam Bauers]

@kannued

We hope there will be no difficulty at all.

[cartmanffc]

I just checked the plugin (Edit History) and it might be quite useful (I wouldn’t mind having this integrated in next version of bbPress …) which I can’t tell about Post Revisions in WordPress….

IMHO every new feature should have option to disable it within admin panel without resorting to tinkering with wp/bb-config files

hopefully the stable version packed with new features (like the i-Phone related one) will leave users the choice to use them or not

[brad_langdon]

I am using mini track and am getting people listed as navigating towards random urls such as

/bbpress/bb-includes/js/list-manipulation-js.php?ver=440

That doesn’t sound like somewhere they should be…are they bots?

One has signed up and is navigating to strange places such as the one above.

Sorry if this is a stupid question.

[chrishajer]

https://trac.bbpress.org/ticket/894

[hyapadi]

I agree with the ideas of having a plugin that will do the integration of both standalone BBPress and WordPress.

One of the strength of WordPress is its easy installation & expansion through plugins. But the only missing thing is good plugin that will do the integration with forums seamlessly.

I’m really looking forward for this.

[Clicknathan]

So here’s what I found, though I wasn’t personally able to get it to work myself, I’m almost positive that someone with a bit more PHP knowledge would have been able to:

This plugin: https://bbpress.org/plugins/topic/forum-last-poster/#post-1538

+ _ck_’s advice in this post: https://bbpress.org/plugins/topic/forum-last-poster/#post-1546

He details how, using substr, you can truncate the amount of words being pulled from the any piece of content. Theoretically you could use:

post_text(forum_last_topic_id());

But with the truncation method he mentions. I, unfortunately, just don’t know how.

[chrishajer]

One of these?

https://bbpress.org/plugins/topic/page-links-for-bbpress/

https://bbpress.org/plugins/topic/my-views/

[nekita]

Hello Sam,

yes I thought as much, but I had a database backup ready so it’s all good.

So is it safe to assume that one is better adviced to wait with deeper integration until 1.0 or a stable beta is released?

Thanks

Lars

[_ck_]

Super-Search is currently over 20k and only about halfway done in what it needs to do. All the bbPress core needs is a proper way to and/or words and disable partial matching instead of defaulting to just searching for every single fraction of each word.

[kannued]

With so many structural changes underway in 1.0, will there be difficulties in upgrading from .9 to 1.0 stable?

[Sam Bauers]

https://bbpress.org/blog/2008/09/bbpress-10-alpha-series-update/

[Sam Bauers]

@Nekita

Don’t modify your bb-config file until after you have installed bbPress.

Even then I can’t guarantee it will work with Trunk as it isn’t tested for deep integration yet.

[thion]

I just can’t wait for 1.0 Stable, as I’m going to use it as core for new version of my Open Cafe.

[nekita]

The essence of this is that it screws with the usermeta data in the database once you try and integrate WP functions, up to a point where even your admin account for WP doesn’t work anymore.

Here’s an example:

Variant1:

1. Upload bbP to the Server

2. Change the bb-config.php including the require_once line

3. Run the Installer

4. After Installation is finished you can’t log on to your WP admin anymore because the admin user suddenly has insufficient access rights, requiring a database restore.

Variant 2:

1. Upload bbP to the Server

2. Change the bb-config.php excluding the require_once line

3. Run the Installer

4. Add the require_once line after installation is finished

5. Your WP admin account is still working as it should and you can even use it for bbP, but with the Inactive user status.

Doesn’t make much sense, does it?

[_ck_]

Post revisions? You mean like my Edit History plugin?

[_ck_]

You can also do it this way:

http://google.com/search?q=RossB+inurl%3Abbpress+org+forums+site%3Abbpress.org&num=100&filter=0

[doyle640]

By the way, i am also having the problem with the some of the forms, like the reply forms, disappearing. No html is posted whatsoever. I haven’t looked into it thoroughly yet though.

[RossB]

I am making this enquiry on behalf of the tech guy who is supposed to be migrating over to a uni intranet a bbPress forum I customised.

I originally hosted it on the server of my own web host, and all was working fine. There were also a few posts by various members of the uni faculty I was designing a website and the forum for.

The tech guy has been having trouble getting the customised version of the forum working on the uni intranet. I know very little technically, but I was thinking maybe it would be easier for him to simply download a new version of bbPress then copy and paste my customised pages.

Not sure how he’d get the posts to show up with the posters’ names and dates of their posts etc, though. I did email him the database of the bbPress forum I customised for them. Would this be all he needs?

I can’t recall for certain which pages I customised, but I can look back through this forum to find out, I guess. Anyway, interested in the advice of techies here as to the easiest way for this uni tech person to approach the migration task.

Cheers!