forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: gkochane on April 11, 2005, 06:44:10 pm

Title: rE: Critical Error There was an error while processing a database query
Post by: gkochane on April 11, 2005, 06:44:10 pm

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

Title: Re: rE: Critical Error There was an error while processing a database query
Post by: gkochane on April 11, 2005, 06:50:04 pm

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?

Title: Re: rE: Critical Error There was an error while processing a database query
Post by: Alsterolle on April 13, 2005, 10:37:28 pm

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

Title: Re: rE: Critical Error There was an error while processing a database query
Post by: Nibbler on April 13, 2005, 10:42:58 pm

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.

Title: Re: rE: Critical Error There was an error while processing a database query
Post by: Alsterolle on April 13, 2005, 10:44:20 pm

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

Title: Re: rE: Critical Error There was an error while processing a database query
Post by: kegobeer on April 13, 2005, 11:02:39 pm

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