[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.

[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 opened up the database and looked and could see the prefix for example last say the prefix id HG_ what would I put in the Table Prefix?

Thanks for your time.

[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_’

[MediaSVI]

I did try it with the prefix blank and it did not work. I also triple checked the other enters and it just does not work…so I am guessing I have something wrong or the import just does not want to work under my circumstances?

[Stephen Edgar]

Try doing an import without importing the users, this will ensure you get past the error ‘WordPress database error: [Table ‘XXXXXXX.user’ doesn’t exist]’ in your original post.

What errors do you see this time?

Also some webhosts require you to use an IP Address for the database server rather than ‘localhost’ and you might want to check that with them.

And of course I/we would love some more error checking and/or notifications to help us debug these errors such as ‘Cannot find database’, ‘Username/Password’ does not match for the database xyz’ etc…

[MediaSVI]

I checked everything again, I tried it with prefix and without and it keeps saying “does not exist” and it does?

I am confident I have put in the right enters, is there something maybe with GoDaddy?

[MediaSVI]

Yes I did try that too but now go, it either says “No xxxxxx” to everything or gives me the error.

[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?

[MediaSVI]

I am using V4.2.1

Ok I got it to work, I had 2 things wrong that I fixed and they where.

In the Id or Hostname I used the server IP address and in prefix I used lower case, I was using caps.

It imported all users, forums, topic, days, times awesome.

Question: my site has a lot of videos and the VB shortcode would put them in like this: [video=youtube_share;yF5sbwb4VTg]http://youtu.be/yF5sbwb4VTg[/video]

Is there anything I can do to make them appear in the posts?

Also what will happen when users log into the forum now?

[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 🙂

[MediaSVI]

Thanks I will take a look at it and give it a try and let you know.

Thanks for all your help.

[MediaSVI]

Question:

Exactly what code am I to use and where do I paste it..IE

Do I paste in a VB file before import or in a WordPress/bbPress after import.

Also there is the child theme stuff to be concerned about. Just know I am in the R&D of all this now before I start converting my site. I do have Blogs/Articles too but not many.

[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/

[MediaSVI]

Ok I can do that and just to be clear this should be done before the import into bbPress?

[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 😉

[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?

[Stephen Edgar]

My bad, a typo, I was working with vBulletin5 and I left the vB5 reference in their…

Updating now and it should work if you download it and FTP it up again etc…

[MediaSVI]

Still no go this is what I get:

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

If I remove

This:[video=youtube_share;prdhQOOayfU]
and
This:[/video]
and only leave
This:http://youtu.be/prdhQOOayfU

It embeds and works great if that’s any help?

[Stephen Edgar]

Hmmm… It should work… http://regexr.com?3621e

Can you find a post with either a [QUOTE] or [MENTION] BBCode to see if these have been converted to <blockquote> which will help work out if any of the BBCodes are being converted to HTML.

[Stephen Edgar]

I just uploaded and tested it and it is working as it should for me (I added a few of your ‘[video=youtube_share…’ links to some vB posts.

[MediaSVI]

Yes all the Qoutes are working and look good.

You are welcome to take a look at my test site.

http://themaraudershockeyclub.com/forums/

The only videos that work are ones I removed the stuff from, i don’t know what its called [video].

[Stephen Edgar]

Hmmm… Yep quotes are converted correctly, are you sure you uploaded the latest vBulletin.php file and uploaded to

http://themaraudershockeyclub.com/wp-content/plugins/bbpress/includes/admin/converters

[MediaSVI]

Ok Steve you were right I uploaded the wrong .php….important to keep things neat when in R&D:-)

All the YouTube videos and Quotas are showing up nicely….Good Job!

Now just to get the SoundCloud embeds to show. We have this for soundcloud after the import.

[SOUNDCLOUD]https://soundcloud.com/bamfofficial/roger-this[/SOUNDCLOUD]

If I remove [SOUNDCLOUD] & [/SOUNDCLOUD] SoundCloud embeds nicely.

Can you update the vb.php to do this?

Thanks for your time.

[Stephen Edgar]

Cool… Done… Just download again via the link up there ^^^.

If there are any others hanging about let me know or any other text, paragraph, images etc BBCodes I will add them all in for bbPress 2.5

[MediaSVI]

Ok Steve uploaded the .php re-imported and an odd thing happens. The SC embed link is right but it just shows the link. Now if I click on “edit” for the post and do nothing and them just press “submit” the post then shows the SC embed as it should with the player.

Also the Sticky Forums are not the right color I guess it would be best to look at what i am taking about http://youcanwinthis.com/forums/forum/about-help-videos/