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.

It theoretically works.

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.

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

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

Now that makes the hundreds of bugs worthwhile :)

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

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

Amazing! :) A great idea that works!!!

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

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?

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? ;)

Sure, go ahead. :)

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!

Sweet Hack Thanks so much this will come in handy

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

Will this be useful with vB3 as well, or is there some kind of new feature that nullifies the purpose of this hack?

Do you plan to make it public? Iam sure a lot of people are looking forward to this :)

inc me..

not had a problem since vB3 upgrade but indeed you should release it matt :)