spontaneous MySQL error

[N!ck]

hi guys...i'm getting this error from a board i've got running on my computer:


Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SELECT t1.* FROM template AS t1 LEFT JOIN template AS t2 ON (t1.title=t2.title AND t2.templatesetid=-1) WHERE t1.templatesetid=1 AND t1.title<>'options' AND ISNULL(t2.templateid) ORDER BY t1.title
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Monday 04th of November 2002 07:29:22 PM
Script: http://localhost/dk2/dk2/admin/template.php?action=modify&expandset=1
Referer: http://localhost/dk2/admin/template.php?action=modify


it happens when i go into the admin cp and click "expand" next to the template set title. it also happens when i try to download the style.

if anyone could help, i'd appreciate it. thanks.

[N!ck]

btw, i've never even made mods to template.php. (as the title says)

[Erwin]

uh-oh... you may need to repair your template table... It may have become corrupted somehow.

Try this query...



REPAIR TABLE template;

[Erwin]

Backup your database just in case things get worse...

[N!ck]

thanks a million! didn't back up...you just missed me...good thing it worked though :D

i really wouldn't have been totally ruined if my database was messed up anyway...it's just a local test board for building styles and stuff