Self-Healing Database
 

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.

Well I have been getting repair reports when any database error occurs but I haven't gotten a screwed-up table error yet.

Cool. I installed it, hopefully it works! Good idea filburt! :)

What a cool idea. Well done.

It just hit me, like the 740 errors about thread.myi that I got in my Inbox this morning. ;)

Great idea.. I was thinking about it this morning, but I don't have the time to write it! thanks filburt!

740? I just got 3,500 error emails about a similar issue. :)

Well aren't we and our severely messed-up board special :p

Coincidently this seems to have started when my server changed to MySQL 4. Hopefully it's not related.

hehee I got 2000 emails last time thread.MYI was corrupted :p I just installed this hack...

Filburt, you say that I got an email when a table is repaired?

I got that issue this morning as well, 230 emails. what happend?

With every error e-mail that you get now, there will be an extra line of text with the "repair report." It'll either say it fixed it, it couldn't, or it can't fix this type of error.

Ingenius :)

I've installed it... we shall see... :)

...and I thought 464 was a bunch!
Great idea filburt1 :)

Jbear6

Here's what the new database errors look like. Note the last line:
(also a teaser for my mail script :p)

Didn't work.

for those that dont know,
check this thread re the 'Thread.MYI' error

http://www.vbulletin.com/forum/showt...threadid=69171

Explain.

im gettin these errors a good 4/5 times a day, Im luck I clicked over here and found this puppy, im gunna give her a go rite now, even if it means being late for C block english12 :D

installed, and it was so easy I can still make it to class on time!
haha..

thanks filburt, im going to cross my fingers and hope this does the trick (for now) my forums are in your code. (if that makes sense)

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.

What was the exact error message you got? I probably screwed up the regex.

Updated, should work now.

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.

I installed it yesterday, and my board is down right now. The only difference is that I'm not receiving the error emails.

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 :)

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.

You are on a roll filburt.

umm, i'm afraid to install it, is it fixed now?

It won't break anything but it's still not working. Will fix when I figure out what the hell is wrong.

Should work, looking at the code.... keep working at it. :) It would be great to have this has a backup measure in case of table corruption.

The whole bit where it fetches the table name is wrong but I'm reasonably sure I'm using the right regexp...

...although it might work now.

:( My email record for errors was 120, I'll keep trying though, BUT if I combine em I get like 700 :)

This is getting old quick. My site was going down on average once every 3 days, but it's gone down 4 times in the past 3 days. Ugh. Any luck with this yet?

Have you used the very latest edit of this hack?

My email record for errors is well over 3000 :p

My site has also been experiencing thread.myi errors recently. Each time I get to it before it gets too bad but still..

Any sign of this hack working yet?

Thanks for this hack Filburt, might as well try and stop getting all those emails before they start coming in like crazy.

Does it really works, Filburt?