Digital Jedi
04-29-2008, 03:21 AM
Let me make sure this is the right query to run. I want to restore some deleted users posts with their current accounts. I found this query at vB.com:
UPDATE post SET userid='xxx' WHERE username='Old Name';
And, of course, I get an error. :rolleyes:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table '*********_cogonline.post' doesn't exist
So, do I need to add a prefix to post, such as the ones my tables use? Like, say, vb_post or whatever my tables use? Or did I do this wrong from the start?
UPDATE post SET userid='xxx' WHERE username='Old Name';
And, of course, I get an error. :rolleyes:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table '*********_cogonline.post' doesn't exist
So, do I need to add a prefix to post, such as the ones my tables use? Like, say, vb_post or whatever my tables use? Or did I do this wrong from the start?