MyBB 1.8 to bbpress
-
Hi,
I’ve tried to use the forum converter and it does import the board, but it isn’t importing users. Is there something special I need to to to get the user account migrated over?It’s giving me this error
WordPress database error: [Unknown column 'users.msn' in 'field list']Thanks for the help.
Viewing 7 replies - 1 through 7 (of 7 total)
-
Here is the fix I worked out to get the importer to work properly.
The problem I was having was the user accounts were not being imported due to some outdated usermeta fields in the database. I simply removed the sql code from the current importer script, re-ran, and it worked correctly.
I wanted to share the code of that mybb import script. The file name is Mybb.php.
<?php /** * Implementation of MyBB Forum converter. * * @since bbPress (r5140) * @link Codex Docs https://codex.bbpress.org/import-forums/mybb */ class MyBB extends BBP_Converter_Base { /** * Main Constructor * * @uses MyBB::setup_globals() */ function __construct() { parent::__construct(); $this->setup_globals(); } /** * Sets up the field mappings */ public function setup_globals() { /** Forum Section *****************************************************/ // Forum id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'fid', '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', 'from_fieldname' => 'pid', 'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_parent_id' ); // Forum topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'threads', 'to_type' => 'forum', 'to_fieldname' => '_bbp_topic_count' ); // Forum reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'posts', 'to_type' => 'forum', 'to_fieldname' => '_bbp_reply_count' ); // Forum title. $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'name', 'to_type' => 'forum', 'to_fieldname' => 'post_title' ); // Forum slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'name', 'to_type' => 'forum', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Forum description. $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'description', 'to_type' => 'forum', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_null' ); // Forum display order (Starts from 1) $this->field_map[] = array( 'from_tablename' => 'forums', 'from_fieldname' => 'disporder', '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') ); /** Topic Section *****************************************************/ // Topic id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'tid', 'to_type' => 'topic', 'to_fieldname' => '_bbp_topic_id' ); // Topic reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'replies', 'to_type' => 'topic', 'to_fieldname' => '_bbp_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic total reply count (Includes unpublished replies, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'replies', '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' => 'threads', 'from_fieldname' => 'fid', 'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Topic author. $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'uid', 'to_type' => 'topic', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Topic Author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'ipaddress', 'join_tablename' => 'threads', 'join_type' => 'INNER', 'join_expression' => 'USING (tid) WHERE replyto = 0', 'to_type' => 'topic', 'to_fieldname' => '_bbp_author_ip' ); // Topic content. // Note: We join the 'posts' table because 'threads' table does not have content. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'message', 'join_tablename' => 'threads', 'join_type' => 'INNER', 'join_expression' => 'USING (tid) WHERE replyto = 0', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Topic title. $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'subject', 'to_type' => 'topic', 'to_fieldname' => 'post_title' ); // Topic slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'subject', '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' => 'threads', 'from_fieldname' => 'fid', 'to_type' => 'topic', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_forumid' ); // Sticky status (Stored in postmeta)) $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'sticky', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_sticky_status', 'callback_method' => 'callback_sticky_status' ); // Topic dates. $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'dateline', 'to_type' => 'topic', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'dateline', 'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'lastpost', 'to_type' => 'topic', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'lastpost', 'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'lastpost', 'to_type' => 'topic', 'to_fieldname' => '_bbp_last_active_time', 'callback_method' => 'callback_datetime' ); // Topic status (Open or Closed, MyBB v1.6.10 open = null & closed = 1) $this->field_map[] = array( 'from_tablename' => 'threads', 'from_fieldname' => 'closed', 'to_type' => 'topic', 'to_fieldname' => 'post_status', 'callback_method' => 'callback_topic_status' ); /** Tags Section ******************************************************/ /** * MyBB v1.6.10 Forums do not support topic tags out of the box */ /** Reply Section *****************************************************/ // Reply id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'pid', 'from_expression' => 'WHERE replyto != 0', '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' => 'posts', 'from_fieldname' => 'fid', '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' => 'posts', 'from_fieldname' => 'tid', 'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id', 'callback_method' => 'callback_topicid' ); // Reply author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'ipaddress', 'to_type' => 'reply', 'to_fieldname' => '_bbp_author_ip' ); // Reply author. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'uid', 'to_type' => 'reply', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Reply title. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'subject', 'to_type' => 'reply', 'to_fieldname' => 'post_title' ); // Reply slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'subject', 'to_type' => 'reply', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Reply content. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'message', 'to_type' => 'reply', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Reply parent topic id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'tid', 'to_type' => 'reply', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_topicid' ); // Reply dates. $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'dateline', 'to_type' => 'reply', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'dateline', 'to_type' => 'reply', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'edittime', 'to_type' => 'reply', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'posts', 'from_fieldname' => 'edittime', 'to_type' => 'reply', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); /** User Section ******************************************************/ // Store old User id (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'uid', 'to_type' => 'user', 'to_fieldname' => '_bbp_user_id' ); // Store old User password (Stored in usermeta serialized with salt) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'password', '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', 'from_fieldname' => 'salt', 'to_type' => 'user', 'to_fieldname' => '' ); // User password verify class (Stored in usermeta for verifying password) $this->field_map[] = array( 'to_type' => 'users', 'to_fieldname' => '_bbp_class', 'default' => 'MyBB' ); // User name. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'username', 'to_type' => 'user', 'to_fieldname' => 'user_login' ); // User nice name. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'username', 'to_type' => 'user', 'to_fieldname' => 'user_nicename' ); // User email. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'email', 'to_type' => 'user', 'to_fieldname' => 'user_email' ); // User homepage. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'website', 'to_type' => 'user', 'to_fieldname' => 'user_url' ); // User registered. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'regdate', 'to_type' => 'user', 'to_fieldname' => 'user_registered', 'callback_method' => 'callback_datetime' ); // User display name. $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'usertitle', 'to_type' => 'user', 'to_fieldname' => 'display_name' ); // Store Signature (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'users', 'from_fieldname' => 'signature', 'to_type' => 'user', 'to_fieldname' => '_bbp_mybb_user_sig', 'callback_method' => 'callback_html' ); } /** * 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'] ) ); } /** * Translate the post status from MyBB v1.6.10 numeric's to WordPress's strings. * * @param int $status MyBB v1.6.10 numeric topic status * @return string WordPress safe */ public function callback_topic_status( $status = 0 ) { switch ( $status ) { case 1 : $status = 'closed'; break; case 0 : default : $status = 'publish'; break; } return $status; } /** * Translate the topic sticky status type from MyBB v1.6.10 numeric's to WordPress's strings. * * @param int $status MyBB v1.6.10 numeric forum type * @return string WordPress safe */ public function callback_sticky_status( $status = 0 ) { switch ( $status ) { case 1 : $status = 'sticky'; // MyBB Sticky 'topic_sticky = 1' break; case 0 : default : $status = 'normal'; // MyBB Normal Topic 'topic_sticky = 0' break; } return $status; } /** * Verify the topic/reply count. * * @param int $count MyBB v1.6.10 topic/reply counts * @return string WordPress safe */ public function callback_topic_reply_count( $count = 1 ) { $count = absint( (int) $count - 1 ); return $count; } }Hope this helps someone else who is switching over from MyBB to WordPress.
Thanks for sharing. I am going to bookmark this right now if any other users want to import from mybb and also I am going to see notify Stephen/create a ticket for the fix.
Hi @robkk,
Not a problem. It didn’t seem to convert the passwords; however. Hopefully there will be an update that will convert the passwords in the future.
Importing with the newest bbpress importer doesn’t work. The users from myBB don’t get imported. Using your MyBB.php class also didn’t help. Where can i find the bugtracker for the importer?
Hi,
What is ‘newest bbPress’ for you ? 2.5.8 or the 2.6-alpha version ?
Pascal.This worked fine for me, changed Mybb php file as he suggested and all my users are back on bbpress
It did help me, thanks.
Viewing 7 replies - 1 through 7 (of 7 total)
- You must be logged in to reply to this topic.