[stiffmeister12]

So I am using a custom theme for my site and when I integrated bbpress into my theme the alignment is just off for some reason. On the home page the top bar is a little miss aligned where it says “topics” and “posts” Link – http://dailymut.com/dailymut-forums/

When I go into a topic the alignment is really off under “topic” and a part of background is missing under “voices” “posts” and “freshness”. And There is a random circle over the “voices” text for some reason. Link – http://dailymut.com/forums/forum/madden/mut-player-reviews/

Finally when I go into the Topic The picture is not aligned with the username and the text box looks off as well.

I have tried to change the style.css and I have tried to change the bbpress CSS and nothing has worked maybe im imputing the wrong code or maybe im not in putting it correctly. Either way if anyone can check it out and see what the problem is and could tell me what code to input and where specifically to put it that would be greatly appreciated.

[Robkk]

I don’t think that you can exclude forums with the shortcode.

You could allow your group forums to have a parent forum so that they do not all show up on the forum arhive.

• go setting > forums
• scroll all the way down to BuddyPress Integration
• Now select the group forums to have a parent forum from the drop down list.

[Luis Fatorbinario]

Can someone please post the link here. I only opted by bbPress over other options because I saw this nice sidebar in this forum.

And if you guys implement the code as a plugin or something bbPress would have many more installs.

[Robkk]

I think what you are looking for is in the loop-single-topic.php template and the other one is maybe loop-single-forum.php.

[christianslater]

Hello I am using bbpress in conjunction with buddypress. I also activated the function to allow forum creation with creation of a buddypress group.

Additionally I want to have forum page. When I place the shortcode on a page all forums are displayed also the ones that are created with buddypress group. Is it possible to exclude these forums form the page?

[Stephen Edgar]

Another potential idea would be to modify the code to “limit” the repair tool amount of replies it’s trying to do each time.

I’m not sure how many forums your site has, but maybe restricting that by forum ID may drop you down from 3 million to something more reasonable to process in under 30 seconds?

[Stephen Edgar]

The reply position is stored in wp_posts in menu_order, the first reply of a topic should be 0, then each reply after that increments by 1, that is what the end goal should be.

[Stephen Edgar]

You could also try running that same query you did above where it returned 3,763,193 total replies, then run the repair reply menu order repair tool and run the query again then subtract that new total from the original 3,763,193 to see how many replies are getting there menu order updated before PHP times out, then divide 3,763,193 by that number and you’d have a theoretical value of how many times you would need to run that tool before all replies are actually repaired 😉

[Stephen Edgar]

Two functions bbp_update_reply_position() and bbp_get_reply_position_raw() are what you need to look at:
https://bbpress.trac.wordpress.org/browser/branches/2.5/includes/replies/functions.php#L2113
https://bbpress.trac.wordpress.org/browser/branches/2.5/includes/replies/functions.php#L2149

The two functions above are what calculates the reply position in the database as it doesn’t actually exist in the database until either a) a new reply is added to a topic or b) the repair tool is ran to calculate the reply order.

[mmice]

Well, i ran:

SELECT a.ID FROM bb_posts AS a
INNER JOIN (
 SELECT menu_order, post_parent
 FROM bb_posts
 GROUP BY menu_order, post_parent
 HAVING COUNT( * ) >1
)b
 ON a.menu_order = b.menu_order
 AND a.post_parent = b.post_parent
 WHERE post_type = 'reply';

3,763,193 total, Query took 11.5215 sec
I guess it’s only SELECT and yep, it returns what is have to be fixed?
Script seems to make “bbp_update_reply_position” with that information. Where can i find the reply position in DB?

[Stephen Edgar]

You would want to do a search and replace in your database to change it from a BBCode link to a compatible link e.g. http://youtube.com/video_url.

I’m not familiar with “Aeva media” so can’t really help in that regard.

Using a search and replace plugin like the following might be what you need:
https://wordpress.org/plugins/search-and-replace/

You would search for the “Aeva media” BBCode, eg. [aver_video]video_url[/aver_video] and replace it with http://aver-vidio-domain.com/video_url

[Stephen Edgar]

Found the patch, it needs lots of testing and I haven’t had the time to take even a cursory look at it yet https://bbpress.trac.wordpress.org/ticket/2731, so lets leave that aside for now.

The code is here, I’m not sure your level of PHP knowledge but I’ll just add the link to it for now and will follow up after you’ve had a look at the code:
https://bbpress.trac.wordpress.org/browser/branches/2.5/includes/admin/tools.php#L1134

[mmice]

I really appreciate!

Yep, it’s likely php script code limitation. I already asked for admin’s to encrease php_time_limit, but it’s still to small ))

[Stephen Edgar]

I’ll go grab that code for you now, I’ve also got a patch that I’m trying to find that fixes this per the details below.

The thing is, the tool works as you noted that it works for when you’ve only got 2 replies, it fails on millions because the PHP code times out after 30 seconds, theoretically if you keep running that tool, click back after each white screen and hit go again you will eventually achieve said goal, with millions I would not advise this though.

[Stephen Edgar]

Ok, run ONLY the following 3 repair tools: https://codex.bbpress.org/features/repair-forums/

* Recalculate the parent topic for each post
* Recalculate the parent forum for each post
* Recalculate last activity in each topic and forum

Do the replies look OK in the backend now?

If not then run this repair tool:
* Recalculate the position of each reply

How about now?

(The above should repair all the post_meta for you)

[Stephen Edgar]

Ha… Using bb_ as your table prefix really did throw me 😉

If you look at lines 59-60 for your topics your selecting the forum_id from the phpbb_topics table and inserting it into post_parent

https://gist.github.com/anonymous/8d1cb71e69d52ac69f5d#file-gistfile1-sql-L59-L60

The same needs to happen for replies, so you should be able to get the topic_id that the reply is for and then insert that into the reply post_parent

https://gist.github.com/anonymous/8d1cb71e69d52ac69f5d#file-gistfile1-sql-L59-L60

The following should do it, assuming that topic_id is actually in the phpbb_posts_text table.

INSERT INTO
	bb_posts(post_title,post_excerpt,post_name,post_content,post_type,post_parent)
	SELECT post_subject, post_id, post_subject, REPLACE (post_text, CONCAT (":", bbcode_uid), ""), 'reply', topic_id FROM phpbb_posts_text;

[Robkk]

I’m not really sure you have to worry about the post meta table?? Nevermind it is most likely important for post IDs and such.

https://codex.wordpress.org/Database_Description#Table:_wp_postmeta

And as for sql code to check DB for consistency , I do not know what to tell ya there either.

[mmice]

Maybe, there’s some SQL code to check my DB for consistency and to fix some relationship problems if they’re present?
I guess, for such a big number of replies it could be faster, than any php tool, and also more clear, as i’m already working through DB manually.

[Robkk]

@mmice

bbPress v2 does not have a bb_posts database table , that is in bbPress v1 standalone. Which is what @netweb is referring that you are trying to import into the old v1 version even though your suppose to import to the latest version.

All of bbPress data is stored inside of the WordPress database tables.

In this guide I explain it.

Stored Database Data

[Robkk]

Go through some common troubleshooting steps.

Troubleshooting

[Robkk]

Its custom code to this site.

There might be some tutorial, I think someone linked to it before on here but I can’t remember where ti was.

This plugin has something close , but it has no styling.

https://wordpress.org/plugins/bbpress-info-widgets/

[Robkk]

You might need to create a new user role for users to default as and set their capabilities to create replies but not create topics.

Custom Capabilities

[Stephen Edgar]

So I edited the post and copied the SQL code to a gist on GitHub:

https://gist.github.com/anonymous/8d1cb71e69d52ac69f5d

First, it looks like you are importing the phpBB into bbPress 1.x, bbPress 1.x is not supported anymore.

Per @robkk post immediately above you should checkout that link to our docs on the codex on importing to bbPress 2.x, and in general look toward using the bbPress 2.x plugin for WordPress https://wordpress.org/plugins/bbpress/

I’d suggest taking a look at our phPBB v3.x importer and making any change to match the phpBB v1.x database schema changes you would need:
https://bbpress.trac.wordpress.org/browser/branches/2.5/includes/admin/converters/phpBB.php

[stiffmeister12]

I am having trouble getting my userpro avitars or profile pictures to be displayed on the bbpress home page and topics page where its says “freshness” or “latest post”. The profile pictures do show up when you go into a topic and reply but not on the home page. I want the little picture next to posters name under “freshness” or “latest post”. What code would i have to change and where can i find it? Im using a custom theme by the way.

[Fryvisuals]

You can either change WP_DEBUG to false inside wp-config.php

OR if you need debugging for development go to /plugins/bbpress/includes/core/sub-actions.php

function bbp_setup_current_user() {
	if ( ! did_action( 'after_setup_theme' ) ) {
		// comment out line below
		// _doing_it_wrong( __FUNCTION__, __( 'The current user is being initialized without using $wp->init().', 'bbpress' ), '2.3' );
	}

	do_action( 'bbp_setup_current_user' );
}