No announcement yet.

phpBB 2 > vBulletin 4

  • Filter
  • Time
  • Show
Clear All
new posts

  • phpBB 2 > vBulletin 4

    Hey Guys, first off I am entirely new to this import thing...I'm trying my best but I believe I am stuck.

    I downloaded the database from the old website I am importing. phpBB 2...I think.

    Since it was on a different server, I made a new database on the "new website's" server and uploaded the file I had downloaded from phpBB through phpMyAdmin.

    The first problem I had when I tried to import was the table prefix on the old forum, which was nuke_bb.

    After editing the ImpEx config file to reflect this, I tried again.

    Here are the results of the "Check and Update Database"

    Altering tables
    ImpEx will now Alter the tables in the vB  database to include import id numbers. This is needed during the import  process for maintaining references between the tables during an import.  If you have large tables (i.e. lots of posts) this can take some time.  They will also be left after the import if you need to link back to the  original vB userid.  
    moderator - importmoderatorid Completed 
    usergroup - importusergroupid Completed 
    ranks - importrankid Completed 
    poll - importpollid Completed 
    forum - importforumid Completed 
    forum - importcategoryid Completed 
    user - importuserid Completed 
    style - importstyleid Completed 
    thread - importthreadid Completed 
    post - importthreadid Completed 
    thread - importforumid Completed 
    smilie - importsmilieid Completed 
    pmtext - importpmid Completed 
    avatar - importavatarid Completed 
    customavatar - importcustomavatarid Completed 
    customprofilepic - importcustomprofilepicid Completed 
    post - importpostid Completed 
    attachment - importattachmentid Completed 
    pm - importpmid Completed 
    usernote - importusernoteid Completed 
    phrase - importphraseid Completed 
    subscription - importsubscriptionid Completed 
    subscriptionlog - importsubscriptionlogid CompletedTesting  source against : phpBB2 ::2.0.22
    Valid found tables :
    nuke_bbauth_access found.     
    nuke_bbbanlist found.     
    nuke_bbcategories found.     
    nuke_bbconfig found.     
    nuke_bbdisallow found.     
    nuke_bbforum_prune found.     
    nuke_bbforums found.     
    nuke_bbgroups found.     
    nuke_bbposts found.     
    nuke_bbposts_text found.     
    nuke_bbprivmsgs found.     
    nuke_bbprivmsgs_text found.     
    nuke_bbranks found.     
    nuke_bbsearch_results found.     
    nuke_bbsearch_wordlist found.     
    Possibly custom tables or incorrect prefix :
    nuke_bbattachments NOT found.     
    nuke_bbattachments_desc NOT found.     
    nuke_bbconfirm NOT found.     
    nuke_bbsearch_wordmatch NOT found.     
    nuke_bbsessions NOT found.     
    nuke_bbsmilies NOT found.     
    nuke_bbthemes NOT found.     
    nuke_bbthemes_name NOT found.     
    nuke_bbtopics NOT found.     
    nuke_bbtopics_watch NOT found.     
    nuke_bbuser_group NOT found.     
    nuke_bbusers NOT found.     
    nuke_bbvote_desc NOT found.     
    nuke_bbvote_results NOT found.     
    nuke_bbvote_voters NOT found.     
    nuke_bbwords NOT found.
    So my question I the reason for the previous tables not found a prefix issue...or an issue uploading the old databse...or?

    The only thing I got to work as a result was the importing of User Groups...

    ANY help would be appreciated VERY much! Thanks!

  • #2
    For what its worth, I got this error while uploading the database file from phpBB through phpmyadmin. It stops uploading there...any ideas?

     There seems to be an error in your SQL query. The MySQL server error  output below, if there is any, may also help you in diagnosing the  problem
     ERROR: Unclosed quote @ 67
    STR: '
    INSERT INTO nuke_bbsearch_wordlist VALUES ( 'doesn�t', '48922', '0');
        SQL query:     
                   INSERT INTO nuke_bbsearch_wordlist VALUES ( 'doesn�t', '48922', '0');     
          MySQL said:  
      #1062 - Duplicate entry 'doesn' for key 1


    • #3
      Hey Guys, I found this old post:

      It looks like my phpBB database isn't fully uploading...since mine has an error at _bbsearch_wordlist

      The only thing I want to import are the users and posts/threads/forums.


      • #4
        Looks like you're not importing from phpBB, but phpBB-nuke, which is a slightly different beast.
        I wrote ImpEx.

        Blog | Me


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