I created a database with full privileges and a user on the host and then entered it into the script. I received a message saying there was a failure to connect to the database.
The user name and password fields were populated with the admin login and pass from my WordPress installation. I used that login and name to create a user for the database, and then I re-ran the script with the default entries. Still can’t connect.
Any help would be appreciated.
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.
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:
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!
Does RSS feeds work with the private forums plugin? Can you download the feed after setting a cookie in your RSS reader, using a secret URI, or something else?
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!
This was originally going to be an “It’s not working!” post, but I made some progress. Now it’s “Is what I did ok?” post.
I kept getting a”This Topic is Closed” error every time I tried to create a new topic. Traced it back to the insert statement in ‘bb_insert_topic’ in functions.php. The database was responding with the error of “The value ‘ ‘ is not a valid integer for column ‘topic_id’. (I am paraphrasing, I don’t have the exact response in front of me)
I suspected it had something to do with the fact that the topic_id value is being supplied to MySql, but it is set to be an auto-increment / not null field.
So, I commented out in the $default array definition in ‘bb_insert_topic’:
// 'topic_id' => false, // accepts ids or slugs
and I changed this line:
unset( $default, $defaults );
to this:
unset( $args, $defaults );
Did the same thing under the ‘bb_insert_post’ function in the same file, but for the ‘post_id’ variables.
Presto. Everything seems to work OK now.
Could this issue be specific to my version of MySql? Although it is strange, because the original query works just fine using a third party tool (SQLyog).
Has anyone encountered this issue before? Or – can anyone comment on the validity of my changes, and if they might cause issues going forward?
Finally – should this be logged as a bug?
Thanks!
WP 2.6, BB 1.0, IIS 6.
I believe this glitch occurs on fresh/re-installs? of the current stable version.
Rather than clear cookies and sign into EVERY site again (I go on like 20-30 sites, what a nightmare).
Use the search function when you’re in the cookie list and type in, “wordpress_bb”
You will see a list of them. Notice below the list there is info for each cookie. See where it says path? The cookie you need to remove will say ‘bb-admin’ somewhere in the path. Remove it. Click the admin link and you should be good to go.
I logged out and logged in and looked at a few pages and can still access admin. Havent closed the browser yet so we’ll see if this holds.
Im editing my theme Peacemaker and i wonder what do this change in the forum: “#latest th a:link, #latest th a:visited, #latest th a:active {
color:#455A79;
}
.rssfeed{padding: 12px 0;}
.bozo { background: #eeee88; }
.alt.bozo { background: #ffff99; }
.deleted { background: #ee8888; }
.alt.deleted { background: #ff9999; }
” Beacuse i dont see what it changes, when i change the colour. Please help me.
Hi,
I’m using version 0.902.
My case I’m a user and not logged in
I select a forum and click “add new”
next I need to login
while pressing the button I get this error:
Warning: parse_url(http://#postform) [function.parse-url]: Unable to parse URL in /home/user/domains/domain.com/public_html/forums/bb-includes/pluggable.php on line 272
Warning: Cannot modify header information - headers already sent by (output started at /home/user/domains/domain.com/public_html/forums/bb-includes/pluggable.php:272) in /home/user/domains/domain.com/public_html/forums/bb-includes/pluggable.php on line 228if hit the back button/refresh I’m logged in.
I tried the same on this forum and after hitting login nothing happens and I’m logged in.
I guess you guys know about this problem? (sorry couldn’t find the info)
and if you know how to fix this, please advice.
Thanks
I would like to disable ‘BBcode Buttons’ automatic placement, and put the toolbar manually – I tried to place bbcode_buttons() in the post.php but nothing shows – any tips?
