restoring a deleted username?

[jilly]

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]

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.

[jilly]

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?

[dstruct2k]

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. )

[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

[Trevor Hannant]

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

[borbole]

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

[funmasti]

u still using vb2? amazing! pal