Announcement

Collapse
No announcement yet.

phpbb 2.0.7 -> vb3.0.3

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

  • phpbb 2.0.7 -> vb3.0.3

    Below are the results of my attempt at the first step of import. The only thing I can think of is that it's because my source database is 2.0.7 ? My problem is, I only have the database and to update it to 2.0.10 I have to upgrade the whole phpbb forum. Any suggestions? Or will impex work on 2.0.7?


    Thanks!




    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
    avatar - importavatarid OK
    customavatar - importcustomavatarid OK
    customprofilepic - importcustomprofilepicid OK
    post - importpostid OK
    attachment - importattachmentid OK
    pm - importpmid OK

    Database error in vBulletin:ImpEx Target 3.0.3:

    Invalid SQL:
    SELECT fieldname, vbmandatory, defaultvalue, dictionary
    FROM vb3_vbfields
    WHERE tablename = 'usergroup'
    ORDER BY vbmandatory

    mysql error: Table 'rc_vb3.vb3_vbfields' doesn't exist

    mysql error number: 1146

    Date: Tuesday 14th of December 2004 03:29:14 AM
    Script: ***
    Referer: ***
    Username: ***
    IP Address: ****

    Reality Check!

  • #2
    It appears the issue with impex is with the target database, which is the vbulletin 3 installation.

    mysql error: Table 'rc_vb3.vb3_vbfields' doesn't exist

    That gives away that it can not find the vbfields table, which is made by the impex software.

    Make sure you have installed the impex software correctly.

    Download the latest version from the members area, then read the installation instructions in the online manual here: http://www.vBulletin.com/docs/html/impex

    Comment


    • #3
      Here is my impexconfig.php

      [ 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 = "xxxx"
      targetpassword = "xxxxx"
      targetdatabase = xxxxx
      targettableprefix = vb3_

      [ 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

      ; mysql OR mssql
      sourcedatabasetype = mysql
      sourceserver = localhost
      sourceuser = "xxxx"
      sourcepassword = "xxxx"
      sourcedatabase = xxxx
      sourcetableprefix = phpbb_
      Reality Check!

      Comment


      • #4
        I've gone over the setup numerous times and can't see that I've done anything wrong ?
        Reality Check!

        Comment


        • #5
          This was a bug introduced with 1.42 it has been fixed in 1.43+
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            Originally posted by Jerry
            This was a bug introduced with 1.42 it has been fixed in 1.43+
            I just downloaded ImpEx last night?? Wouldn't I have the latest version?? How can I check my version ?
            Reality Check!

            Comment


            • #7
              1.44 and 1.45 came out today.

              your version will be in impex.readme.txt in your impex folder. I'm guessing you have 1.42.
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                Originally posted by Jerry
                1.44 and 1.45 came out today.

                your version will be in impex.readme.txt in your impex folder. I'm guessing you have 1.42.
                your right

                lemme go try the new version!
                Reality Check!

                Comment


                • #9
                  works fine now!
                  Reality Check!

                  Comment


                  • #10
                    Originally posted by BootsSiR
                    works fine now!
                    ok, so not so fine....

                    it got stuck when I tried to skip importing styles... so I choose the option to remove all conversion data and start over... it pooched my vb database... how can I rebuild a scratch vb database without reinstalling the forum ?
                    Reality Check!

                    Comment


                    • #11
                      and yes, I'm a dumbass for not backing up my target db
                      Reality Check!

                      Comment


                      • #12
                        pooched
                        lol, I've not heard that in a while.

                        Originally posted by BootsSiR
                        ok, so not so fine....

                        it got stuck when I tried to skip importing styles... so I choose the option to remove all conversion data and start over... it pooched my vb database... how can I rebuild a scratch vb database without reinstalling the forum ?
                        using the links at the top, to "remove all imported data and session" should do it.
                        I wrote ImpEx.

                        Blog | Me

                        Comment


                        • #13
                          Originally posted by Jerry
                          using the links at the top, to "remove all imported data and session" should do it.
                          Thats what i clicked on that did the pooching haha

                          I can't even access the vb forum now.. db error right away

                          any way to rebuild the db manually ? or do a reinstall?
                          Reality Check!

                          Comment


                          • #14
                            Originally posted by BootsSiR
                            Thats what i clicked on that did the pooching haha

                            I can't even access the vb forum now.. db error right away

                            any way to rebuild the db manually ? or do a reinstall?
                            Well thats very strange, because ImpEx can't alter any of the core of vBulletin, it can only take out what it put in, nothing else.

                            I would suggest a clean install, then backup the database and if it pooches from there, just restore the back up of the fresh install.
                            I wrote ImpEx.

                            Blog | Me

                            Comment


                            • #15
                              Originally posted by Jerry
                              Well thats very strange, because ImpEx can't alter any of the core of vBulletin, it can only take out what it put in, nothing else.

                              I would suggest a clean install, then backup the database and if it pooches from there, just restore the back up of the fresh install.
                              yep, did all that and it seems to be going good now. I didn't realize you could skip the steps you didn't want to do (ie: importing styles). One thing I did notice is, the amount of imported users is significantly less then the total users on the source forum. Does it only import users with posts? or is there some other criteria it follows?
                              Reality Check!

                              Comment

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