Announcement

Collapse
No announcement yet.

How do I Merge two (2) Members previous posts into one Member?

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

  • How do I Merge two (2) Members previous posts into one Member?

    We are running Ver 2.6.6.

    I have a few duplicate registrations from our members who registered under the same name with a slight variation.

    Such as:

    John Jones (has 20 posts)
    John A. Jones (has 15 posts)

    I'd like to merge the posts into one User Name, and then delete the remainder.

    How do I perform some like this so they do not lose their previous posts with their permanent User Name?

    If Ver 2.6.6. does not allow this, will Ver 3.0?

    Thank you,

    David

    DAVID COPELAND
    Licensed VB Holder Since 2000
    Celebrating 20 Years with VB

  • #2
    In vB2:

    UPDATE post SET userid=OLDUSERID WHERE userid=NEWUSERID

    vB3 contains an Admin CP function to merge users.
    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
      Originally posted by David Copeland
      We are running Ver 2.6.6.

      I have a few duplicate registrations from our members who registered under the same name with a slight variation.

      Such as:

      John Jones (has 20 posts)
      John A. Jones (has 15 posts)

      I'd like to merge the posts into one User Name, and then delete the remainder.

      How do I perform some like this so they do not lose their previous posts with their permanent User Name?

      If Ver 2.6.6. does not allow this, will Ver 3.0?

      Thank you,

      David
      http://www.vbulletin.org/forum/showt...ht=merge+users

      Comment


      • #4
        Originally posted by Steve Machol
        In vB2:

        UPDATE post SET userid=OLDUSERID WHERE userid=NEWUSERID
        Sorry to ask, but I am a novice.

        Where do I go to UPDATE. And when you write "post", do you mean to choose the "post" option"? And what is SET?

        Is this in the CP, or do I go to our web server and click on UPDATE? I looked in the Admin folder at the website and found no update.

        DAVID COPELAND
        Licensed VB Holder Since 2000
        Celebrating 20 Years with VB

        Comment


        • #5
          Go into PhpMyAdmin and run the following query:

          UPDATE post SET userid=OLDUSERID WHERE userid=NEWUSERID

          Bold = Option which needs to be configured.

          Comment


          • #6
            Remember, it's the user ID, not username. So instead of Bob, it could be 57 or something. You can find the user Id from the links when you over over a person's profile link, or you can find it in the admin CP.

            Comment


            • #7
              Is PhpMyAdmin located in a special sub-folder at the website, or is it in the VB Control Panel?

              I have not run PhpMyAdmin before.

              PS: For our website access, our host has C-Panel for our use.

              DAVID COPELAND
              Licensed VB Holder Since 2000
              Celebrating 20 Years with VB

              Comment


              • #8
                You can find phpMyAdim in the MySQL section of CPanel.
                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

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