[lagrou]

Problem I see, is that with this version all of the replies are imported, including second-level ones which have the topic ID as parent instead of their parent ID. Not sure if this is related, but on my test install when there are second-level replies to import it messes bbPress list of replies. Whereas with no second-level replies in WPS forum, it works fine.

To get only first-level replies, I have changed the above into:
"SELECT s.* FROM wp_symposium_topics s INNER JOIN wp_symposium_topics t ON s.topic_parent = t.tid WHERE s.topic_parent != 0 AND s.topic_group = 0 AND t.topic_parent = 0"

Which works fine as dumped in a PHP page. And then into:

// Reply id (Stored in postmeta)
$this->field_map[] = array(
	'from_tablename'  => 'symposium_topics s',
	'from_fieldname'  => 'tid',
	'join_tablename'  => 'symposium_topics t',
	'join_type'       => 'INNER',
	'join_expression' => 'ON s.topic_parent = t.tid',
	'from_expression' => 'WHERE s.topic_parent != 0 AND s.topic_group = 0 AND t.topic_parent = 0',
	'to_type'         => 'reply',
	'to_fieldname'    => '_bbp_post_id'
);

Unfortunately, it seems the converter doesn’t accept this…

EDIT: do not believe I haven’t read your own posts LOL. I just wanted to describe the path I have followed in case it would bring some light on your side…

[iclimb]

nhadsall, this is great..! thumbs up and great work. i’ve tested it a little bit and it seems to work when a new forum i created.

I really don’t want to sound demanding, because i’m really appreciating the work you’re doing!
But one thing i think it is missing, is when a new user is created, he is not subscribed to existing forums. He will only be subscribed to new ones. Do you think it would be possible to make new users subscribed to all forums when created? i realize that it probably means some work, but i think it will make most sense that way.

Best regards, Christian

[Stephen Edgar]

It looks like we won’t get the threaded replies in v1, I had a similar issue with vBulletin 5 and which is not included in bbPress at this stage. Trying to get a single query to handle all of the replies doesn’t look good at the moment for WPS.

You can take a look at the vBulletin5.php importer, rather than just ‘Forums’, ‘Topics’ and ‘Replies’ sections I had to add a 4th, ‘Comments’ this then meant I had to extend the main converter to handle this extra step.

https://bbpress.trac.wordpress.org/attachment/ticket/2440/

I’ll have a think about this over the next couple of days and come up with some options, there is a chance I can add this extra section to bbPress and then included WPS threaded replies, vBulletin5.php in the next version of bbPress. There is just a ton of testing needed to ensure the ~20 other importers continue to work and fix any issues that arise…

[Stephen Edgar]

Reply to Replies, I had a look and they are stored in symposium_topics like other replies, so we should have them with little effort. In case you’d like to give it a try on WPS side, and be able to test their import, they are activated using roles, “Forum comment roles” under “Forum” tab.

I’ve added some ‘replies to replies’ to my test WPS forum before converting it… In bbPress, in the backend they are not displayed in the list of replies, although I do see ‘hidden’ replies in the count that I cannot access to. In the frontend, the forum topic does not show those replies, nor do the counters. However!! When dumping wp_posts table WHERE post_type = ‘reply’, they are there, so they were converted ok, it’s just that they don’t show. I did set bbPress threated replies 2 levels deep before conversion. Any advice…?

Looking at this now, threaded replies are using the same topic_parent field, though they are using this as a pointer to the ‘reply parent’ rather than the topic parent.

This is the reply query: (My test results) Notice the ‘threaded replies’ topic ID, it is not the actual topic ID it is the reply ID they are a reply to.

SELECT CONVERT( symposium_topics.tid
USING  "utf8" ) AS tid, CONVERT( symposium_topics.topic_category
USING  "utf8" ) AS topic_category, CONVERT( symposium_topics.topic_parent
USING  "utf8" ) AS topic_parent, CONVERT( symposium_topics.topic_owner
USING  "utf8" ) AS topic_owner, CONVERT( symposium_topics.topic_post
USING  "utf8" ) AS topic_post, CONVERT( symposium_topics.topic_started
USING  "utf8" ) AS topic_started
FROM wp_symposium_topics AS symposium_topics
WHERE symposium_topics.topic_parent !=0
LIMIT 0 , 100

Working on tweaking the query now….

I’ll be happy to contribute to the bbPress Codex as well, with issues etc.

Appreciated 🙂

Browsing other converters’ Codex, I do see where there will be issues with WP Symposium, [youtube], custom smilies {{cloud}}, etc.

I haven’t looked at this yet, most of it should be easy enough from work on the other importers, just a matter of creating a list of all that is required.

As far as groups forum topics, I would add ‘AND symposium_topics.topic_group = 0 ‘ to the ‘from_expression’ of both the topic ID and Reply ID sections to get rid of those posts. Cleaner until v2.

I’ll add that shortly and do some tests.

[Tom Dyer]

as a side note, it’s probably worth utilising the bbp_get_forum_post_type(), bbp_get_topic_post_type() and bbp_get_reply_post_type() from bbPress instead of hard-coding the ‘forum’, ‘topic’ and ‘reply’ in there. It’s not affecting what I’m doing right now, but you can bet it’s going to upset somebody sometime 😉

– You may already have that in mind but I just figured, since you want people testing it, that it’s worth pointing out.

[fumbling]

I’ve set up a forum, by making a page, and for some reason the bbpress sidebar isn’t showing up. My pages sidebar is coming up. How can I fix this?
http://fumblingfitnesscom.fatcow.com/test/wordpress/ask/

any help would be greatly appreciated! Thanks 🙂

[lagrou]

Something odd about those “replies to replies”. I had assumed they would be there by default, but couldn’t see them…

I’ve added some ‘replies to replies’ to my test WPS forum before converting it… In bbPress, in the backend they are not displayed in the list of replies, although I do see ‘hidden’ replies in the count that I cannot access to. In the frontend, the forum topic does not show those replies, nor do the counters. However!! When dumping wp_posts table WHERE post_type = ‘reply’, they are there, so they were converted ok, it’s just that they don’t show. I did set bbPress threated replies 2 levels deep before conversion. Any advice…?

As far as groups forum topics, I would add ‘AND symposium_topics.topic_group = 0 ‘ to the ‘from_expression’ of both the topic ID and Reply ID sections to get rid of those posts. Cleaner until v2.

[CathieHeart]

Hello,

I’m struggling to get a new subscriber user I created to test functionality and found that they are unable to upload pictures / files. I understand that only users who are able to upload media will be able to add new media but I’ve edited the access rights to allow subscribers to upload their own media.

I’m using:
Wordpress: Version 3.9.1
bbPress: Version 2.5.3
bbPress Enable TinyMCE Visual Tab: Version 1.0.1 –

I’ve setup a fresh install of wordpress and I’m running a minimum of plugins, user switching, bbpress, bbpress genesis and the bbPress Enable TinyMCE Visual Tab plugin. I’m also using a plugin by WP-Types called Access to that I’ve used to make a subscriber able to read, edit, delete and publish their own media files.

How do I get the basic subscriber user to be able to:

• create a topic
• reply to topics
• be able to upload media as a forum participant

I’ve got the settings > forum > set to ‘Automatically give registered visitors the Participant forum role’. What else do I need to do?

Thanks
Cathie.

[lagrou]

Merged your pull request…

Reply to Replies, I had a look and they are stored in symposium_topics like other replies, so we should have them with little effort. In case you’d like to give it a try on WPS side, and be able to test their import, they are activated using roles, “Forum comment roles” under “Forum” tab.

I’ll be happy to contribute to the bbPress Codex as well, with issues etc. Browsing other converters’ Codex, I do see where there will be issues with WP Symposium, [youtube], custom smilies {{cloud}}, etc.

EDIT: oops fixed a copy/paste error in my prose…

[Tom Dyer]

Nope, I’ve not touched the Twenty fourteen theme since I added it. It’s been updated whenever required anyway though (I don’t like the seeing the update icon in the admin, so I tend to always keep things on the latest version whether I’m using it or not).

This is a multisite install of WordPress though – Would that affect the $wpdb->get_col() visibility?

[Robin W]

@netweb – thanks for adding to this thread, and apologies if I was breaking rules – fully appreciate the reasons they are there 🙂

I think the errors in pg_get_author_link are related to testing for settings that may not have been set, I’ll take a look.

@trymedo – As Stephen suggest try it with a core theme and play with the plugins. Come back with your results !

[Stephen Edgar]

I really would suggest switching to the Twenty Fourteen theme, and testing that, it works for me.

If it still doesn’t work for you disable all your plugins except bbPress and ‘Private Groups’, test things, if it works great, start re-enabling each plugin one by one until you find it no longer works.

[Stephen Edgar]

I have a huge affinity for the Roots theme, it is awesome, but it can catch you out, I just gave the latest v1.6 a run, using Twenty Fourteen as the theme everything works as expected as ‘keymaster’, moving a reply from one topic to another works as expected.

The only errors I see are in the function pg_get_author_link (These are not related directly to @trymedo’s the issue though)

Notice Undefined variable: args 1 wp-content/plugins/bbp-private-groups/includes/functions.php:245
Notice Undefined variable: post_id 1 wp-content/plugins/bbp-private-groups/includes/functions.php:246

[kowarler]

I’m working on a test wordpress site for a car club and I’ve tried to add a Forum…

http://thesaabenthusiasts.co.uk/Forum/forum/forum/

Is there anyway of showing the Forum (and it’s topics) on the Forum page, rather than having to click on ‘Forum’ in the Menu, then click on Forum again?

[Tom Dyer]

Thanks @netweb, I appreciate the concern and I think if this was a live site we were discussing then I’d be much more weary of asking for help. As it happens, this site is not currently public facing, and I have plenty of backups of the data. It would be just be beneficial for @robin-w to see what I’m working with (it’s a pretty big site with a lot of forum users and topics, something that’s hard to replicate for a local test).

I solemnly swear that I won’t get ugly, and will always just be appreciative of any help that @robin-w is providing, whether it fixes my problem or makes it worse.

I believe his intentions are in the right place. Just like yours

[Stephen Edgar]

Ok, I’ll take a look at the groups shortly, my computer is being stupid at the moment and isn’t playing nice 🙁

‘Reply to Replies’ / ‘2nd level replies’, we can do this easily, we support ‘threaded replies’, I can’t find how to make one or a setting though :/

Basically ‘whatever’ version procedure they use, I will reference that, kind of not important at our end except to say we tested with ‘x’ version.

[Stephen Edgar]

I considered that the content could at least be imported, then the admin would do whatever he wants to with that content. But maybe the groups ownership and membership will be impossible to mimick at bbPress level solely, so it’s better to avoid importing rather than making public content that was private to begin with…?

– Groups forums (either drop topics, leave them as parentless, or create hidden forums as per the group name)

I don’t think leaving them parentless is the best way to go, maybe creating a hidden forum might be the way to go. Let’s leave this out for now, we can revisit this in the future easily enough and get v1 out and revisit this for v2.

I’m adding a Users section to your own version of the converter module (based on other converters available). If we want to import user-related settings, like forums/topics subscriptions and favorites, is this possible ? WPS uses usermeta, and I would assume bbPress does so…?

– user meta (forum subscriptions, favorites)

Yes, mainly, I haven’t looked at importing subscriptions or favorites yet in any of the importers, will get there one day.

What you have added looks fine via your latest commit here.

WordPress database error: [Table ‘xxx.wp_bp_groups_groupmeta’ doesn’t exist]

You only get this error if you don’t have BuddyPress installed and activated, I need to add some inline docs for this and help docs.

How do you access a parentless topic in bbPress ? Could these be used for WP Symposium groups forum topics ?

You will see them in the topic list in the backend, you won’t see them on the front end unless you make them a sticky or know the url but they will be publicly accessible. Finding them in the backend is not so easy unless you know the title of the topic. Not the best experience, but also was never really planned for, it was just never enforced that a topic must have a forum either.

– Could you clarify what a forum and a category refer to, in bbPress terminology ? Is a category a subforum, which has necessarily a parent forum, while a forum has no parent ? In such a case, there should be a test over symposium_cats.cat_parent in callback_forum_type(), otherwise it can be simply disregarded…

Both a forum and a category can have sub forums or sub categories, forums can have topics, categories cannot have topics.

Thus symposium_cats.cat_parent is already being used with _bbp_forum_parent_id and this is how we get the forums, sub-forums, categories etc all ordered correctly in their correct nested levels.

I think we are good, I’ll grab the latest shortly and the patch to bbPress Trac Ticket #2603 and I’ll take it for a test drive then commit it and it will be part of bbPress v2.6.

[Avasti]

In the main forum i have the configuration for see the latest post. I can change the configuration for show the latest comments?

[Robin W]

Great – glad you’re fixed, and thanks for posting the latest code needed ! 🙂

[lagrou]

Back to topic, just updated the GitHub repo with the following:
– Add User section
– Fix & make use of callback_forum_status, add Forum status (Open or Closed)
– Fix & make use of callback_sticky_status
All this tested OK on my nested test install. I’m leaving the “pre-alpha code” warning, though.

Some more questions raised at this stage:
– How do you access a parentless topic in bbPress ? Could these be used for WP Symposium groups forum topics ?
– Could you clarify what a forum and a category refer to, in bbPress terminology ? Is a category a subforum, which has necessarily a parent forum, while a forum has no parent ? In such a case, there should be a test over symposium_cats.cat_parent in callback_forum_type(), otherwise it can be simply disregarded…

[czentnar]

function custom_bbp_has_replies() {
$args[‘order’] = ‘DESC’; // ‘ASC’ (Ascending, Default), ‘DESC’ (Descending)
return $args;
}
add_filter(‘bbp_before_has_replies_parse_args’, ‘custom_bbp_has_replies’ );

Thank you for the great solution, @netweb!
However, as I changed the query, the post IDs got messed up (this appears when I click on the ID starting with “#” in the top right corner of the post). Also, after submitting a new post, bbPress jumps to the last page in that topic, despite the fact that the order has already been changed and the latest reply is on the first page (this could be a result of the messed ID’s, I think).

[mmscholz]

Here is a link that works on a Topic.

http://scholzmobility.com/forums/topic/testing

[Nathan]

So, after DAYS of working on this I finally have a solution. I have not done a lot of testing, but this has worked so far.

Basically what is happening is that for forums (not replies) the logic is inverted. This means that users are subscribed to a forum unless they unsubscribe (ie. are added to the DB).

Just add this to your theme’s function.php and it should work.

I hope this helps someone, because it has taken a LOT of work!

add_filter( 'bbp_get_user_subscribe_link', 'invert_get_user_subscribe_link', 10, 4 ); //invert forum subscription
add_filter( 'bbp_is_user_subscribed_to_forum', 'invert_is_user_subscribed_to_forum', 10, 4 ); //invert forum subscription
add_filter( 'bbp_get_forum_subscribers', 'invert_get_forum_subscribers' ); //invert forum subscription
add_filter( 'bbp_is_user_subscribed', 'invert_is_user_subscribed', 10, 4 ); //invert forum subscription

function invert_is_user_subscribed($retval, $user_id, $object_id, $subscribed_ids) {
	if (get_post_type( $object_id ) == bbp_get_forum_post_type())
		return !$retval;
	else	
		return $retval;
}

function strContains($needle, $haystack) {
	if (strpos($haystack, $needle) !== false) {
		return true;
	} else {
		return false;
	}
}

function invert_get_user_subscribe_link ($html, $r, $user_id, $topic_id) {
	if (strContains( "bbp_unsubscribe", $html )) {
		$html = str_replace("bbp_unsubscribe", "bbp_subscribe", $html);
	} else {
		$html = str_replace("bbp_subscribe", "bbp_unsubscribe", $html);
	}
	return $html;
}

function invert_get_forum_subscribers( $users ) {
	$args = array('fields' => 'id');
	$all_users = get_users($args);
	$send_to_users    = array_diff($all_users, $users);
	return $send_to_users;
}

function invert_is_user_subscribed_to_forum( $retval, $user_id, $forum_id, $subscribed_ids ) {
	return !$retval;
}

I also include make users “subscribed” to anything they write by default. All they have to do is uncheck the box. The following code is also added to function.php.

add_action('bbp_theme_after_topic_form_subscriptions', 'subscribed_by_default'); //default subscribe
add_action('bbp_theme_after_reply_form_subscription', 'subscribed_by_default'); //default subscribe

function subscribed_by_default() 
	echo '<script type="text/javascript">jQuery("#bbp_topic_subscription").prop("checked","checked");</script>';
}

[jeffacubed]

Thx for taking a closer look Stephen! ( @netweb ) – this is seemingly simple – though not simple in seamless execution in a multi-site setup. I’m fairly sure the best way to handle this auto re-direction to the root when registering from WPMS sub-sites is to create a unique wp-signup.php file for any sub-site where one DOES NOT want the re-direction to the root site on registration. I started to test Chris Wiegman’s (& others) method:

http://chriswiegman.com/2010/02/using-a-custom-wp-signup-page-with-wordpress-mu/

Which would work – though I didn’t got deep enough (yet) to get the re-direction(s) to the root to stop-happening.

My ‘temporary’ sol’n @hamsterdj involves two plugins:

1. Login with Ajax

2. WP-Members

While my ‘temporary’ sol’n 100% works (for now) – I’m going to dig-in & try my hand at the custom wp-signup.php sol’n for each sub-site registration as I’m more in favour of soln’s of this nature that do not 100% rely on plugins!

-Jeff

[andyboyce]

Hi Robin,

Thanks for your help.

I have set up a test user, and tried to edit the profile and get the message ‘You do not have sufficient permissions to access this page’

Andy