restoring a deleted username?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jilly
    Senior Member
    • Apr 2001
    • 1235
    • 3.7.x

    restoring a deleted username?

    I am running 2.3.3

    A user asked me to delete their username, and I did so, but did not delete their posts - instead, according to the system message, the post would all have been set to 'guest'. Now the user has changed their mind, and wants their name reinstated - can I do that, or do they just have to start a new account?

    and, more importantly I guess, is there any way for me to retrieve their posts that have been set to 'guest', and change them back to the user's name?
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    They'll have to create a new user name.

    If the only guest posts are by that user, then you can restore them using a query like this:

    update post set postuserid = XXXXX where postuserid=0

    Substitute their userid for XXXXX. If you have posts by other people who have been deleted, this will assign all those posts to that user as well.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • jilly
      Senior Member
      • Apr 2001
      • 1235
      • 3.7.x

      #3
      I've never run a query myself yet...

      D'oh! Is this something I can do from the control panel of 2.3.3? If not I'll have to email it to my webhost to run for me... If so, what should I tell him to do?

      Comment

      • dstruct2k
        Member
        • Feb 2003
        • 82
        • 3.0.1

        #4
        Is he the only user that had his posts changed to "Guest" posts? If he is, then Wayne's solution will work perfectly. If not, he'll get some posts that aren't his, but that shouldn't be too big of a deal.

        If you have phpMyAdmin, run this query on your forum's database, or ask your webhost to do it: UPDATE post SET postuserid = 9999 WHERE postuserid=0 (remember to change 9999 to his userid)

        (Yes Wayne, I know I pretty much rephrased what you said. )

        Comment

        • thinkfast
          New Member
          • Feb 2010
          • 14
          • 4.0.0

          #5
          i have same problem too, but i use VB4

          it came out like this
          #1054 - Unknown column 'postuserid' in 'where clause'

          can you help me please

          Comment

          • Trevor Hannant
            vBulletin Support
            • Aug 2002
            • 24325
            • 5.7.X

            #6


            Please post in the vB4 forums for that software version...
            Vote for:

            - Admin Settable Paid Subscription Reminder Timeframe (vB6)
            - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

            Comment

            • borbole
              Senior Member
              • Feb 2010
              • 3074
              • 4.0.0

              #7
              Originally posted by thinkfast
              i have same problem too, but i use VB4

              it came out like this
              #1054 - Unknown column 'postuserid' in 'where clause'

              can you help me please
              Give my mod a try. It does just that and you can do it with ease from the comfort of your Forum Admin Panel.

              Comment

              • funmasti
                Senior Member
                • Oct 2009
                • 170
                • 3.8.x

                #8
                u still using vb2? amazing! pal
                Mastiya

                Comment

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