Announcement

Collapse
No announcement yet.

Multiple forum import from UBB

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

  • Multiple forum import from UBB

    I am having problems importing a second forum from UBB. I use the database cleanup and restart, then "Remove importids". It does not clear the history of the imported users/posts etc... and deletes them if I try importing the second board. I have done this on v3.5 so is there a problem with 3.6?

    Any advice appreciated

  • #2
    Does the help.php page run at all ?

    it should set all the import{table}id's to 0 and remove the session.
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      It seems to run ok, no errors but the fields are still populated, nothing is zeroed. I select clean database, then remove ids, then it just returns

      Comment


      • #4
        Impex Help page
        Deleteing Impex Session.

        Session deleted
        Setting importmoderatorid in table moderator to 0.......Completed
        Setting importusergroupid in table usergroup to 0.......Completed
        Setting importrankid in table ranks to 0.......Completed
        Setting importpollid in table poll to 0.......Completed
        Setting importforumid in table forum to 0.......Completed
        Setting importcategoryid in table forum to 0.......Completed
        Setting importuserid in table user to 0.......Completed
        Setting importstyleid in table style to 0.......Completed
        Setting importthreadid in table thread to 0.......Completed
        Setting importthreadid in table post to 0.......Completed
        Setting importforumid in table thread to 0.......Completed
        Setting importsmilieid in table smilie to 0.......Completed
        Setting importpmid in table pmtext to 0.......Completed
        Setting importavatarid in table avatar to 0.......Completed
        Setting importcustomavatarid in table customavatar to 0.......Completed
        Setting importcustomprofilepicid in table customprofilepic to 0.......Completed
        Setting importpostid in table post to 0.......Completed
        Setting importattachmentid in table attachment to 0.......Completed
        Click here to return to the import page.

        But afterwards there are still numbers in the import screen

        Comment


        • #5
          This is what it runs, can you try it manually ?

          Code:
          UPDATE moderator SET importmoderatorid=0 WHERE importmoderatorid <> 0;
          UPDATE usergroup SET importusergroupid=0 WHERE importusergroupid <> 0;
          UPDATE ranks SET importrankid=0 WHERE importrankid <> 0;
          UPDATE poll SET importpollid=0 WHERE importpollid <> 0;
          UPDATE forum SET importforumid=0 WHERE importforumid <> 0;
          UPDATE forum SET importcategoryid=0 WHERE importcategoryid <> 0;
          UPDATE user SET importuserid=0 WHERE importuserid <> 0;
          UPDATE style SET importstyleid=0 WHERE importstyleid <> 0;
          UPDATE thread SET importthreadid=0 WHERE importthreadid <> 0;
          UPDATE post SET importthreadid=0 WHERE importthreadid <> 0;
          UPDATE thread SET importforumid=0 WHERE importforumid <> 0;
          UPDATE smilie SET importsmilieid=0 WHERE importsmilieid <> 0;
          UPDATE pmtext SET importpmid=0 WHERE importpmid <> 0;
          UPDATE avatar SET importavatarid=0 WHERE importavatarid <> 0;
          UPDATE customavatar SET importcustomavatarid=0 WHERE importcustomavatarid <> 0;
          UPDATE customprofilepic SET importcustomprofilepicid=0 WHERE importcustomprofilepicid <> 0;
          UPDATE post SET importpostid=0 WHERE importpostid <> 0;
          UPDATE attachment SET importattachmentid=0 WHERE importattachmentid <> 0;
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            Tried again and it is not clearing the successful or time taken fields, I am running 1.66 and vb 3.6

            I did run your code in native MySQL, and I added my vb table prefix, all looked good until I returned to the import page
            Last edited by webspinner; Tue 26 Sep '06, 2:12pm.

            Comment


            • #7
              Thats the session not the import id's.

              Run this :

              Code:
              DELETE FROM datastore WHERE title='ImpExSession';
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                Hi Jerry

                Thanks for that tip, it seems to have done the trick, importing the second forum now. I will let you know how it goes.

                Cheers

                webspinner

                Comment


                • #9
                  I have found another problem with the import, all the users are coming in as "Imported registered users" with this version. Previous versions identified users who did not have access to the old forums as they hadn't completed the registration process, or were in the moderation queue into separate groups. Unfortunately as there are so many users this is a serious flaw.

                  A less serious problem is that the import only seems to bring in a small percentage of PMs.

                  Any help appreciated, I hope it doesn't involve re-importing the database as the entire process takes over 24 hours.

                  Regards

                  webspinner
                  Last edited by webspinner; Wed 27 Sep '06, 1:01am.

                  Comment


                  • #10
                    What system are you importing from, and you can always just set up the ImpEx usergroup accordingly.
                    I wrote ImpEx.

                    Blog | Me

                    Comment


                    • #11
                      Hi Jerry

                      I am importing the entire user base of a UBB classic 6.3.1.1 forum. There are around 26,000 active users and approx 4,000 who have not completed registration correctly hence cannot access the forum. Using previous versions of Impex it put users without write access into a separate group, this version does not seem to have done that.

                      Any suggestions?

                      Comment


                      • #12
                        Basically I need a way of identifying users that have write post access in UBB, any suggestions welcome

                        Comment


                        • #13
                          Which usergroup are these members in?
                          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


                          • #14
                            Hi Steve,

                            That is the problem. older versions of Impex divided the users into several groups, the version I used today dumped everyone into the imported registered users group. So without going thru several thousand accounts by hand I cannot tell

                            Comment


                            • #15
                              Did you follow follow the 'After the Import' instructions here:

                              http://www.vbulletin.com/docs/html/impex_cleanup
                              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

                              Related Topics

                              Collapse

                              Working...
                              X