[iuxc]

I’m attempting to upgrade a website I run for a group to both WordPress and BBPress. I have integrated the two and the user accounts are in sync. Everything is working fine, except…

When a user logs in from the WordPress index page, it doesn’t log them in for BBPress. This is a problem, because I want to have administration links for accounts on the homepage of my website. I want a user to login and be able to click on ‘Settings’ and go to their BBPress settings page. Also, I want them to be able to click on “Messages” and go to their BBPress messages.

So, my question is – when a user logs in to the WordPress homepage, how can I make sure they are logged into the BBPress forums as well, without requiring them to log in a second time when they go to the forums?

Thanks for your help!

[chrishajer]

There have been some relevant discussions here:

https://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page

https://bbpress.org/forums/topic/server-overload

https://bbpress.org/forums/topic/fulltext-searching-very-slow

https://bbpress.org/forums/topic/how-to-evaluate-server-speed

Looking at the front page of your forum, I see a total of 3074 threads and 22,121 posts. Is there more than meets the eye here to come up with 2.5 million rows of data? Or maybe there’s not 2.5 millions rows in bb_topics, it’s just because of the subquery that it looks at that many records (like it’s something I don’t understand about the way MySQL displays the number or rows searched)?

Did the amount of data grow exponentially after the conversion from xdforums? Maybe there were 20K rows in xdforums, but something with the conversion didn’t go well and it duplicated a bunch of data? How many rows were there in comparable tables before and after conversion?

Something doesn’t add up.

Also, are all those queries the same, and if so, is that query just trying to determine the last poster, from the “Forum Last Poster” plugin? If so, have you tried just turning that plugin off? If that works, then maybe just optimizing the query for your installation would work and you could turn it back on after modifying the plugin.

Of all the plugins, the only other one I could see affecting the queries like that would be the Post Count Plus. That would be the second one I turn off and check for a performance difference.

[chrishajer]

I think you could do something like this:

https://bbpress.org/forums/topic/wordpress-bbpress-register-plusgtgtgtgt

There are two different solutions there.

To redirect the member back where they came from after they’re done, you could do this:

https://bbpress.org/forums/topic/heres-a-trick-to-redirect-user-back-to-topic-after-login#post-14268

[finigan]

Hi,

I’ve successfully integrated WordPress 2.5.1 with bbPress 0.9.2, but I’ve encountered some issues with registering (display_name, multiple sign-ups with same email, etc.).

What I’m trying to do now is redirect all registration to the WordPress register page. My main questions are:

(1) how/where do I change the bbPress code to point to the WordPress register page.

(2) is there a way for the system to know where a user came from (forums or blog) and redirect the user appropriately after sign-up?

Thanks.

[Clicknathan]

Hello,

I’ve recently set up a BBPress forum for non-profit Bike Pittsburgh and their host, Pair Networks, shut down their database because of the load BBPress was putting on the server. Pair has since reinstated the db, but I was wondering if anyone could offer any insight as to how I might trim down the size of the queries that BBPress is putting through. A little background:

1. I used this method to convert a WordPress XDForum into BBPress. I know the author of that post mentions that the method he uses might not be the most efficient, however at this point (after the conversion), I wouldn’t think that BBPress is using any of this info any more, correct?
2. We’re running BBPress v. 0.9.0.2
3. We’re using the following plugins: Akismet, Use Display Name, BBPress Private Messaging, Post Count Plus, Forum Last Poster, and Images Allowed

The information from the host was this:

With that said, we wanted to provide a follow up in terms of the nature of the problem itself. The problem is that the database is running some very inefficient queries, trying to sort through 2.5 million rows and are returning very few to no results. These queries take a long time to run and are called “slow queries”. As you gain in traffic, the more of these slow queries that are run, the higher the load on the server, and therefore the more affect you have on other customers.

I’ve included some examples of these queries below for your review:

# Time: 080930 20:55:01

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 54 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 20:56:05

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 71 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 20:56:43

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 67 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 20:57:38

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 52 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 21:20:46

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 263 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

# Time: 080930 21:22:35

# User@Host: bikepgh[bikepgh] @ [209.68.4.180]

# Query_time: 281 Lock_time: 0 Rows_sent: 0 Rows_examined: 1952752

SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN

(SELECT MAX

(topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY

forum_id);

As you can see, these queries are taking almost 300 seconds to complete

(query_time). This is an extremely high time, as a query on a shared server

should take under 10 seconds to complete.

I hope this helps provide some needed details for you. If we can be of any

further assistance, please do not hesitate to ask.

Any help as to what I might do in PHPMyAdmin or otherwise to help lower the load on the db would be VERY MUCH appreciated!

[chrishajer]

You might want to post this on the plugin page:

https://bbpress.org/plugins/topic/private-forums/

Or contact the plugin author.

[chrishajer]

Regarding being unable to activate plugins, are you on a Windows host? What is your bbPress version, and what is your hosting platform?

Is this related?

https://bbpress.org/forums/topic/plugins-not-activating-on-local-xampp

I don’t understand your second question, sorry. My Spanish is not that good.

[rpophessagr]

I’m editing current Theme for the bbPress Alpha 1.0 Release… I have created a Side bar that appears on almost all the pages with forums listed. Just like WP category. (site: http://howtoreachmygoals.com/ask/). Now, I’m facing some problem with Looping through the Forums (bb_forums()).

My side bar is executed before main contents. so when main contents require to loop the forums again, like Category listing page / Forum on posting (selecting dropdown box). its returning NULL / empty.

I wanted to find-out is there any way that i can Reset the bb_forums( ) loop and make it available again for next time?

many thanks!

[_ck_]

WP-Syntax should take all of 10 minutes to port to bbPress:

http://bbshowcase.org/forums/topic/syntax-highlighter-plugin

I have a “Syntax-Lite” plugin in development that is less than 1k and uses PHP’s built-in (high speed) highlighter but only works with PHP code of course. It also won’t be available for quite awhile as I don’t have time for bbPress projects these days.

[beernews]

Ok, fair enough. I will delete the alpha off of my local and play around with the older version instead. Is the upgradability from release to release as seamless as WP?

[Olaf Lederer]

A syntax highlighter in wordpress/bbpress is always a hard to do.

Geshi and tinyMCE = forget it

I have finally a parser in WP but need to work in code view only.

[Olaf Lederer]

maybe because your list is empty? which bbpress version are you using?

[_ck_]

There have been so many new features added in the past few weeks in the trunk that there’s no way it’s ever going to be stable this month (October).

Even if they release another alpha (or beta but that would be crazy), that doesn’t mean it’s stable, it means it needs to be tested and debugged, thoroughly. Sam only has a limited environment to test things. Problems with PHP4 or Windows come up constantly and other things he can’t easily test. There’s also a good chance plugins will become broken (again/still).

Do NOT use the alpha on a live, active site. Period. Seriously. Not kidding. It’s not a trick. Alphas are for testing purposes only. Objects may be closer than they appear.

If you ignore this warning, you are on your own.

[chrishajer]

The rewritten links have zero to do with cookies. The rewrite rules are not working for you on GoDaddy (ed: was Dreamhost here). Have you browsed other people’s experience by following that godaddy tag?

[chrishajer]

My completely uninformed guess is … no. I wouldn’t wait. Install something and see how it goes.

If you log in here, you can see the number of open tickets by milestone: https://trac.bbpress.org/report/3 . There are quite a few open for 1.0. Also, there hasn’t been a 1.0 beta or release candidate either. So, just my guess, no.

[beernews]

any chance this becomes stable this week?

i’m antsy to add a forum to my blog but dont know if i should wait for the stable version?

[chrishajer]

Regarding permalinks, you will find lots of people expressing some problem with permalinks on GoDaddy. Just check the tag for other discussions.

That .htaccess would not work for the forum directory. That just looks like the WordPress rewrite rules changed slightly for your forum directory. You need to follow these directions:

https://bbpress.org/documentation/faq/#pretty-permalinks

[chrishajer]

Norvu, those version are incompatible. You don’t integrate the cookies. If you want integrated logins, you need to use bbPress 0.9.* with WordPress 2.5 or bbPress Alpha with WordPress 2.6.

https://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101#post-17409

[eschen]

OK, on the second issue, if I am already logged into WP but not bbPress, the link at the forum page works. So it is being logged into one or the other but not both at the same time. Oh..hum

[norvu]

WordPress version 2.6.2 and bbPress version 0.9.0.2

[eschen]

I installed bbPress 0.9.0.2 and tried to integrate with WP 2.5 site. The two are at http://www.my-site/forum and http://www.mysite/blog under the root directory. I have two issues:

First is with permalinks set to the default (/forum.php?id=1), no problem, I can view profiles and posts within bbPress. However if I use either of the other settings for a permalink, when I click on any profile or post topic within admin control panel or site view, I only get a blank page, no error. Example: the post should be at “forum/post-name”, which is exactly where the link takes me but a blank page exists. However I can view the user profiles registered at bbPress within the WP admin area, so I believe the two are at least partially integrated.

The host is GoDaddy and there are no problems with WP permalinks. I have tried the using the following htaccess code with the /forum directory:

# BEGIN bbPress

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /forum/

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /forum/index.php [L]

</IfModule>

Also just having one line:

Options +MultiViews

Also the exact code generated at bb-admin/rewrite-rules.php

Second issue is after login to bbPress, a simple link to the WP admin requests me to login again. Does this take more than a simple link to “…/blog/wp-admin/”? I have checked the cookies and both look identical.

Thanks for any help

[chrishajer]

Have you tried with a different browser? I have seen a weird problem that I can’t consistently reproduce where after submitting info to the login form, it just redirects to the login form. I was able to log in with a different browser once before, and I haven’t seen the problem since.

https://bbpress.org/forums/topic/bbpress-10-alpha/page/2#post-19153

[chrishajer]

Norvu – what versions of bbPress and WordPress are you using?

[chrishajer]

If you click the tag integration, you will see lots of people discussing it.

What do you mean by integration?

[chrishajer]

matchfox: did you already try this?

https://bbpress.org/documentation/faq/#pretty-permalinks

If your site works without permalinks, it’s most definitely an issue with the rewrite rules.