Announcement

Collapse
No announcement yet.

phpBB import problem

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

  • phpBB import problem

    I need to import database from phpBB2.0.22 to vBulletin 3.6.5


    Selection - Check and update database

    Pressed - Start Module

    Move to page:

    Get database information
    This module will check the tables in the database as well as the connection.

    Pressed - Check and update database

    Result:

    Import / Export
    ImpEx build version : 1.80
    Database cleanup & restart ||| Online manual
    Using includes/config.php for target config.

    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 refrences 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 origional 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 Completed
    Valid found tables :

    Possibly custom tables or incorrect prefix :
    attachments NOT found.
    attachments_desc NOT found.
    auth_access NOT found.
    banlist NOT found.
    categories NOT found.
    config NOT found.
    confirm NOT found.
    disallow NOT found.
    forum_prune NOT found.
    forums NOT found.
    groups NOT found.
    posts NOT found.
    posts_text NOT found.
    privmsgs NOT found.
    privmsgs_text NOT found.
    ranks NOT found.
    search_results NOT found.
    search_wordlist NOT found.
    search_wordmatch NOT found.
    sessions NOT found.
    smilies NOT found.
    themes NOT found.
    themes_name NOT found.
    topics NOT found.
    topics_watch NOT found.
    user_group NOT found.
    users NOT found.
    vote_desc NOT found.
    vote_results NOT found.
    vote_voters NOT found.
    words NOT found.
    If you have all red tables, i.e. none correct this could possible be your table prefix :

    mkp_ Failed Check database permissions and connection, or table prefix to ensure its correct
    vBulletin® v3.6.5, Copyright ©2000-2007, Jelsoft Enterprises Ltd.2007
    Pressed - Continue

    Move to page:

    Import / Export :: phpBB2

    Selection - Associate Users
    Pressed - Start Module

    Show the following letter:

    This module is dependent on Check and update database cannot run until that is complete.
    Pressed - Continue

    Where is the error?

    Thank you in advance for assistance.

  • #2
    That's because it failed the check:

    mkp_ Failed Check database permissions and connection, or table prefix to ensure its correct

    Something is wrong in your ImpExConfig.php settings.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thank you very much for assistance. Possible clarified more?

      Comment


      • #4
        The source db info in your ImpExConfig.php file is wrong. You need to edit that file with the correct info.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Thank you once again for this assistance.

          I think in a deadlock

          Did you mean the data here:


          ####
          $impexconfig['target']['server'] = 'localhost';
          $impexconfig['target']['user'] = 'xxxxxxxxxxxx';
          $impexconfig['target']['password'] = 'xxxxxxxxxxxx';
          $impexconfig['target']['database'] = 'xxxxxxxxxxxx';
          $impexconfig['target']['tableprefix'] = '';
          # If the system that is being imported from uses a database,
          # enter the details for it here and set 'sourceexists' to true.
          # If the source data is NOT stored in a database, set 'sourceexists' to false
          $impexconfig['sourceexists'] = true;
          ####
          #
          # SOURCE - The source is the old forum database (where the data is coming from)
          #
          ####
          # mysql / mssql
          $impexconfig['source']['databasetype'] = 'mysql'; // mysql OR mssql
          $impexconfig['source']['server'] = 'localhost';
          $impexconfig['source']['user'] = 'xxxxxxxxxxxx';
          $impexconfig['source']['password'] = 'xxxxxxxxxxxx';
          $impexconfig['source']['database'] = 'xxxxxxxxxxxx';
          $impexconfig['source']['tableprefix'] = '';
          ####
          #
          # DUPLICATE CHECKING
          # Where unique import id's are aviable ImpEx can check for duplicates with some
          # Tier2 systems this will need to be set to false.
          #
          # yahoo_groups,
          #
          ####

          Comment


          • #6
            Yes, specifically the source db info.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Thank you for such care.

              Deleted Forum database and started from scratch but it didn't help.

              I do not know what I do?

              I have this problem since five days.

              Comment


              • #8
                What is the latest error?
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  i'm having the same probleme and don't know what to do can u please give us more info whre to check or what to edit please

                  Comment


                  • #10
                    If you are getting the same error, then it has the same cause. The source db info you are using is wrong.

                    Unfortunately I have no way of knowing for sure what the correct info is, but in my experience almost all phpBB databases use a table prefix, specifically: phpbb_

                    Try that.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


                    • #11
                      Thanks lot.

                      Here is the solution:

                      $impexconfig['source']['tableprefix'] = 'phpbb_';
                      Best Regards

                      Comment

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