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) (http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4200179-supermoderator-wiped-more-than-10-000-of-its-posts?_=1415751031559)
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:

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/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4200179-supermoderator-wiped-more-than-10-000-of-its-posts

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

[karabaja3]

Please do not cross post issues, stick with the thread you started on vb.com, http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4200179-supermoderator-wiped-more-than-10-000-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/vbulletin-3-8/vbulletin-3-8-questions-problems-and-troubleshooting/334220-recreating-a-deleted-thread-number

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

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


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 (http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4200179-supermoderator-wiped-more-than-10-000-of-its-posts?p=4200925#post4200925). 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]

Please do not cross post issues, stick with the thread you started on vb.com, http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/4200179-supermoderator-wiped-more-than-10-000-of-its-posts

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

[ozzy47]

Yes I realize that, but I was making the point if the OP had stayed with the original thread they posted on vB.com, their issue would have been solved much quicker, rather than posting on at least 4 sites, then trying to go back and forth between them to get the answer, :)

[Paul M]

Except that your post reads as an instruction, not advice. :erm:

Please do not do that. ;)

Anyway, nuff said, issue resolved.