!!!Deleted User on Accident!!! OMG!!!

[MorrisMcD]

Looks like the threads actually deleted the uid that posted it... Still looks 'guestish'..

I don't allow guests to post on my site.. So maybe I could actually run a query to change every threadid that doesn't have a username to change to his?? If I have to plug in his posts the next time I may have to do a post rebuild, I guess I can live with that too.. But if anyone has any ideas, I am all ears

--------------- Added [DATE]1194695646[/DATE] at [TIME]1194695646[/TIME] ---------------

Originally Posted by Marco van Herwaarden

Bad move, userid is used on more (previously deleted) places. Best is to follow the instructions i gave.

Ok cool.. I will do that then if you say so.. Thanks for the advice.. I can reverse what I did so far

--------------- Added [DATE]1194695924[/DATE] at [TIME]1194695924[/TIME] ---------------

Actually.. Sorry to be chatty, but couldnt I actually still use your queries with my current situation and just treat his old uid as NEW_USERID since I manually changed it?

--------------- Added [DATE]1194696718[/DATE] at [TIME]1194696718[/TIME] ---------------

You are the man!!! I did a backup.. I was confident in your queries....

UPDATE post set userid = NEW_USERID WHERE username = 'OLD_USERNAME';

I did just make the newuserid his old one. This query fixed everything.. I looked at the thread set.. It actually keeps the userid in the threadsets.. So I didnt have to run that one..

Thank you so much for your help!!! All seems good now