Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 18 Nov 2008, 08:43
m0nde's Avatar
m0nde m0nde is offline
Join Date: Mar 2005
Question Want to assign orphan guest posts to new user

My user table became corrupted and in repairing the table corruption the last record was deleted.
This has left posts that are labeled with that user's old name but are marked as guest and are assigned to no user profile.

That user re-registered using the same name and has a new userid.

I would like to assign those orphaned posts to this new userid.

Please help.
Reply With Quote
Old 06 Sep 2009, 18:12
koon85 koon85 is offline
Join Date: Sep 2008
You can use this quesry:
UPDATE *_post SET userid='xxxx' WHERE userid = 0 and username = 'Old user name'
*_post is the name of table post, it may have suffix at the beginning.
xxx is the userid of the new user who have registered again.
Old user name is the user name of them before.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 23:53.

Layout Options | Width: Wide Color: