Announcement

Collapse
No announcement yet.

restoring a deleted username?

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

  • 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?

  • #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 - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #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


      • #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


        • #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


          • #7
            Originally posted by thinkfast View Post
            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.

            http://www.vbulletin.org/forum/showthread.php?t=236861

            Comment


            • #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...
              X