Announcement

Collapse
No announcement yet.

Problem Converting IPB 1.3 to Vbulletin

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem Converting IPB 1.3 to Vbulletin

    Hey all

    Wonder if someoen can help me im having problems converting Invision 1.3 >>> Vbulletin

    This is what it is

    Invision power based details:

    DB Name: myusername_forum
    User: myusername_blah

    Vbulletin Details

    DB Name: myusername_vbforum
    user: User: myusername_blah


    My Impex config file is as below:

    [ Target Database ]
    ; The following settings allow ImpEx to connect to the vBulletin 3
    ; database into which you will be importing data.
    targetdatabasetype = mysql
    targetserver = localhost
    targetuser = "myusername_blah"
    targetpassword = "xxxxxxxx"
    targetdatabase = "myusername_vbforum"
    targettableprefix =

    ; mysql OR mssql
    sourcedatabasetype = mysql
    sourceserver = localhost
    sourceuser = "myusername_blah"
    sourcepassword = "xxxxxxxx"
    sourcedatabase = "myusername_vbforum"
    sourcetableprefix =


    Ok then i go and run the Programme
    001Check and update database

    moderator - importmoderatorid OK
    usergroup - importusergroupid OK
    ranks - importrankid OK
    poll - importpollid OK
    forum - importforumid OK
    forum - importcategoryid OK
    user - importuserid OK
    style - importstyleid OK
    thread - importthreadid OK
    post - importthreadid OK
    thread - importforumid OK
    smilie - importsmilieid OK
    pmtext - importpmid OK
    avatar - importavatarid OK
    customavatar - importcustomavatarid OK
    customprofilepic - importcustomprofilepicid OK
    post - importpostid OK
    attachment - importattachmentid OK
    access NOT found or a non standard table.
    adminhelp NOT found or a non standard table.
    administrator NOT found or a non standard table.
    adminlog NOT found or a non standard table.
    adminutil NOT found or a non standard table.
    announcement NOT found or a non standard table.
    attachment NOT found or a non standard table.
    attachmenttype NOT found or a non standard table.
    attachmentviews NOT found or a non standard table.
    avatar NOT found or a non standard table.
    bbcode NOT found or a non standard table.
    calendar NOT found or a non standard table.
    calendarcustomfield NOT found or a non standard table.
    calendarmoderator NOT found or a non standard table.
    calendarpermission NOT found or a non standard table.
    cron NOT found or a non standard table.
    cronlog NOT found or a non standard table.
    customavatar NOT found or a non standard table.
    customprofilepic NOT found or a non standard table.
    datastore NOT found or a non standard table.
    deletionlog NOT found or a non standard table.
    editlog NOT found or a non standard table.
    event NOT found or a non standard table.
    faq found.
    forum NOT found or a non standard table.
    forumpermission NOT found or a non standard table.
    holiday NOT found or a non standard table.
    icon NOT found or a non standard table.
    imagecategory NOT found or a non standard table.
    imagecategorypermission NOT found or a non standard table.
    language NOT found or a non standard table.
    mailqueue NOT found or a non standard table.
    moderation NOT found or a non standard table.
    moderator NOT found or a non standard table.
    moderatorlog NOT found or a non standard table.
    passwordhistory NOT found or a non standard table.
    phrase NOT found or a non standard table.
    phrasetype NOT found or a non standard table.
    pm NOT found or a non standard table.
    pmreceipt NOT found or a non standard table.
    pmtext NOT found or a non standard table.
    poll NOT found or a non standard table.
    pollvote NOT found or a non standard table.
    post NOT found or a non standard table.
    post_parsed NOT found or a non standard table.
    posthash NOT found or a non standard table.
    postindex NOT found or a non standard table.
    profilefield NOT found or a non standard table.
    ranks NOT found or a non standard table.
    regimage NOT found or a non standard table.
    reminder NOT found or a non standard table.
    reputation NOT found or a non standard table.
    reputationlevel NOT found or a non standard table.
    search NOT found or a non standard table.
    session NOT found or a non standard table.
    setting NOT found or a non standard table.
    settinggroup NOT found or a non standard table.
    smilie NOT found or a non standard table.
    stats found.
    stats found.
    strikes NOT found or a non standard table.
    style NOT found or a non standard table.
    subscribeevent NOT found or a non standard table.
    subscribeforum NOT found or a non standard table.
    subscribethread NOT found or a non standard table.
    subscription NOT found or a non standard table.
    subscriptionlog NOT found or a non standard table.
    template NOT found or a non standard table.
    thread NOT found or a non standard table.
    threadrate NOT found or a non standard table.
    threadviews NOT found or a non standard table.
    upgradelog NOT found or a non standard table.
    user NOT found or a non standard table.
    useractivation NOT found or a non standard table.
    userban NOT found or a non standard table.
    userfield NOT found or a non standard table.
    usergroup NOT found or a non standard table.
    usergroupleader NOT found or a non standard table.
    usergrouprequest NOT found or a non standard table.
    usernote NOT found or a non standard table.
    userpromotion NOT found or a non standard table.
    usertextfield NOT found or a non standard table.
    usertitle NOT found or a non standard table.
    vbfields NOT found or a non standard table.
    word NOT found or a non standard table.


    Then i move to Step 2


    Database error in vBulletin:ImpEx Source 3.0.3:
    Invalid SQL: SELECT id, name FROM members ORDER BY id LIMIT 0,25
    mysql error: Table 'myusername_forum.members' doesn't exist
    mysql error number: 1146
    Date: Wednesday 10th of November 2004 10:50:58 AM
    Script: http://www.mysite.com/bupload/impex/index.php
    Referer: http://www.mysite.com.org/vbupload/impex/index.php
    Username: admin
    IP Address: 194.XX.XX.XX


    Anyone know wassup wid that then i can do anything from there on
    MPADC

  • #2
    Do your vBulletin tables have a prefix? If so you need to include this in targettableprefix.

    Comment


    • #3
      IPB tables usually have a prefix of ibf_ so make sure you put this into your source db info. (Don't worry I forgot about it too)
      Kerry-Anne :)

      Twitter Blog

      www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

      Comment


      • #4
        Originally posted by peterska2
        IPB tables usually have a prefix of ibf_ so make sure you put this into your source db info. (Don't worry I forgot about it too)
        Ya i forgot to put the prefixes

        tx it works: )
        MPADC

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X