Print

[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]

mysql -u yourdbusername -h yourhostname yourdbname --password=yourdbpassword
use the repair command

Code: [Select]

repair table cpg130_pictures;
or try this from shell if the above doesn't work

Code: [Select]

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!