Skip to:
Content
Pages
Categories
Search
Top
Bottom

Import Forums error


  • MediaSVI
    Participant

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

Viewing 25 replies - 1 through 25 (of 30 total)
  • 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.

    http://codex.bbpress.org/import-forums/

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


    MediaSVI
    Participant

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

    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
    Participant

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

    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
    Participant

    @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
    Participant

    @mediasvi

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

    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
    Participant

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

    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
    Participant

    @mediasvi

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

    Thanks for all your help.


    MediaSVI
    Participant

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

    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
    Participant

    @mediasvi

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


    MediaSVI
    Participant

    @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
    Participant

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

    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
    Participant

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

    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.

    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
    Participant

    @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].

    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
    Participant

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

    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
    Participant

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

Viewing 25 replies - 1 through 25 (of 30 total)

You must be logged in to reply to this topic.