Announcement

Collapse
No announcement yet.

Lost a user in impex, possible to re-assocaite his posts to a new username in mysql?

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

  • Lost a user in impex, possible to re-assocaite his posts to a new username in mysql?

    One of my users was totally trashed in my import and all his posts still display his name but in regular font because his user account is actually wiped out. Its no big deal, and i've created a new account for him.

    But is there an easy mysql call to re-associate all those threads to his new account?

  • #2
    To add the old posts to the new user, run this query:

    UPDATE post SET userid='xxx' WHERE username='Old Name';

    ...with 'xxx' being the userid number of the new account and 'Old Name' being the user name on those posts.

    After that, rebuild the thread and forum counters in that order:

    Admin CP -> Maintenance -> Update Counters
    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


    • #3
      Thanks steve, you are the best!!!

      Comment


      • #4
        Glad to help.
        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
          Originally posted by jwocky View Post
          One of my users was totally trashed in my import and all his posts still display his name but in regular font because his user account is actually wiped out. Its no big deal, and i've created a new account for him.

          But is there an easy mysql call to re-associate all those threads to his new account?
          ImpEx can only effect users that have importid's, i.e. ones that it has imported.
          I wrote ImpEx.

          Blog | Me

          Comment

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