Announcement
Collapse
No announcement yet.
restoring a deleted username?
Collapse
X
-
Originally posted by thinkfast View Posti 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
http://www.vbulletin.org/forum/showthread.php?t=236861
Leave a comment:
-
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:
-
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:
-
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:
-
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:
-
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?Tags: None
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Leave a comment: