Announcement

Collapse
No announcement yet.

User history after import

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

  • User history after import

    I have successfully imported over 18,000 posts and over 1,300 members. Everything is up and running. The import process ran smoothly yesterday. Today I have a couple users telling me their user history has been transfered to someone else's account. A user with 93 posts ( user1) still indicates he has 93 posts but if you search all his posts it only returns the 15 he made since yesterday. All his older posts have a different username(user2) associated with them. If I search for posts by user2 it returns that the user does not have any posts as was the case on the old forum.

    I converted from pbpbb 2.0.22 to vB 3.6.8
    Last edited by Macrosill; Wed 23 Jan '08, 2:14pm.
    Thanks,
    Brian

    www.DoItYourselfChristmas.com

  • #2
    Was this a clean import, did the user register again, have you rebuild the search index ?
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      It was a clean import. A fresh vb install with only the settings I wanted.

      The user did not register again.

      I did rebuild the search index as per the Impex instructions.

      The weird thing is this only seems to effect a few scattered users.

      I had done the import initially and there was a lerger group of members effected by this condition. I redid the import of the users and it cured most of them but there are still a few with issue.

      Besides this issue the import went better than expected.
      Thanks,
      Brian

      www.DoItYourselfChristmas.com

      Comment


      • #4
        Most strange.

        It was a clean import. A fresh vb install with only the settings I wanted.
        Did you run the import just once, or have a few runs to test it ?

        The weird thing is this only seems to effect a few scattered users.
        And there is no commonality between the users that you can see ? They weren't all members of a special group in the source system for example ?

        I had done the import initially and there was a lerger group of members effected by this condition. I redid the import of the users and it cured most of them but there are still a few with issue.
        Did you use ImpEx to remove the imported data or delete and restore the vBulletin database ? It's sounding like residual import id's to me.

        Besides this issue the import went better than expected.
        Well that's a bonus

        If the board is live it's going to take some hand picking to sort out, though if you are still testing, I would suggest reverting to a database backup of the target prior to the import and going again.
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          I ran the import once on this clean install.

          No commonality between the users that I can find.

          Just redid the module, no delete or removal other than what Impex does on its own. I thought it removes the old data before it re-imports.

          The board is live. There are only a handful of users effected that I know of. I have no issue with fixing things by hand if someone can guide me how to do it.

          Thanks for the replies and providing a great peice of software along with great support. My bb members are very happy!
          Thanks,
          Brian

          www.DoItYourselfChristmas.com

          Comment


          • #6
            Originally posted by Macrosill View Post
            I ran the import once on this clean install.
            Which is ideal, so not that.

            Originally posted by Macrosill View Post
            No commonality between the users that I can find.
            Curious, must be a glitch in the matrix !

            Originally posted by Macrosill View Post
            Just redid the module, no delete or removal other than what Impex does on its own. I thought it removes the old data before it re-imports.
            It should/does remove the data each time a module is re-run so I'm not sure, though it is the most likely that something happened there.

            Originally posted by Macrosill View Post
            The board is live.
            Eek, clean up time by hand.

            Originally posted by Macrosill View Post
            There are only a handful of users effected that I know of. I have no issue with fixing things by hand if someone can guide me how to do it.
            First off we'll have to diagnose the issue now that we know the symptoms.

            If you have phpMyAdmin, find some of the posts that "should" all belong to user A and where they belong to user B, check that the post.userid is that of user B (which would explain this issue).

            For instance

            User A = user.userid 10
            User B = user.userid 15

            This SQL will confirm what's going on :

            Code:
            SELECT postid, username, userid FROM post WHERE userid=10
            Code:
            SELECT postid, username, userid FROM post WHERE userid=20
            That will show which posts are associated with each.

            Code:
            SELECT postid, userid FROM post WHERE username LIKE "User A"
            Code:
            SELECT postid, userid FROM post WHERE username LIKE "User B"
            Will grab the id's from the names.

            We're just looking at the moment to see which id is wrong, most likely the post.userid.

            Then once we have that, we can sort things out.

            Originally posted by Macrosill View Post
            Thanks for the replies and providing a great peice of software along with great support. My bb members are very happy!
            Your welcome, and good to hear
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              All the posts are listed under "User B" when they should be under "User A"

              The user id is no longer valid as I tried to merge the users to get the history back to the OP. User B has never posted anything so the history should have been empty. Just as an FYI, the user ids are about 500 apart, 356 and 834, something like that.
              Thanks,
              Brian

              www.DoItYourselfChristmas.com

              Comment


              • #8
                First take a database backup.

                Ah OK, the it's residual posts, given :

                All the posts are listed under "User B" when they should be under "User A"
                If :

                User A = user.userid 10
                User B = user.userid 15

                UPDATE post SET userid=10 WHERE userid=15
                Will assign them over.
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  Since User B has been merged into User A User B no longer has a user id #, it comes up as zero. If I do a search with user id zero all kinds of posts come up. Is there a way around this? Can this be done by user name?

                  Maybe I can re-import User B?

                  edit: I was incorrect when I listed the user id's above. The old user id's were 353 for user A and 323 for user B. Could this have caused the issue? Impex misread 323 as 353?
                  Last edited by Macrosill; Tue 22 Jan '08, 6:29pm.
                  Thanks,
                  Brian

                  www.DoItYourselfChristmas.com

                  Comment


                  • #10
                    If there is userid 0 for the posts then they would be guest posts.

                    I'd suggest finding posts that you know to be of user A but appear not to be, then see what userid they have.
                    I wrote ImpEx.

                    Blog | Me

                    Comment


                    • #11
                      Originally posted by Jerry View Post
                      If there is userid 0 for the posts then they would be guest posts.

                      I'd suggest finding posts that you know to be of user A but appear not to be, then see what userid they have.
                      They have userid zero.

                      Would an easy fix be to re-import the users and then merge them?
                      Last edited by Macrosill; Wed 23 Jan '08, 5:50am.
                      Thanks,
                      Brian

                      www.DoItYourselfChristmas.com

                      Comment


                      • #12
                        If you re-import the users then you'll just duplicate them.

                        It's the posts that you would have to re-import, though if your board is live that isn't something you can do.

                        The only option now would be to match the posts using the username.
                        I wrote ImpEx.

                        Blog | Me

                        Comment


                        • #13
                          Originally posted by Jerry View Post
                          .....

                          The only option now would be to match the posts using the username.
                          How would I do that?
                          Thanks,
                          Brian

                          www.DoItYourselfChristmas.com

                          Comment


                          • #14
                            If the posts have the correct username , though no userid, this will find them :

                            Code:
                            SELECT postid, userid FROM post WHERE username LIKE "User A"
                            I wrote ImpEx.

                            Blog | Me

                            Comment


                            • #15
                              I was able to resolve this issue by running the following sql command:

                              update post set userid=10 where username='userB' and userid=0;
                              Thanks,
                              Brian

                              www.DoItYourselfChristmas.com

                              Comment

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