rE: Critical Error There was an error while processing a database query

[gkochane]

Hi

I am new to using the coppermine photo album and dont have much coding or Linux experience.  I have set up my online album with a few pictures but today when I visited the page I get the above message and no pictures.

It has been workling fine and I have not altered any links, pictures or folders etc

Any suggestions or help would be greatly appreciated.  The link is http://djkochane.co.uk/coppermine/

Many Thanks

[gkochane]

Also I have just gone into Admin Tools and got this message


Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/gkochane/public_html/coppermine/util.php on line 143

Any clues?

[Alsterolle]

Same problem just happened to me.

http://www.radiocom.se/pics

Pity, since it has been working fine for more than 1 year.

However it happened after erasing albums..

Like the others say - any help greatly appreciated

Olle in Sweden

[Nibbler]

It says mySQL error: Can't open file: 'cpg11d_pictures.MYI'. (errno: 145)

There is a sticky thread about this error that tells you what it is and what to do.

[Alsterolle]

Turned on the debug feature and was informed about the following.
May be a clu for a php savvy person!

While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 28" on 0

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

Olle

[kegobeer]

If you search for "can't open file .myi" you'll find a very useful sticky post.