DB Error: Bad SQL Query: SELECT ....Got error 122 from table handler

[ascanio]

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 myspace_images i, myspace_categories c LEFT JOIN myspace_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) AND i.image_date >= 1134061441 ORDER BY RAND() LIMIT 3
Got error 122 from table handler
Hola, he recivido este error en mi galeria de un dia para el otro sin haber cambiado nada en mi pagina
alguien sabe que puedo hacer para arreglarlo?

[excitex2]

Saludos,,,

El error : Got error 122 sifnifica que la cuota de disco ha sido superada .
Este error ( Got error 122 from table handler ) también lo da,, cuando la base de datos se corrompe,,, osea cuando necesita repararse,,, por lo tanto prueba a pulsar REPARAR TABLA    

Espero que se solucione así,,, sino tendrás que ponerte en contacto con el administrador de tu hosting y que te de más espacio util.

excitex2

[ascanio]

gracias por contestar amigo
tenia razon habia que reparar la table pero no podia entrar a mi phpAdmin ya que me daba un error
V@no me dio una solucion
la pongo aqui por si alguien la necesita en un futuro, realmente funciona

Ok, I asume you have SSH access.
Login as to your account through SSH, and type:
mysql -u username -p

(replace username with your database username
When prompted type your database password.

if login was successfull, you should see something like:
Quote
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13650 to server version: 4.1.15-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
You are now can manage your database there.

Next type:
connect databasename
(replace databasename with the name of database used by phpmyadmin)

Then, if no errors, type:
repair table myspacetable \g

If you see no error message, try login into your phpmyadmin, if it shows you simular error message but for another table, repeat the repair procedure for that table.

Same thing you can try to do to myspace_lightboxes table, only if the mysql can not repair it, then you'll need to delete it and create new one.

Good luck.

[V@no]

OS error code 122:  Disk quota exceeded