Register Members List Search Today's Posts Mark Forums Read

Closed Thread
 
Thread Tools
  #1  
Old 12 Nov 2014, 00:55
karabaja3's Avatar
karabaja3 karabaja3 is offline
 
Join Date: Jan 2008
SuperModerator wiped more than 10,000 of its posts

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!
  #2  
Old 12 Nov 2014, 01:01
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
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.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
  #3  
Old 12 Nov 2014, 01:08
karabaja3's Avatar
karabaja3 karabaja3 is offline
 
Join Date: Jan 2008
Originally Posted by ozzy47 View Post
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.
  #4  
Old 12 Nov 2014, 02:50
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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.
Attached Files
File Type: php rt.php (4.7 KB, 3 views)
  #5  
Old 12 Nov 2014, 11:21
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
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.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.

Last edited by ozzy47; 12 Nov 2014 at 11:30.
  #6  
Old 12 Nov 2014, 18:07
TheInsaneManiac TheInsaneManiac is offline
 
Join Date: Feb 2008
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.
  #7  
Old 12 Nov 2014, 19:00
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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!!!!
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
  #8  
Old 14 Nov 2014, 00:51
karabaja3's Avatar
karabaja3 karabaja3 is offline
 
Join Date: Jan 2008
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.
  #9  
Old 14 Nov 2014, 00:53
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
Excellent news, glad to hear you were able to successfully do it.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
  #10  
Old 14 Nov 2014, 01:37
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by ozzy47 View Post
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.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
  #11  
Old 14 Nov 2014, 01:42
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
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,
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
  #12  
Old 14 Nov 2014, 02:46
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Except that your post reads as an instruction, not advice.

Please do not do that.

Anyway, nuff said, issue resolved.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Closed Thread



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 12:28.

Layout Options | Width: Wide Color: