DB errors on Frontpage

[jfkcro]

I get this errors on frontpage :

Got error -1 from table handler SQL=SELECT ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count,\na.*, u.name AS author, u.usertype\nFROM mos_content AS a\nINNER JOIN mos_content_frontpage AS f ON f.content_id = a.id\nLEFT JOIN mos_users AS u ON u.id = a.created_by\nLEFT JOIN mos_content_rating AS v ON a.id = v.content_id\nWHERE a.state=\'1\'\n AND a.access <= \'2\'\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())\nORDER BY f.ordering, a.ordering ASC, a.catid, a.sectionid LIMIT 11

I tryed (and nothing worked)
-reduce meta tag's
-repair DB and mos_contente table
-Dump, Drop and rebuild table

It is Mambo 4.5 1.0.9 [Spider], and site is www.terracro.com , odd thing that remain of site works just fine.

Any help will be great

[jfkcro]

Another thing I just notice, when i go to Administration > News (and only in this section) i get following error :

DB function failed with error number 1030
Got error -1 from table handler SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' AND c.sectionid='1' ORDER BY catid, ordering LIMIT 0,10

[jfkcro]

Problem solved, it looks like my hosting provider have limited space for MySQL temp files, and since i have a lot of visitors that low space blocked all on frontpage.

After he cleared temp files all is working now, he also rise amount of that temp space