Announcement

Collapse
No announcement yet.

restoring a deleted username?

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

  • funmasti
    replied
    u still using vb2? amazing! pal

    Leave a comment:


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

    Leave a comment:


  • Trevor Hannant
    replied


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

    Leave a comment:


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

    Leave a comment:


  • dstruct2k
    replied
    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. )

    Leave a comment:


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

    Leave a comment:


  • Wayne Luke
    replied
    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.

    Leave a comment:


  • jilly
    started a topic restoring a deleted username?

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X