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.

[insanctus]

I am lost about something .... Everyone asking if it works when by reading he is doing a hit and miss and needs input if it works.

Do as I and take the 2 minutes to install the hack if it does not work post what it did/didn't do and then maybe he can try again.

Or perhaps it will work. Thanks Filburt for this hack I am installing now.

My board got hit just few hours ago so this is well worth a shot.

[filburt1]

It theoretically works.

[insanctus]

Well I just installed it.. Took all of 40 seconds. Now I will just sit and pray for 1 of 2 things.

1. I do not have find out if this works.

2. That if it messes up this does work

Either way it is there.

[lifesourcerec]

I get like 3 different errors., but the main one is this:

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT COUNT(*) AS count,postuserid,postusername FROM thread GROUP BY postuserid ORDER BY count DESC LIMIT 1
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

[Jacko]

well i was getting the thread.myi errors..

installed this hack

and i got 1 error message back saying: Table was repaired and all works great..


THANK YOU.. !

i guess you can safely say it works

[filburt1]

Now that makes the hundreds of bugs worthwhile

[Jacko]

indeed it does.

once again it fixed my forum this morning

only 1 email with DB problem

instead of around 150 which my dial up defo doesnt like

this has to be the easiest hack but yet the best. i would nominate for HOTM

[insanctus]

I just wanted to report back... I have this installed and I had the miss fortune to finaly need it.

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.threadid,thread.replycount,thread.views,thr ead.votenum,thread.votetotal,thread.dateline,forum .allowratings FROM thread LEFT JOIN forum ON (forum.forumid=thread.forumid) WHERE thread.forumid IN (2) AND visible!=0 AND open!=0 AND open!=10 ORDER BY sticky DESC,dateline DESC LIMIT 5
mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Monday 26th of May 2003 07:16:19 PM
Script: http://sanguinox.com/forums/index.php
Referer: http://sanguinox.com/
Repair Report: The damaged table was successfully repaired.

Thanks for the hack and making it possible for my board to heal itself

[Erwin]

Amazing! A great idea that works!!!

[PixelFx]

this is hack has saved me a few times, thank you