Please help / 1030 - Got error 127 from table handler

[revolutionsales]

Hello all,

 

Out of nowhere when I try to log into the admin side, the page only partial loads (osCommerce and Affiliates infoboxes) and below that this error is displayed:

Warning: mysql_query(): Unable to save result set in /home/revoluti/public_html/catalog/admin/includes/functions/database.php on line 45
1030 - Got error 127 from table handler

select count(*) as count from orders where orders_status = '1'

[TEP STOP]

If I try to pull up the customer side I get this error:

1030 - Got error 127 from table handler

select distinct op.products_id from orders o, orders_products op, products p where o.customers_id = '10' and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit 6

[TEP STOP]

I've read in the forums that this indicates that a database table is corrupt but from the error I not sure which table to look at, orders or orders_products and how to fix it without losing the data. Any help would be greatly appreciated.

 

I don't know if this is related but I'm also not able log into my ipowerweb.com Website Administration. Gives me:

 

The database appears to be down momentarily. If it is not back up within 5 minutes, please contact support. We apologize for any inconvenience.

[revolutionsales]

No sooner asked then answered. Ran

REPAIR TABLE orders

from phpMyAdmin and alls well.