View Single Post
  #1  
Old 10-27-2016, 02:38 PM
TheAllusionist TheAllusionist is offline
 
Join Date: Apr 2005
Posts: 101
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Query to run to restore Thread Post

Yesterday it appears that when I installed a jFusion module in Joomla to read vBulletin 4 latest post that it took one thread (most popular one on site of course) and put me (adminsitrator) as the last and only post in the thread all the way back to around 3/26/2014.

So I contact the collocation facility that host my server and that I pay monthly for extra storage backup to revert the database and they get back to me and say, apparently things haven't been backing up for a long time and what we do have seems corrupted. Well the last backed up database for vBulletin I have is from 12/15/15 and it doesn't seem to want to work, could be just some new or updated plugins, etc. are causing a problem, but if I did get it to work, who knows if something somewhere not readily noticeable is wrong.

So I would like to run a query to update the database tables with that last database for the thread " Forum: Architectural Designs - On the Drawing Board (id: 23)" and restore what I can at least and then I will delete the ones I can't do anything about. Could I get some help on how to track down in the SQL file the information I need and the query on the database that I need to run to install it? I have of course backed up my current database.

Site is 3dallusions.com Thanks in advance,

Russell
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01160 seconds
  • Memory Usage 1,761KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete