Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2014, 07:46 PM
afterburn25 afterburn25 is offline
 
Join Date: Apr 2013
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default backing up database users and threads

hi my database got corrupted actually its all functional but has a very minor glitch which doesn't allow administrator to access any posts i get an error so i got a week old backup database and it works but doesn't include any of the newer members threads or posts which is the main thing you don't want to lose.

My question is are there any other tables i need to back up besides users, threads, and posts to restore database to all the newest content
Reply With Quote
  #2  
Old 09-20-2014, 08:04 PM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is not an approach you should take lightly. I would talk with vbulletin support on vBulletin.com. There are many interactions between the tables.

What table does has the corruption?
Reply With Quote
  #3  
Old 09-20-2014, 08:19 PM
afterburn25 afterburn25 is offline
 
Join Date: Apr 2013
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I wish I knew all I Know is when I try to view a post I get a strange error but that error only happens if I use an account apart of the administrator group I have a thread on it here https://vborg.vbsupport.ru/showthrea...5&goto=newpost
Reply With Quote
  #4  
Old 09-20-2014, 08:22 PM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you ran "repair" on your database a couple of times? You can do that within vBulletin in ACP --> maintenance. Additional information can be found on table repairs in the Mysql manual or just Google the subject.

--------------- Added 20 Sep 2014 at 14:54 ---------------

Quote:
Originally Posted by afterburn25 View Post
I wish I knew all I Know is when I try to view a post I get a strange error but that error only happens if I use an account apart of the administrator group I have a thread on it here https://vborg.vbsupport.ru/showthrea...5&goto=newpost
This is the same issue it did not require a new thread. Please do not duplicate post as it makes it difficult to assist you.

If the Admincp is reporting that Javascript is not enabled. Then Javascript is not enabled and you need to resolve that issue. Take a look at your browser's "Console" -- development mode might have to be enabled on your browser. If there is a problem running JavaScript it will be reported there.

At this point I would need access to your ACP before I could assist you any further. You obviously have something funky going on but it needs to be attacked with sound troubleshooting techniques. As an alternative you may wish to post in the paid request forum for assistance, or if you have recently purchased vbulletin file a support ticket at vBulletin.com.

--------------- Added [DATE]1411255675[/DATE] at [TIME]1411255675[/TIME] ---------------

Please enable the hook/plugin system in your config.php
Reply With Quote
  #5  
Old 09-20-2014, 10:58 PM
afterburn25 afterburn25 is offline
 
Join Date: Apr 2013
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok its done
Reply With Quote
  #6  
Old 09-20-2014, 11:01 PM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 03:29 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04743 seconds
  • Memory Usage 2,206KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete