Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: rE: Critical Error There was an error while processing a database query  (Read 4211 times)

0 Members and 1 Guest are viewing this topic.

gkochane

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

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
Logged

gkochane

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

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?
Logged

Alsterolle

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

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
Logged

Nibbler

  • Guest

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.
Logged

Alsterolle

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

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
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website

If you search for "can't open file .myi" you'll find a very useful sticky post.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.