Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases

Reply
 
Thread Tools
Self-Healing Database Details »»
Self-Healing Database
Version: 1.00, by filburt1 filburt1 is offline
Developer Last Online: May 2007 Show Printable Version Email this Page

Version: 2.3.x Rating:
Released: 04-12-2003 Last Update: Never Installs: 40
 
No support by the author.

This hack will attempt to automatically repair a damaged table if a database error of that type should occur.

I haven't tested this yet because I don't really know how to forcefully break my tables, but conceptually it looks like it should work. Let me know if there are problems.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #52  
Old 07-04-2003, 03:07 AM
MuSuL MuSuL is offline
 
Join Date: Sep 2002
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well i wasnt able to access my board becauase of these errors... 1016, user table... now i cna access so i guess it works...

how do i tell? this is the 2nd time im fixing it.. the first time i had to fix the table running a SQL query... and it removed a line from my table.. does this remove any lines?
Reply With Quote
  #53  
Old 07-04-2003, 07:30 PM
Link14716's Avatar
Link14716 Link14716 is offline
 
Join Date: Jun 2002
Location: Georgia, USA
Posts: 2,519
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just installed this onto vB3 (easy to do, but the syntax is a little different so I had to manually scan the file). I doubt I'll need it because I rarely ever get hit with a corrupted database, but it's a great hack. Thanks, filburt.
Reply With Quote
  #54  
Old 07-04-2003, 07:48 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 03:30 PM Link14716 said this in Post #52
I just installed this onto vB3 (easy to do, but the syntax is a little different so I had to manually scan the file). I doubt I'll need it because I rarely ever get hit with a corrupted database, but it's a great hack. Thanks, filburt.
Could I pm you and get the revised edition, sir?
Reply With Quote
  #55  
Old 07-05-2003, 03:18 PM
Link14716's Avatar
Link14716 Link14716 is offline
 
Join Date: Jun 2002
Location: Georgia, USA
Posts: 2,519
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sure, go ahead.
Reply With Quote
  #56  
Old 07-08-2003, 12:21 AM
obiwan8472 obiwan8472 is offline
 
Join Date: Sep 2002
Location: UK
Posts: 153
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just installed it and 10 mins ago got an MYI error email saying Repair Report: The damaged table was successfully repaired.

Wooohoo! Best hack ever!
Reply With Quote
  #57  
Old 07-16-2003, 06:31 PM
WCW Fan WCW Fan is offline
 
Join Date: Jun 2003
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sweet Hack Thanks so much this will come in handy
Reply With Quote
  #58  
Old 09-29-2003, 04:41 PM
mlevenson mlevenson is offline
 
Join Date: Apr 2003
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok I installed it but don't know what to do with it, I know I have an error, but don't know how to cause this to go and repair it. HELP
Reply With Quote
  #59  
Old 12-23-2003, 08:33 PM
kaotic's Avatar
kaotic kaotic is offline
 
Join Date: Mar 2003
Posts: 259
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Will this be useful with vB3 as well, or is there some kind of new feature that nullifies the purpose of this hack?
Reply With Quote
  #60  
Old 02-27-2004, 12:32 PM
MrNase MrNase is offline
 
Join Date: May 2003
Location: Germany
Posts: 670
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Link14716
I just installed this onto vB3 (easy to do, but the syntax is a little different so I had to manually scan the file). I doubt I'll need it because I rarely ever get hit with a corrupted database, but it's a great hack. Thanks, filburt.
Do you plan to make it public? Iam sure a lot of people are looking forward to this
Reply With Quote
  #61  
Old 07-04-2004, 10:26 PM
Jacko's Avatar
Jacko Jacko is offline
 
Join Date: Mar 2002
Location: UK
Posts: 173
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

inc me..
Reply With Quote
Reply

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

Forum Jump


All times are GMT. The time now is 08:37 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04842 seconds
  • Memory Usage 2,294KB
  • Queries Executed 25 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete