Announcement

Collapse
No announcement yet.

User history after import

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

  • Jerry
    replied
    Then you will have to update the userids on the post by matching the name, something like :

    Code:
    UPDATE post SET userid=X WHERE username LIKE "User A"

    Leave a comment:


  • Macrosill
    replied
    FYI,
    each of the individuals effected by this situation had a userid exactly 30 below the name associated with the post.
    example:
    post was made by userid 206 but the import assigned the post to username xyz with userid zero, the username xyz is userid 176

    post made by userid 1234 but the import assigned the post to username abc with userid zero, the username abc is userid 1204

    Leave a comment:


  • Macrosill
    replied
    I was able to resolve this issue by running the following sql command:

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

    Leave a comment:


  • Jerry
    replied
    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"

    Leave a comment:


  • Macrosill
    replied
    Originally posted by Jerry View Post
    .....

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

    Leave a comment:


  • Jerry
    replied
    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.

    Leave a comment:


  • Macrosill
    replied
    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.

    Leave a comment:


  • Jerry
    replied
    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.

    Leave a comment:


  • Macrosill
    replied
    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.

    Leave a comment:


  • Jerry
    replied
    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.

    Leave a comment:


  • Macrosill
    replied
    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.

    Leave a comment:


  • Jerry
    replied
    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

    Leave a comment:


  • Macrosill
    replied
    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!

    Leave a comment:


  • Jerry
    replied
    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.

    Leave a comment:


  • Macrosill
    replied
    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.

    Leave a comment:

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