Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
Reload this Page Self-Healing Database
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 3 of 7 12 3 45 Last »
 
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
  #22  
Old 04-15-2003, 08:16 PM
mclark2112's Avatar
mclark2112 mclark2112 is offline
 
Join Date: Sep 2002
Location: Eastern USA
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I installed the hack, as per the instructions and the board still went down. I got the error that the thread.myi could not be fixed.
Reply With Quote
  #23  
Old 04-15-2003, 08:21 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
What was the exact error message you got? I probably screwed up the regex.
Reply With Quote
  #24  
Old 04-16-2003, 01:17 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Updated, should work now.
Reply With Quote
  #25  
Old 04-16-2003, 09:45 PM
snyx's Avatar
snyx snyx is offline
 
Join Date: Oct 2001
Location: Vancouver (whistler.2010)
Posts: 556
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Database error in vBulletin 2.2.8:

Invalid SQL: SELECT COUNT(*) AS threads FROM thread
mysql error:

mysql error number: 0

Date: Wednesday 16th of April 2003 01:42:36 PM
Script: http://www.form-kaos.com/board/board/
Referer:
Repair Report: This type of error cannot be automatically repaired.
Reply With Quote
  #26  
Old 04-17-2003, 11:41 AM
PKRWUD's Avatar
PKRWUD PKRWUD is offline
 
Join Date: Jan 2003
Location: Ventura, California
Posts: 124
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I installed it yesterday, and my board is down right now. The only difference is that I'm not receiving the error emails.
Reply With Quote
  #27  
Old 04-17-2003, 10:29 PM
snyx's Avatar
snyx snyx is offline
 
Join Date: Oct 2001
Location: Vancouver (whistler.2010)
Posts: 556
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
hummm, filburt have ya abondoned this hack

it seems as my only hope for a temp fix until vb3 hits, or a solution is thought up.

oh well, I will continue to check in here
Reply With Quote
  #28  
Old 04-17-2003, 10:48 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I updated it a few days ago but as I've said I have no way of testing it until my database gets wasted again.

I suggested this to the devs previously but it was shot down, don't remember why.
Reply With Quote
  #29  
Old 04-17-2003, 11:12 PM
zajako's Avatar
zajako zajako is offline
 
Join Date: Jan 2002
Location: a place not to far away
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You are on a roll filburt.
Reply With Quote
  #30  
Old 04-25-2003, 12:32 AM
ub3x ub3x is offline
 
Join Date: Sep 2002
Location: michigandia
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
umm, i'm afraid to install it, is it fixed now?
Reply With Quote
  #31  
Old 04-25-2003, 12:35 AM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It won't break anything but it's still not working. Will fix when I figure out what the hell is wrong.
Reply With Quote
Reply
Page 3 of 7 12 3 45 Last »

« Previous Thread | Next Thread »
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 02:19 PM.

Contact Us - Archive - Top

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.07274 seconds
  • Memory Usage 2,293KB
  • 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
  • (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
  • (4)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