Please help

[fgenetics]

My search suddenly decided to die on me one fine day, I did nothing to change it.

The error I am getting is as follows


Link: http://www.xxxxxxxxxxxxxxxxx.com/forum/search.php?do=getnew

Invalid SQL:

SELECT searchid, dateline
FROM search AS search
WHERE userid = 6
ORDER BY dateline DESC LIMIT 1;

MySQL Error : Got error 127 from table handler
Error Number : 1030
Date : Monday, November 12th 2007 @ 11:08:02 PM
Script : http://www.xxxxxxxxxxxxxxxx.com/forum/search.php?do=getnew
Referrer : http://www.xxxxxxxxxxxxxxxx.com/forum/forum.php?do=list
IP Address : 24.136.xxx.xxx
Username : admin
Classname : vb_database


What do i do? Please advice.

[valdet]

I would suggest to Optimize/Repair your tables. You can do it either through vB Admin Panel or from phpMyAdmin..

I can almost bet that a couple of database table repairs will solve your problem..

Look at this vb.com link as well..
http://www.vbulletin.com/forum/showthread.php?t=100983

Regards,
Val.