PDA

View Full Version : What query should I run to retrieve this thread?


thuffner
10-29-2003, 11:03 AM
I am trying to retrieve a thread that is present on my database but does not show up in my forums for some reason. Here is the blurb in my database backup that has the thread title and author of the thread I want to restore:

INSERT INTO post VALUES (3030,290,'Perminisconious',36,'What was the last Bond movie you watched?',1052120232,'What was the last Bond movie you watched? Be it on VHS, DVD, TV, or in the theater, let everyone know, and feel free to update it as often as you watch one.\r\n\r\nI just finished watching The Spy Who Loved Me (which inspired this thread). I watched it as recently as 6 months ago, and I had forgotten how much I enjoy that one.',1,1,'24.126.134.40',0,1,0,0,0);


I don't understand it though. It looks here like it is a post. Is some other query necessary for it too?

What MySQL query should I run to restore this thread?

Thanks in advance...

NTLDR
10-29-2003, 05:41 PM
That indeed is a post, are you sure the thread hasn't just been added to the moderation queue?

thuffner
10-29-2003, 07:00 PM
There isn't anything in my moderation queue for posts or threads. What can I do to get that back?

thuffner
10-29-2003, 11:11 PM
Fixed everything. Thanks. :)