Hey guys,
I have a busy bbpress board (http://boards.weddingbee.com) that uses slug-based permalinks. The database has been slow lately, so I started optimizing tonight. While scrolling through the queries in the slow query log, I saw many log entries like this:
SELECT topic_id FROM bb_topics WHERE topic_slug = 'gerbera-daisieswhere-can-i-order-them-wholesale';
Let me back up. The default install for both the old school 0.83 and the new 0.91 has URLs like this:
* http://boards.weddingbee.com/topic.php?id=999
However, I set my bbpress to use “slugs”, so that topic redirects to:
* http://boards.weddingbee.com/topic/need-advice-re-florist-mess-up
The problem is that a slug-based URL requires a database query to translate the ‘slug’ (need-advice-re-florist-mess-up) into a topic_id (999). However, the topic_slug field in the bb_topics table is not indexed. in the bbpress database. Thus, the database needs to scan the entire bb_topics table to find the topic_id!
In short, if you want to use slug permalinks, you should go in and index the topic_slug in your database, or your database will be slow once you have lots of topics. You may also want to index tag (in bb_tags) and forum_slug (in bb_forums). I saw a substantial improvement in performance upon adding these indices via phpmyadmin.
Anyone else run into this issue?
-Bob
P.S. In a perfect world, bbpress might automatically index these fields if the keymaster selects “slug” or “name-based” permalinks.
My shiny new bbPress forum is trying to send the messages to me when a new member signs up without anything in the To: line. They don’t send because of a missing recipient address, which means they still wind up in my inbox through a different account but I’d like them to send correctly if possible.
I assume I’m just missing a setting somewhere. Where do I set the email address that these messages should be sent to?
Is it possible to delete a topic and all the replies that are associate with it with one click somehow?
Example: Topic page:
/topic/this-is-a-topic?replies=3#post-175
There are 3 replies to this topic. I would like to delete all replies and comments at once.
I followed the upgrade instructions and it never noticed my old posts. They are all gone and I’m back to zero! Help!!
Is there a manual way to upgrade? Can I import them all? HELP.
Hi. I’m using 9.0.1. I would like to restrict the number of Latest Discussions showing to 5. How do I do this? I don’t see anything in the bb-config file and the Front Page Topics plugin doesn’t seem to work with 9.0.1…
Your help appreciated.
Hi,
I wish to uninstall bbPress from my WP 2.5 installation and was wondering if it were as simple as:
– Deleting the forum sub-folder from my /blog/forum folder
– Dropping the bb tables from the shared database
Thanks,
Gene
Wp/bbpress issues after upgrade.
I stupidly upgraded to WP 2.5 before upgrading BBPress (I think I am still on 0.83, though I confess I am having trouble figuring that out–where to look?)
Since the WP upgrade, I was unable to login to bbpress. (I thought something had gone wrong, so I reset my password, and that did not work–the new password works in WP but not bbpress.)
Oddly, a Moderator can still login, as can regular users.
I now, obviously, want to upgrade bbpress ASAP and get this worked out. Is it going to be a problem that my admin account isn’t currently working? Is there some point in the upgrade process where I need to reset this somehow?
Thanks!!!
I’ve set up a new forum and I when I add “replies” it redirects and gives an error message:
You need to actually submit some content!
But the post actually goes through. Thoughts?
One of the major stumbling blocks for implementation of permalinks is the creation of the .htaccess file.
There is at least one ticket requesting automation of the creation process via the admin area of bbPress (just like WordPress does). But the problem with that is that we support both the “MultiViews” and “mod_rewrite” methods of creating permalinks.
In light of this and some other problems with “MultiViews” I’d like to gauge the possibility of dropping “MultiViews” support in favour of “mod_rewrite”.
What do you all think? Do you use “MultiViews” or “mod_rewrite”? Why? Would you really miss “MultiViews” support?
1) I need change default gravatar image at forum to my own. Where is the link? i cant find it.
[ RESOLVED – i found it at: bb-icludes/pluggable.php ]
2) i saw Karma/Reputation plugin… but again, i cant find it.
