bbPress.org

So I’m converting a forum that was originally written in Coldfusion. I have imported the data into MySQL and thought I had the forum converting correctly (all the threads were imported). However it seems like replies were added as topics and not joined with the topic they were associated with. I’ve banged my head against this problem and now have to ask for help from people who know much more than I do. In exchange I will buy you a coffee or dinner 🙂

Here’s a screenshot of the database I’m importing from

and the result

Here is my importing script

<?php

/**
 * Implementation of ECO Forums converter.
 *
 * @since bbPress (r4689)
 * @link Codex Docs https://codex.bbpress.org/import-forums/custom-import
 */
class VSI extends BBP_Converter_Base {

	/**
	 * Main Constructor
	 *
	 * @uses Example_Converter::setup_globals()
	 */
	function __construct() {
		parent::__construct();
		$this->setup_globals();
	}

	/**
	 * Sets up the field mappings
	 */
	public function setup_globals() {

		/** Forum Section *****************************************************/

		// Setup table joins for the forum section at the base of this section

		// Forum id (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_FORUMS',
			'from_fieldname'  => 'forumid',
			'to_type'         => 'forum',
			'to_fieldname'    => '_bbp_forum_id'
		);

		// Forum parent id (If no parent, then 0. Stored in postmeta)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'forums_table',
		//	'from_fieldname'  => 'the_parent_id',
		//	'to_type'         => 'forum',
		//	'to_fieldname'    => '_bbp_forum_parent_id'
		//);

		// Forum topic count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename' => 'ECOFORUMS_FORUMS',
			'from_fieldname' => 'numberoftopics',
			'to_type'        => 'forum',
			'to_fieldname'   => '_bbp_topic_count'
		);

		// Forum reply count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename' => 'ECOFORUMS_FORUMS',
			'from_fieldname' => 'numberofreplies',
			'to_type'        => 'forum',
			'to_fieldname'   => '_bbp_reply_count'
		);

		// Forum total topic count (Stored in postmeta)
		//$this->field_map[] = array(
		//	'from_tablename' => 'forums_table',
		//	'from_fieldname' => 'the_total_topic_count',
		//	'to_type'        => 'forum',
		//	'to_fieldname'   => '_bbp_total_topic_count'
		//);

		// Forum total reply count (Stored in postmeta)
		//$this->field_map[] = array(
		//	'from_tablename' => 'forums_table',
		//	'from_fieldname' => 'the_total_reply_count',
		//	'to_type'        => 'forum',
		//	'to_fieldname'   => '_bbp_total_reply_count'
		//);

		// Forum title.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_FORUMS',
			'from_fieldname'  => 'forumtitle',
			'to_type'         => 'forum',
			'to_fieldname'    => 'post_title'
		);

		// Forum slug (Clean name to avoid confilcts)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'forums_table',
		//	'from_fieldname'  => 'the_forum_slug',
		//	'to_type'         => 'forum',
		//	'to_fieldname'    => 'post_name',
		//	'callback_method' => 'callback_slug'
		//);

		// Forum description.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_FORUMS',
			'from_fieldname'  => 'forumdescription',
			'to_type'         => 'forum',
			'to_fieldname'    => 'post_content',
			'callback_method' => 'callback_null'
		);

		// Forum display order (Starts from 1)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_FORUMS',
			'from_fieldname'  => 'forumorder',
			'to_type'         => 'forum',
			'to_fieldname'    => 'menu_order'
		);

		// Forum dates.
		$this->field_map[] = array(
			'to_type'         => 'forum',
			'to_fieldname'    => 'post_date',
			'default' => date('Y-m-d H:i:s')
		);
		$this->field_map[] = array(
			'to_type'         => 'forum',
			'to_fieldname'    => 'post_date_gmt',
			'default' => date('Y-m-d H:i:s')
		);
		$this->field_map[] = array(
			'to_type'         => 'forum',
			'to_fieldname'    => 'post_modified',
			'default' => date('Y-m-d H:i:s')
		);
		$this->field_map[] = array(
			'to_type'         => 'forum',
			'to_fieldname'    => 'post_modified_gmt',
			'default' => date('Y-m-d H:i:s')
		);

		// Setup the table joins for the forum section
		//$this->field_map[] = array(
		//	'from_tablename'  => 'groups_table',
		//	'from_fieldname'  => 'forum_id',
		//	'join_tablename'  => 'forums_table',
		//	'join_type'       => 'INNER',
		//	'join_expression' => 'USING groups_table.forum_id = forums_table.forum_id',
		//	'from_expression' => 'WHERE forums_table.forum_id != 1',
		//	'to_type'         => 'forum'
		//);

		/** Topic Section *****************************************************/

		// Setup table joins for the topic section at the base of this section

		// Topic id (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'messageid',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_topic_id'
		);

		// Topic reply count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'replycount',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_reply_count',
			'callback_method' => 'callback_topic_reply_count'
		);

		// Topic total reply count (Stored in postmeta)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'topics_table',
		//	'from_fieldname'  => 'the_total_topic_reply_count',
		//	'to_type'         => 'topic',
		//	'to_fieldname'    => '_bbp_total_reply_count',
		//	'callback_method' => 'callback_topic_reply_count'
		//);

		// Topic parent forum id (If no parent, then 0. Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'forumid',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_forum_id',
			'callback_method' => 'callback_forumid'
		);

		// Topic author.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'memberid',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_author',
			'callback_method' => 'callback_userid'
		);

		// Topic author ip (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'ipaddress',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_author_ip'
		);

		// Topic content.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'forummessage',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_content',
			'callback_method' => 'callback_html'
		);

		// Topic title.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'forumsubject',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_title'
		);

		// Topic slug (Clean name to avoid conflicts)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'topics_table',
		//	'from_fieldname'  => 'the_topic_slug',
		//	'to_type'         => 'topic',
		//	'to_fieldname'    => 'post_name',
		//	'callback_method' => 'callback_slug'
		//);

		// Topic parent forum id (If no parent, then 0)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'forumid',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_parent',
			'callback_method' => 'callback_forumid'
		);

		// Sticky status (Stored in postmeta))
		//$this->field_map[] = array(
		//	'from_tablename'  => 'topics_table',
		//	'from_fieldname'  => 'the_topic_sticky_status',
		//	'to_type'         => 'topic',
		//	'to_fieldname'    => '_bbp_old_sticky_status',
		//	'callback_method' => 'callback_sticky_status'
		//);

		// Topic dates.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'datecreated',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_date',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'datecreated',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_date_gmt',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'dateupdate',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_modified',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'dateupdate',
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_modified_gmt',
			'callback_method' => 'callback_datetime'
		);
		//$this->field_map[] = array(
		//	'from_tablename'  => 'topics_table',
		//	'from_fieldname'  => 'the_topic_modified_date',
		//	'to_type'         => 'topic',
		//	'to_fieldname'    => '_bbp_last_active_time',
		//	'callback_method' => 'callback_datetime'
		//);

		// Setup any table joins needed for the topic section
		//$this->field_map[] = array(
		//	'from_tablename'  => 'replies_table',
		//	'from_fieldname'  => 'the_topic_id',
		//	'join_tablename'  => 'topics_table',
		//	'join_type'       => 'INNER',
		//	'join_expression' => 'USING replies_table.the_topic_id = topics_table.the_topic_id',
		//	'from_expression' => 'WHERE forums_table.the_topic_id = 0',
		//	'to_type'         => 'topic'
		//);

		
		/** Reply Section *****************************************************/

		// Setup table joins for the reply section at the base of this section

		// Reply id (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'threadid',
			'to_type'         => 'reply',
			'to_fieldname'    => '_bbp_post_id'
		);

		// Reply parent forum id (If no parent, then 0. Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'forumid',
			'to_type'         => 'reply',
			'to_fieldname'    => '_bbp_forum_id',
			'callback_method' => 'callback_topicid_to_forumid'
		);

		// Reply parent topic id (If no parent, then 0. Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'replyto',
			'to_type'         => 'reply',
			'to_fieldname'    => '_bbp_topic_id',
			'callback_method' => 'callback_topicid'
		);

		// Reply author ip (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'ipaddress',
			'to_type'         => 'reply',
			'to_fieldname'    => '_bbp_author_ip'
		);

		// Reply author.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'memberid',
			'to_type'         => 'reply',
			'to_fieldname'    => 'post_author',
			'callback_method' => 'callback_userid'
		);

		// Reply title.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'forumsubject',
			'to_type'         => 'reply',
			'to_fieldname'    => 'post_title'
		);

		// Reply slug (Clean name to avoid conflicts)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'replies_table',
		//	'from_fieldname'  => 'the_reply_slug',
		//	'to_type'         => 'reply',
		//	'to_fieldname'    => 'post_name',
		//	'callback_method' => 'callback_slug'
		//);

		// Reply content.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'forummessage',
			'to_type'         => 'reply',
			'to_fieldname'    => 'post_content',
			'callback_method' => 'callback_html'
		);

		// Reply order.
		//$this->field_map[] = array(
		//	'from_tablename'  => 'replies_table',
		//	'from_fieldname'  => 'the_reply_order',
		//	'to_type'         => 'reply',
		//	'to_fieldname'    => 'menu_order'
		//);

		// Reply parent topic id (If no parent, then 0)
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'replyto',
			'to_type'         => 'reply',
			'to_fieldname'    => 'post_parent',
			'callback_method' => 'callback_topicid'
		);

		// Reply dates.
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'datecreated',
			'to_type'         => 'reply',
			'to_fieldname'    => 'post_date',
			'callback_method' => 'callback_datetime'
		);
		//$this->field_map[] = array(
		//	'from_tablename'  => 'replies_table',
		//	'from_fieldname'  => 'datecreated',
		//	'to_type'         => 'reply',
		//	'to_fieldname'    => 'post_date_gmt',
		//	'callback_method' => 'callback_datetime'
		//);
		$this->field_map[] = array(
			'from_tablename'  => 'ECOFORUMS_MESSAGES',
			'from_fieldname'  => 'dateupdate',
			'to_type'         => 'reply',
			'to_fieldname'    => 'post_modified',
			'callback_method' => 'callback_datetime'
		);
		//$this->field_map[] = array(
		//	'from_tablename'  => 'replies_table',
		//	'from_fieldname'  => 'dateupdate',
		//	'to_type'         => 'reply',
		//	'to_fieldname'    => 'post_modified_gmt',
		//	'callback_method' => 'callback_datetime'
		//);

		// Setup any table joins needed for the reply section
		//$this->field_map[] = array(
		//	'from_tablename'  => 'topics_table',
		//	'from_fieldname'  => 'the_topic_id',
		//	'join_tablename'  => 'replies_table',
		//	'join_type'       => 'INNER',
		//	'join_expression' => 'USING topics_table.the_topic_id = replies_table.the_topic_id',
		//	'from_expression' => 'WHERE topics_table.first_post != 0',
		//	'to_type'         => 'reply'
		//);

		/** User Section ******************************************************/

		// Setup table joins for the user section at the base of this section

		// Store old User id (Stored in usermeta)
		$this->field_map[] = array(
			'from_tablename'  => 'ECO_MEMBERS',
			'from_fieldname'  => 'member_id',
			'to_type'         => 'user',
			'to_fieldname'    => '_bbp_user_id'
		);

		// Store old User password (Stored in usermeta serialized with salt)
		$this->field_map[] = array(
			'from_tablename'  => 'ECO_MEMBERS',
			'from_fieldname'  => 'userpassword',
			'to_type'         => 'user',
			'to_fieldname'    => '_bbp_password',
			'callback_method' => 'callback_savepass'
		);

		// Store old User Salt (This is only used for the SELECT row info for the above password save)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'users_table',
		//	'from_fieldname'  => 'the_users_password_salt',
		//	'to_type'         => 'user',
		//	'to_fieldname'    => ''
		//);

		// User password verify class (Stored in usermeta for verifying password)
		//$this->field_map[] = array(
		//	'to_type'         => 'user',
		//	'to_fieldname'    => '_bbp_class',
		//	'default' => 'Example'
		//);

		// User name.
		$this->field_map[] = array(
			'from_tablename'  => 'ECO_MEMBERS',
			'from_fieldname'  => 'login_id',
			'to_type'         => 'user',
			'to_fieldname'    => 'user_login'
		);

		// User nice name.
		$this->field_map[] = array(
			'from_tablename' => 'ECO_MEMBERS',
			'from_fieldname' => 'login_id',
			'to_type'        => 'user',
			'to_fieldname'   => 'user_nicename'
		);

		// User email.
		$this->field_map[] = array(
			'from_tablename'  => 'ECO_MEMBERS',
			'from_fieldname'  => 'emailaddress',
			'to_type'         => 'user',
			'to_fieldname'    => 'user_email'
		);

		// User homepage.
		//$this->field_map[] = array(
		//	'from_tablename'  => 'users_table',
		//	'from_fieldname'  => 'the_users_homepage_url',
		//	'to_type'         => 'user',
		//	'to_fieldname'    => 'user_url'
		//);

		// User registered.
		$this->field_map[] = array(
			'from_tablename'  => 'ECO_MEMBERS',
			'from_fieldname'  => 'accountcreated',
			'to_type'         => 'user',
			'to_fieldname'    => 'user_registered',
			'callback_method' => 'callback_datetime'
		);

		// User status.
		//$this->field_map[] = array(
		//	'from_tablename' => 'users_table',
		//	'from_fieldname' => 'the_users_status',
		//	'to_type'        => 'user',
		//	'to_fieldname'   => 'user_status'
		//);

		// User display name.
		$this->field_map[] = array(
			'from_tablename' => 'ECO_MEMBERS',
			'from_fieldname' => 'login_id',
			'to_type'        => 'user',
			'to_fieldname'   => 'display_name'
		);

		// User AIM (Stored in usermeta)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'users_table',
		//	'from_fieldname'  => 'the_users_aim',
		//	'to_type'         => 'user',
		//	'to_fieldname'    => 'aim'
		//);

		// User Yahoo (Stored in usermeta)
		//$this->field_map[] = array(
		//	'from_tablename'  => 'users_table',
		//	'from_fieldname'  => 'the_users_yahoo',
		//	'to_type'         => 'user',
		//	'to_fieldname'    => 'yim'
		//);

		// User Jabber (Stored in usermeta)
		//$this->field_map[] = array(
		//	'from_tablename' => 'users_table',
		//	'from_fieldname' => 'the_users_jabber',
		//	'to_type'        => 'user',
		//	'to_fieldname'   => 'jabber'
		//);

		// Setup any table joins needed for the user section
		//$this->field_map[] = array(
		//	'from_tablename'  => 'users_profile_table',
		//	'from_fieldname'  => 'the_users_id',
		//	'join_tablename'  => 'users_table',
		//	'join_type'       => 'INNER',
		//	'join_expression' => 'USING users_profile_table.the_user_id = users_table.the_user_id',
		//	'from_expression' => 'WHERE users_table.the_user_id != -1',
		//	'to_type'         => 'user'
		//);
	}

	/**
	 * This method allows us to indicates what is or is not converted for each
	 * converter.
	 */
	public function info() {
		return '';
	}

	/**
	 * This method is to save the salt and password together.  That
	 * way when we authenticate it we can get it out of the database
	 * as one value. Array values are auto sanitized by WordPress.
	 */
	public function callback_savepass( $field, $row ) {
		$pass_array = array( 'hash' => $field, 'salt' => $row['salt'] );
		return $pass_array;
	}

	/**
	 * This method is to take the pass out of the database and compare
	 * to a pass the user has typed in.
	 */
	public function authenticate_pass( $password, $serialized_pass ) {
		$pass_array = unserialize( $serialized_pass );
		return ( $pass_array['hash'] == md5( md5( $password ). $pass_array['salt'] ) );
	}
}

Hi All,
I am setting up a site to help me learn, so all this is very new to me so apologies for the silly questions if it seems straight forward to others,
My Site is: martialartsavenue.com
I am using AVADA themed WordPress, vers 5.9.1
I have several plugins installed, including BBpress Version 2.5.14 and BuddyPress Version 4.3.0.

Steps to Troubleshoot:
-Spent hours on Google looking for other occurances and found several reports from years ago, and code suggestions, however i do not know how to code and scared it will cause more harm,
-I tried disabling BuddyPress plugins but still no difference.
-Tried creating a noreply@martialartsavenue.com email address in case anything was being sent to that, and confirmed nothing recieved.
-I checked with my host- siteground that they couldn’t see anything being blocked on their Mail systems, nothing appearing to be the cause on their side.
-Tried finding settings where i can add/modify email addresses or Enable/Disable who gets what and can not find.

So, I would like to know, is there any fixes for this, or are others getting it as well
-Any other suggestions I could try to fix it with?
-Also, is the Site Admin meant to also get a copy of an email to all new Topics, or just the Creators?
thanks,

I need to change the default text like “Create New Topic” to something more engaging like “Ask”. Does anyone know of any plugin that can do this?

Is there anything available that adds a simple “like” to bbPress, without a lot of additional functionality?

I found a lot of older posts about this, and a number of plugins. But with the exception of “likeBTN” all of the plugins appear not to have been maintained for a long time.

Hi,

After activating bbpress, first time use and install, i get these errors in the admin/backend area:

Notice: Undefined offset: 0 in ***/wp-content/plugins/bbpress/includes/topics/capabilities.php on line 80

Notice: Undefined offset: 0 in ***/wp-content/plugins/bbpress/includes/replies/capabilities.php on line 62

Warning: Cannot modify header information – headers already sent by (output started at ***/wp-content/plugins/bbpress/includes/topics/capabilities.php:80) in ***/wp-admin/includes/misc.php on line 1196

I have tried to deactivate all plugins exept bbpress but still get this error.

I tried to create a forum but got a bunch og other errors, same kind and the admin area is not vissible, had to go back a step and deactivate bbpress to get the admin area back.

Site is not live yet, under dev.

Ideas/feedback on what might cause this would be great 🙂

When users share topics to Twitter or Facebook, the featured image or image pulled for the post is the avatar of the OP. After trying several plugins to get it to use a default featured image (yoast seo, twitter cards meta, complete open graph, wpsso core, are a few examples), none of them helped shared topics to display a default featured image on social media posts.

What am I doing wrong?

Hi,

Just wondering if anyone knew of a way to add a link to a menu directly to a logged in users subscriptions and favourites?

Or a plugin with this functionality.

Many thanks in advance,
Greg

Hello,

I have a legacy version of BBPress (0.9.0.2). I was going to migrate to the WordPress version, but that seems difficult plus mine isn’t a WordPress website.

I’d like to ask for your advice: is it safe, security wise to keep this old version of BBPress? What could happen? I have activated several plugins, including the Human Test to keep a tight control over new posts.

I’m also looking into deactivating new registrations/topics and keeping it online as an archive.

Security is my main concern.

Thank you.

I have a large bbPress forum where the wp_postsmeta table is 2 GB! Surprisingly, I’ve not had much trouble hosting that anywhere until I tried Flywheel.

When bbPress is active, trying to log in through /wp-login.php gives me a 503 error and won’t let me into the dashboard. But if I remove bbPress from the plugins folder, I can log in successfully. This is 100% repeatable.

The Flywheel people can log in with their own admin account, but they aren’t a forum “keymaster.”

This site used to be WordPress Multisite but is now its own installation. Server is PHP 7.2.

But this exact same site runs fine when hosted on Liquid Web, or my own server via Centminmod.

Can you give any guidance? Unfortunately, the logs aren’t helpful.

Hi! I’ve been reading a lot of threads like this but I can’t find the solution. When a user registers on my webpage I receive the email “New User Registration” but the user does not receive the email. My website is www.motoadicted.top and my email admin@motoadicted.top, so I think the domain is not the problem. When a user tries to register I receive also this message:

“Mail failure – rejected by local scanning code
A message that you sent was rejected by the local scanning code that
checks incoming messages on this system. The following error was given:

This message was classified as SPAM and may not be delivered”

Thanks for reading.