[MediaSVI]

Well I uploaded the vbulletin file to the converter folder and gave it a shot but the videos do not embed and I get this link:

[video=youtube_share;WJ_p0OsIIcg]http://youtu.be/WJ_p0OsIIcg[/video]

What do you think?

[MediaSVI]

Ok I see this file is the bbpress code for the File importer for vBulletin. Forgive me I am new to this stuff but I am getting it a bit slowly 😉

[Stephen Edgar]

Probably be easiest to grab the full file:
https://gist.github.com/ntwb/513187363f36b56ec77d/download

Unzip it and FTP it up to your site replacing the current vBulletin.php file in /plugins/bbpress/includes/admin/converters/

[Stephen Edgar]

Excellent 🙂

The vBulletin importer already includes some regex conversion expressions and should be actually converting those for you.

The actual code from Line #578 is (vBulletin.php)

// Replace '[video=youtube;$1]$2[/video]' with '$2"

		$vbulletin5_markup = preg_replace( '/\[video\=youtube;(.*?)\](.*?)\[\/video\]/', '$2', $vbulletin5_markup );

What that is doing using regular expressions is converting anything in the format of
From: [video=youtube;$1]$2[/video]'
eg. [video=youtube;yF5sbwb4VTg]http://youtu.be/yF5sbwb4VTg[/video]

To: '$2"
eg. http://youtu.be/yF5sbwb4VTg

(If WordPress settings allow YouTube embeds then we only need to post the YouTube URL to the topic or reply)

In your case you have an extra string '_share' in your custom BBCode…

So with copy and paste magic… We end up with this as anxtra regex string conversion:

 		// Replace '[video=youtube;$1]$2[/video]' with '$2"
 		$vbulletin_markup = preg_replace( '/\[video\=youtube;(.*?)\](.*?)\[\/video\]/', '$2', $vbulletin_markup );
+		
+		// Replace '[video=youtube_share;$1]$2[/video]' with '$2"
+		$vbulletin5_markup = preg_replace( '/\[video\=youtube_share;(.*?)\](.*?)\[\/video\]/', '$2', $vbulletin5_markup );
 

You can look at this gist which is a little clearer to read and also download the file.

https://gist.github.com/ntwb/513187363f36b56ec77d/revisions

You can either add those two lines to your own file or download the gist complete there and it should work for you 🙂

[Stephen Edgar]

You should be able via FTP or your webhost control panel open up your vBulletin ‘config.php’ file, you can find it in the /includes folder eg /public_html/vb/includes/config.php

http://www.vbulletin.com/docs/html/editconfig

Now do the same and look at your WordPress ‘wp-config.php’ file

http://support.godaddy.com/help/article/5111/why-is-wordpress-unable-to-connect-to-my-database-during-install

These should give you all the information you need…

One last thing… I have been presuming your importing from vBullen v4.x, are you using v4.x or v5.x?

[Stephen Edgar]

Hmmm… I haven’t looked at vBulletin in a while and I just opened up my database and I do not have a table prefix at all (thus I’d leave the field blank in my case)

Looking at this screen shot of my vBulletin database in phpMyAdmin you can see I am in the database structure view (the default when you open the database) and you can see the ‘forum’, ‘forumpermission’ tables, if yours are the same as mine then you don’t need a table prefix for the import. If yours includes for example ‘vb_’ so yours are ‘vb_forum’, ‘vb_forompermissions’ etc then your table prefix for the importer would be ‘vb_’

[Stephen Edgar]

Make sure you have the correct fields for ALL of the values:

• Database Name: Name of the database with your old forum data
• Database User: User for your database connection
• Database Password: Password to access the database
• Table Prefix: (If converting from BuddyPress Forums, use “wp_bb_” or your custom prefix)

I am 99% sure that your issue is the last item above, you need to make sure you have the correct database prefix, you can open up phpMyAdmin from your webhost control panel.

If you are unsure of any of these contact your webhost to confirm them.

https://codex.bbpress.org/import-forums/
https://codex.bbpress.org/import-forums/vbulletin

[MediaSVI]

I am trying to import my vBulletin forum and I get an error:

WordPress database error: [Table ‘XXXXXXX.user’ doesn’t exist]

Does anyone know what I need to do?

I XXXed out my user name for security but the user name is right.

[peter-hamilton]

Hello BB’s

I am an beginner when it comes to wordpress/bbpress and have been playing around with it for a little while now.

I am trying to create separate forums on my homepage, seperated by a unique forum/parent/category title like in this image.

http://imageshack.com/scaled/large/853/p8hr.jpg

Does anyone know how/if this is possible.

I am trying (like a lot of you) to make bbpress a bit more like VBulletin and IPBoard, and this is/would be a major layout improvement.

Thanks in advance

P.H.

[peter-hamilton]

This is the single most important update/plugin I am waiting/hoping for.
Would make bbpress more like the VBulletin and IPBoard.

AM still looking to solve this.

[dvclmn]

Thanks for the reply, JJJ!

Really appreciate your time. I successfully uploaded my entire vB database into phpmyadmin on my server (dvclmn.com).

However I input all my details and unfortunately it still gave me ‘no forums to convert…’ etc.

To be honest I’m sure it’s just a matter of having input a small detail wrong; there’s just so many areas to make an error in!

Perhaps I could get clarification on each field, just to eliminate these areas.

Select Platform
Easy, that’s vBulletin.

Database Server
I am now trying to import from a database on the same server as the bbpress installation. Does this mean I use a) localhost b) my dedicated IP address or c) dvclmn.com OR http://www.dvclmn.com OR http://dvclmn.com?

Database Port
My server uses Apache, so it’s likely this is 3306; is there a way to find out for sure?

Database Name
Is it important to include the server username extension here? So username_database_name? Or is just database_name fine? (in this case it is [username]_anotherc_vb).

Database User
I have seen the option between username@localhost OR username@dvclmn.com OR just username. Which is going to work?

Database Password
Got that nailed haha

Table Prefix
I have just been enter vb_, as all the tables in the database look like this: “vb_access” and “vb_action” etc.

Have been keeping the Rows & Delay Time at their defaults, and selecting Convert Users (and sometimes Start Over & Purge for good measure).

I hope this is enough information for you. It is imperative I can get this working ASAP, as I mentioned before I am happy to pay for premium support if need be. Just need this to work.

Thanks,

Dave.

[John James Jacoby]

It’s likely that the database server for your vBulletin installation isn’t configured to accept external requests from the database server you’re using for bbPress. You may want to export your vBulletin database, and import it into your bbPress database, and do the conversion locally to avoid connection issues.

[dvclmn]

Hey guys, thanks for taking the time to look after this.

I know there are a lot of posts dedicated to vBulletin import issues, but after hours of searching I haven’t been able to find a resolution. Hoping you can help!

I have read the known issues page (http://codex.bbpress.org/import-forums/vbulletin/) thoroughly and have made sure every detail is correct:

Selected Platform: vBulletin
Database Server: IP or hostname (in my case another-castle.com)
Database Port Use default 3306 if unsure
Database Name Name of the database with your old forum data
Database User User for your database connection
Database Password Password to access the database
Table Prefix (in my case vb_)

I just get ‘no forums/users/etc to convert’.

No data is imported.

I know that you can’t know if I’m getting a password or username wrong, but I am using the details I use to successfully log in to my server/phpMyadmin etc.

I am in such urgent need of this to work that I am happy to pay for further support – whatever it takes. Please let me know if there’s any more information I can give to help this along.

Thanks so much.

Dave.

[vogelsang]

I am working on getting a drupal forum migrated to bbpress. I am using the bbpress importer tool. The forum I am migrating has about 4000 topics and 40000 replies. The migration works fine for a few topics, but seems to get stuck at random places after about a 1000 records are migrated. This makes me think that it is not a data problem. More likely some sort of timeout.

Have any of you experienced something similar? I am running things locally with the most recent stable versions of WP and bbpress.

Here is my script. It is not well-tested. Any suggestions for improvements are welcome and feel free to use it as part of bbpress in whatever way you feel like.

<?php

/**
 * Implementation of Drupal Forum converter.
 */
class Drupal extends BBP_Converter_Base
{
	function __construct()
	{
		parent::__construct();
		$this->setup_globals();
	}

	public function setup_globals()
	{
		/** Forum Section ******************************************************/

		// Forum id. Stored in postmeta.
		$this->field_map[] = array(
			'from_tablename' => 'taxonomy_term_data', 'from_fieldname' => 'tid', //TODO correct ID??
			'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_id',
		);
		
		// Forum parent id.  If no parent, than 0. Stored in postmeta.
		//$this->field_map[] = array(
		//	'from_tablename' => 'forum', 'from_fieldname' => 'parentid',
		//	'to_type' => 'forum', 'to_fieldname' => '_bbp_parent_id'
		//);
		
		// Forum title.
		$this->field_map[] = array(
			'from_tablename' => 'taxonomy_term_data', 'from_fieldname' => 'name',
			'to_type' => 'forum', 'to_fieldname' => 'post_title'
		);
		
		// Forum slug. Clean name.
		$this->field_map[] = array(
			'from_tablename' => 'taxonomy_term_data', 'from_fieldname' => 'name',
			'to_type' => 'forum', 'to_fieldname' => 'post_name',
			'callback_method' => 'callback_slug'
		);
		
		// Forum description.
		$this->field_map[] = array(
			'from_tablename' => 'taxonomy_term_data', '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' => 'taxonomy_term_data', 'from_fieldname' => 'weight',
			'to_type' => 'forum', 'to_fieldname' => 'menu_order'
		);
		
		// Forum date update.
		$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' => 'forum_index', 'from_fieldname' => 'nid',
			'to_type' => 'topic', 'to_fieldname' => '_bbp_topic_id'
		);
		
		// Forum id. Stored in postmeta.
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 'from_fieldname' => 'tid',
			'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id',
			'callback_method' => 'callback_forumid'
		);
				
		// Topic author.
		$this->field_map[] = array(
			'from_tablename' => 'node', 
			'from_fieldname' =>  'uid',
			'join_tablename'  => 'forum_index',
			'join_type'       => 'INNER',
			'join_expression' => 'ON node.nid = forum_index.nid',
			'to_type' => 'topic', 
			'to_fieldname' => 'post_author',
			'callback_method' => 'callback_userid'
		);	

		// Topic content.
		// Note: We join the posts table because topics do not have content.
		$this->field_map[] = array(
			'from_tablename'  => 'field_data_body',
			'from_fieldname'  => 'body_value',
			'join_tablename'  => 'node',
			'join_type'       => 'INNER',
			'join_expression' => 'ON field_data_body.revision_id = node.vid', 			
			'to_type'         => 'topic',
			'to_fieldname'    => 'post_content',
			'callback_method' => 'callback_html'
		);		
				
		// Topic title.
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 'from_fieldname' => 'title',
			'to_type' => 'topic', 'to_fieldname' => 'post_title'
		);
		
		// Topic slug. Clean name.
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 
			'from_fieldname' => 'title',
			'to_type' => 'topic', 
			'to_fieldname' => 'post_name',
			'callback_method' => 'callback_slug'
		);
		
		// Forum id.  If no parent, than 0.	
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 'from_fieldname' => 'tid',
			'to_type' => 'topic', 'to_fieldname' => 'post_parent',
			'callback_method' => 'callback_forumid'
		);

		// Topic reply count
		// $this->field_map[] = array(
			// 'from_tablename'  => 'forum_index',
			// 'from_fieldname'  => 'comment_count',
			// 'to_type'         => 'topic',
			// 'to_fieldname'    => '_bbp_reply_count'
			// //,
			// //'callback_method' => 'callback_topic_reply_count'
		// );
		
		// Topic date update.
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 'from_fieldname' => 'created',
			'to_type' => 'topic', 'to_fieldname' => 'post_date',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 'from_fieldname' => 'created',
			'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 'from_fieldname' => 'last_comment_timestamp',
			'to_type' => 'topic', 'to_fieldname' => 'post_modified',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename' => 'forum_index', 'from_fieldname' => 'last_comment_timestamp',
			'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt',
			'callback_method' => 'callback_datetime'
		);

		/** Tags Section ******************************************************/
		
		// Topic id.
		// $this->field_map[] = array(
			// 'from_tablename' => 'tagcontent', 'from_fieldname' => 'contentid',
			// 'to_type' => 'tags', 'to_fieldname' => 'objectid',
			// 'callback_method' => 'callback_topicid'
		// );
		
		//Tags text.
		// $this->field_map[] = array(
			// 'from_tablename' => 'tag', 'from_fieldname' => 'tagtext',
			// 'join_tablename' => 'tagcontent', 'join_type' => 'INNER', 'join_expression' => 'USING (tagid)',
			// 'to_type' => 'tags', 'to_fieldname' => 'name'
		// );		

		/** Post Section ******************************************************/

		// Post id. Stores in postmeta.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 'from_fieldname' => 'cid',
			'to_type' => 'reply', 'to_fieldname' => '_bbp_post_id'
		);
		
		// Forum id. Stores in postmeta.
		$this->field_map[] = array(
			'from_tablename' => 'forum', 
			'from_fieldname' => 'tid',
			'join_tablename'  => 'comment',
			'join_type'       => 'INNER',
			'join_expression' => 'ON forum.nid = comment.nid',
			'to_type' => 'reply', 'to_fieldname' => '_bbp_forum_id',
			'callback_method' => 'callback_topicid_to_forumid'
		);
		
		// Topic id. Stores in postmeta.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 'from_fieldname' => 'nid',
			'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id',
			'callback_method' => 'callback_topicid'
		);
		
		// Author ip.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 'from_fieldname' => 'hostname',
			'to_type' => 'reply', 'to_fieldname' => '__bbp_author_ip'
		);	
			
		// Post author.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 'from_fieldname' => 'uid',
			'to_type' => 'reply', 'to_fieldname' => 'post_author',
			'callback_method' => 'callback_userid'
		);
		
		// Topic title.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 'from_fieldname' => 'subject',
			'to_type' => 'reply', 'to_fieldname' => 'post_title'
		);
		
		// Topic slug. Clean name.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 
			'from_fieldname' => 'subject',
			'to_type' => 'reply', 
			'to_fieldname' => 'post_name',
			'callback_method' => 'callback_slug'
		);
		
		// Post content.
		// Note: We join the posts table because topics do not have content.
		$this->field_map[] = array(
			'from_tablename'  => 'field_data_comment_body',
			'from_fieldname'  => 'comment_body_value',
			'join_tablename'  => 'comment',
			// 'join_type'       => 'INNER',
			'join_expression' => 'ON field_data_comment_body.entity_id = comment.cid',
			'to_type'         => 'reply',
			'to_fieldname'    => 'post_content',
			'callback_method' => 'callback_html'
		);	
		
		// Post content.
		// BRUGES IKKE - SE OVENFOR
		// $this->field_map[] = array(
			// 'from_tablename' => 'post', 'from_fieldname' => 'pagetext',
			// 'to_type' => 'reply', 
			// 'to_fieldname' => 'post_content',
			// 'callback_method' => 'callback_html'
		// );
		
		// Topic id.  If no parent, than 0.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 'from_fieldname' => 'nid',
			'to_type' => 'reply', 'to_fieldname' => 'post_parent',
			'callback_method' => 'callback_topicid'
		);

		// Topic date update.
		$this->field_map[] = array(
			'from_tablename' => 'comment', 
			'from_fieldname' => 'created',
			'to_type' => 'reply', 
			'to_fieldname' => 'post_date',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename' => 'comment', 
			'from_fieldname' => 'created',
			'to_type' => 'reply', 
			'to_fieldname' => 'post_date_gmt',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename' => 'comment', 
			'from_fieldname' => 'changed',
			'to_type' => 'reply', 
			'to_fieldname' => 'post_modified',
			'callback_method' => 'callback_datetime'
		);
		$this->field_map[] = array(
			'from_tablename' => 'comment', 
			'from_fieldname' => 'changed',
			'to_type' => 'reply', 
			'to_fieldname' => 'post_modified_gmt',
			'callback_method' => 'callback_datetime'
		);

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

		// Store old User id. Stores in usermeta.
		// $this->field_map[] = array(
			// 'from_tablename' => 'users', 'from_fieldname' => 'uid',
			// 'to_type' => 'user', 'to_fieldname' => '_bbp_user_id'
		// );
		
		// Store old User password. Stores in usermeta serialized with salt.
		// $this->field_map[] = array(
			// 'from_tablename' => 'users', 'from_fieldname' => 'pass',
			// '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
		// todo ???
		//$this->field_map[] = array(
		//	'from_tablename' => 'users', 'from_fieldname' => 'salt',
		//	'to_type' => 'user', 'to_fieldname' => ''
		//);
				
		// // User password verify class. Stores in usermeta for verifying password.
		// $this->field_map[] = array(
			// 'to_type' => 'users', 'to_fieldname' => '_bbp_class',
			// 'default' => 'Vbulletin'
		// );
		
		// // User name.
		// $this->field_map[] = array(
			// 'from_tablename' => 'users', 'from_fieldname' => 'name',
			// 'to_type' => 'user', 'to_fieldname' => 'user_login'
		// );
				
		// // User email.
		// $this->field_map[] = array(
			// 'from_tablename' => 'users', 'from_fieldname' => 'mail',
			// 'to_type' => 'user', 'to_fieldname' => 'user_email'
		// );
		
		// User homepage.
		// $this->field_map[] = array(
			// 'from_tablename' => 'users', 'from_fieldname' => 'homepage',
			// 'to_type' => 'user', 'to_fieldname' => 'user_url'
		// );
		
		// User registered.
		// $this->field_map[] = array(
			// 'from_tablename' => 'users', 'from_fieldname' => 'created',
			// 'to_type' => 'user', 'to_fieldname' => 'user_registered',
			// 'callback_method' => 'callback_datetime'
		// );
		
		// User aim.
		//$this->field_map[] = array(
		//	'from_tablename' => 'users', 'from_fieldname' => 'aim',
		//	'to_type' => 'user', 'to_fieldname' => 'aim'
		//);
		
		// User yahoo.
		//$this->field_map[] = array(
		//	'from_tablename' => 'users', 'from_fieldname' => 'yahoo',
		//	'to_type' => 'user', 'to_fieldname' => 'yim'
		//);	
	}
	
	/**
	 * 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'] ) );
	}

}

[squid1974]

Really nobody? I can’t import my VBulletin… 🙁

[squid1974]

I am hosted on 1&1. If you are too the hostname must probably include the socket.

Besides that, are you sure you have no table prefix? My Vbulletin tables all start with vb_

Fabian

[squid1974]

Ok, I got the idea to look at the conversion php file for VBulletin.

I found out that I need these tables:

• vb_forum
• vb_thread
• vb_post
• vb_tagcontent
• vb_tag
• vb_user

After importing and repairing everything I get just 1 reply and 1 voice in each thread. In the backend I get several replies per thread. Something is going wrong.

Any ideas on this?

Fabian

[squid1974]

Does really nobody know this?

[squid1974]

Hi,

I want to test the import of my Vbulletin forum into BBPress. I have trouble with it because the data is too big and therefore I cannot import my Vbulletin data into a local database.

I would like to know which tables of VBulletin are used by the importer so that I only export those that are needed?

Fabian

[veelee9]

I’m having the exact same issue, but instead of importing the vbulletin database directly from vbulletin server, I have exported the vbulletin database as a sql file and imported it over to a new database that I have created on my server where my WordPress and BBPress installation exist. I have entered the following to each of the import fields:

Platform: vBulletin
Database Server IP or hostname: localhost
Database Port Use: 3306
Database Name: [entered correct db name]
Database User: [entered correct db user]
Database Password: [entered correct db password]
Table Prefix: blank

Once I click the start button, it will show “Starting Conversion” but just hangs there, any idea what I’m doing wrong?

[rajlaksh]

long ago i created forum and groups and created few topics/posts there and now i am starting my forum again and so want all those topics/posts dates changed to present format
simply put i want control over date-of-posting :similar to vbulletin feature

in wordpress posts we can change date/year/time easily. here i am finding no option to do so

help me out

[Abhinab Choudhury]

I am Currently using vbulletin for my Webmaster Forum website. I would like to shift to bbPress. I want to know is there any support available for auto link conversion such as ones available by other forum software?

Regards.
Abhinab Choudhury

[koolthing]

anyone?

[koolthing]

Hi, I’m thinking get rid of vbulletin and looking to switch to bbpress. Is there a converter for this? and if there is a converter, this converter successfully convert everything? I mean, users, topics, posts, passwords, forum permissions.

thanks in advance.

[fuseful]

LOL – This is BBPress support – You think I am expecting a response this year ?

I assume like with all BBPress issues I have I will end up hiring a programmer on Freelancer

I have to say though I love BBPress – Glad I moved to it from vBulletin (sh*t) after years of grief but the main downside is the absolute useless support infrastructure.