Announcement

Collapse
No announcement yet.

phpBB importing issue

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

  • phpBB importing issue

    I have a brand new installation of vb3.01. Totally unmodified. After installation, I uploaded and configured the impex system.

    The phpBB and the vb3.01 are in the same database. I configured the impex with the db info and it seems to work. However, when I try press the "Check and Update Database" button, I get a long string of errors. They are as follows:

    --------------------------------------
    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 phpBB userid.


    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
    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 NOT found or a non standard table.
    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.

    phpbb_auth_access found.
    phpbb_banlist found.
    phpbb_categories found.
    phpbb_config found.
    phpbb_confirm NOT found or a non standard table.
    phpbb_disallow found.
    phpbb_forum_prune found.
    phpbb_forums found.
    phpbb_groups found.
    phpbb_posts found.
    phpbb_posts_text found.
    phpbb_privmsgs found.
    phpbb_privmsgs_text found.
    phpbb_ranks found.
    phpbb_search_results found.
    phpbb_search_wordlist found.
    phpbb_search_wordmatch found.
    phpbb_sessions found.
    phpbb_smilies found.
    phpbb_themes found.
    phpbb_themes_name found.
    phpbb_topics found.
    phpbb_topics_watch found.
    phpbb_user_group found.
    phpbb_users found.
    phpbb_vote_desc found.
    phpbb_vote_results found.
    phpbb_vote_voters found.
    phpbb_words found.
    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 NOT found or a non standard table.
    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.

    --------------------------------------

    Help!! The styles and Smilies import with no problem, but everything else appears to import but actually does nothing. Help!!

  • #2
    NOT found or a non standard table.
    This just means it wasnt expectin the table, you should be able to contine

    Comment


    • #3
      I appreciate your quick reply. However, I am not able to continue. When I choose "Import Users", it acts like it is going to do it, but it shows no users being imported and does not import any. It does the same thing for every other button except the forums, the styles and the smilies.

      ideas?

      Comment


      • #4
        It would appear that you have the wrong target db details in your Impex config file. That would explain why it can't find the vB tables.
        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
          but the db settings are EXACTLY THE SAME. The vb3 and the phpBB are in the same db. How could it possibly be wrong?

          Comment


          • #6
            Originally posted by bitg
            but the db settings are EXACTLY THE SAME. The vb3 and the phpBB are in the same db. How could it possibly be wrong?
            Are you using the same user and password details for the target and source database in impexconfig ?
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              Yes, Here is what my impexconfig file looks like.

              [ 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 = username
              targetpassword = password
              targetdatabase = hidingplace_com
              targettableprefix =

              [ Source Database ]
              ; 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

              sourceexists = true

              sourcedatabasetype = mysql
              sourceserver = localhost
              sourceuser = username
              sourcepassword = password
              sourcedatabase = hidingplace_com
              sourcetableprefix = phpbb_

              Let me assure you that the username and password are identical.

              Comment


              • #8
                What version of phpBB are you importing from ?
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  Originally posted by Jerry
                  What version of phpBB are you importing from ?
                  I was running v2.06 but when I got this problem, I upgraded to v2.08a and still have the same problem.

                  Ideas?

                  Comment


                  • #10
                    Originally posted by bitg
                    I was running v2.06 but when I got this problem, I upgraded to v2.08a and still have the same problem.

                    Ideas?

                    My bad.

                    I introduced a bug into the download yesterday, I've updated it now I believe.

                    Try downloading impex again and over writing the files and continuing with the import.
                    I wrote ImpEx.

                    Blog | Me

                    Comment


                    • #11
                      It still gives me the error that it does not like the tables. However, if I ignore that, it works like a charm.

                      Thanks for your help.

                      Comment


                      • #12
                        Originally posted by bitg
                        It still gives me the error that it does not like the tables. However, if I ignore that, it works like a charm.

                        Thanks for your help.
                        Good to hear.

                        I'll have to update that warning as its a bit miss leading, its only meant to be a notification opposed to a proper error.
                        I wrote ImpEx.

                        Blog | Me

                        Comment

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