Argh! Need help with error "DB Error: Bad SQL Query:........"

[spyc]

i have no idea what happened, i have been using this no problem for 2 months and then while i was in the middle of adding new images i got this:

DB Error: Bad SQL Query: SELECT cat_id, COUNT(image_id) AS new_images FROM 4images_images WHERE image_active = 1 AND image_date >= 1140551505 GROUP BY cat_id
Got error 127 from storage engine

DB Error: Bad SQL Query: SELECT cat_id, COUNT(*) AS num_images FROM 4images_images WHERE image_active = 1 GROUP BY cat_id
Got error 127 from storage engine

DB Error: Bad SQL Query: SELECT COUNT(*) as total_images FROM 4images_images WHERE image_active = 1 AND cat_id NOT IN (0)
Got error 127 from storage engine

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (0) ORDER BY i.image_date DESC LIMIT 4
Got error 127 from storage engine


i have no idea what happened, and i am a computer dummy. And it says in all my galleries there are 0 images!  Does anyone know what this is, and how/where to fix it?

http://spycdesigns.com/images/index.php

[spyc]

and adding.....

i cannot access my 4 images control panel either

[V@no]

MySQL error code 127: Record-file is crashed

I guess, try to repair your tables with phpmyadmin or something simular....and make sure you mention this to your host administrator, maybe they can give you more help on this one.

[spyc]

i am in the phpmyadmin now, but have no clue how to repair the tables

i found one table and hit the repair button, but no changes

[V@no]

Well, then contact your host administrator, maybe restarting mysql would help...hopefuly you have some database backups, just in case...