Error occured when I tried to upload a pic.

[tkouk]

It was not  the first time I uploaded a pic, obviously, but this happened now without any obvious reason....

I get this common message: There was an error while processing a database query. in every page that connect to the db
and in debug mode I get that the error is in tjis query:

While executing query "SELECT count(*) FROM cpg130_pictures WHERE approved = 'NO'" on 0

mySQL error: Can't open file: 'cpg130_pictures.MYI'. (errno: 145)

or

While executing query "SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 2" on 0

mySQL error: Can't open file: 'cpg130_pictures.MYI'. (errno: 145)

I obviously need info about the file 'cpg130_pictures.MYI'

Any help aprecciated

[yoshikiwei]

sounds like you got a corrupted table

do you have access to MySQL commands ? if yes, try the following to repair your table

login to MySQL

Code Select Expand

mysql -u yourdbusername -h yourhostname yourdbname --password=yourdbpassword

use the repair command

Code Select Expand

repair table cpg130_pictures;

or try this from shell if the above doesn't work

Code Select Expand

myisamchk -r cpg130_pictures

if all failed, you might have to restore the table from a backup copy, provided you do have one  

[tkouk]

Thanx a lot my friend!
REPAIRing the table worked just fine!

Regards from Greece!