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.

[filburt1]

Today at 10:59 PM JulianD said this in Post #9
hehee I got 2000 emails last time thread.MYI was corrupted I just installed this hack...

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

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.

[Dean C]

Ingenius

[Erwin]

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

[jbear6]

Yesterday at 09:44 PM Erwin said this in Post #7
740? I just got 3,500 error emails about a similar issue.

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

Jbear6

[filburt1]

Here's what the new database errors look like. Note the last line:

Database error in vBulletin Mail System :

Invalid SQL: INSERT INTO mailmessage
    (userid, headers, dateline, readflag, fromname, subject, message)
    VALUES 
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

mysql error number: 1064

Date: Tuesday 15th of April 2003 10:34:28 AM
Script: /mailcheck.php
Referer: http://www.webdesignforums.net/showt...2277#post72277
Repair Report: This type of error cannot be automatically repaired.

(also a teaser for my mail script )

[mclark2112]

Didn't work.

[Stu]

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

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

[filburt1]

Today at 12:13 PM mclark2112 said this in Post #16
Didn't work.

Explain.

[snyx]

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

[snyx]

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)