SuperModerator wiped more than 10,000 of its posts

[karabaja3]

I had some problems today, which I described in short at vb.com.
(Please, take a quick look)
Joe D. gave me advice on how to solve it, but I do not know to execute an SQL query to do what he told me.

This I gotta to do:

Originally Posted by Joe D

I don't know the exact queries but I imagine if you copy the post and thread tables from the old backup, add them to the database as post2 and thread2 tables for example.

You would then need a query to copy the entire post from the post2 table to the post table where the postid exists in the post2 table but not in the regular post table.
Repeat for the thread / thread 2 table.

Then clear the cache, rebuild the forum and thread counters.

That should work,

Can someone write a query that I need to perform if you have the time and desire, please? Please, save me!

[ozzy47]

Please do not cross post issues, stick with the thread you started on vb.com, http://www.vbulletin.com/forum/forum...0-of-its-posts

Now should they tell you to post here, then that is a different story.

[karabaja3]

Originally Posted by ozzy47

Please do not cross post issues, stick with the thread you started on vb.com, http://www.vbulletin.com/forum/forum...0-of-its-posts

It's not a cross post. It's just reference to a post at vb.com

They told me what to do and here I asked politely if someone can write a SQL command that I should perform.
I doubt that anyone will help me out there, and here is a lot more enthusiasts who have the knowledge and, I believe, a desire to help.

[kh99]

I wrote a script a while back to restore some deleted threads, which I'm attaching here in case it helps. But I'm afraid it won't do you much good unless you know some php because I was only restoring a small number of threads and I knew all the threadids, so they're just listed in an array.

You might be able to get the deleted thread and post ids from the moderator log, I'm not sure, but it would require some programming.

I might be able to write you a couple queries like Joe suggested, and that may work OK for you, but I don't have time right now. I'll look at it tomorrow if no one else has done it by then.

[ozzy47]

As I said, there is a response to your thread at vB.com, by posting here, and at least at two other sites now, you seemed to missed the response there. That is why it is best to have some patience and stick with one site/thread, not post multiple threads all over the place. It just waists your time, and the time of the people trying to give you support.

I know it can be frustrating, when something like this happens, and you want to get it solved asap, but give the people some time to respond, and keep checking the original thread.

[TheInsaneManiac]

Also for future reference make sure no one, but those you know personally have access to permanently delete posts, let everyone you don't know have soft delete permissions so that way you can restore the soft deleted threads without having to execute sql code.

[Lynne]

I posted a link to this in your other thread - http://www.vbulletin.com/forum/forum...-thread-number

I think you could probably change the queries to be something like this:

PHP Code:

INSERT INTO
   thread
(SELECT
   *
FROM
   thread7
WHERE
   postuserid = xxx) 


PHP Code:

INSERT INTO
   post
(SELECT
   *
FROM
   post7
WHERE
   userid = xxx) 


I have NOT ever tried this!!!! Do NOT do it on your live site until you have tested it on a test site. And, if it works there and you are going to do it on your live site, do NOT do so until you have taken a database backup!!!!

[karabaja3]

Thank you to all very much.

I solved the problem with phpMyAdmin like Joe D. told me to. I managed to restore into base 10,200 posts. Almost all of them. I am very pleased and very grateful for help and effort to explain procedure.

[ozzy47]

Excellent news, glad to hear you were able to successfully do it.

[Paul M]

Originally Posted by ozzy47

Please do not cross post issues, stick with the thread you started on vb.com, http://www.vbulletin.com/forum/forum...0-of-its-posts

There is no rule against posting on both on vb.com and vb.org.