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: "There was an error while processing a database query" .. what does that mean?  (Read 3619 times)

0 Members and 1 Guest are viewing this topic.

lisbizzz

  • Coppermine newbie
  • Offline Offline
  • Posts: 5

My gallery used to be working fine. Now all of a sudden I get an error and I can't view any of the pictures anymore.
I can't figure out what I did wrong, last night it still worked, and I didn't add/change/remove things then.. so I can't figure it out.
The error is: Crictal Error: There was an error while processing a database query

Does anyone know what that is, and perhaps know how to solve it?
I can still log in as admin, and change configuration and such, and all the albums and categories are still there ..  I dunno what's wrong.

Please help me!
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de

enable debug mode in coppermine's config to get the actual query that failed. Post it here (the error message, not the debug_output)
Logged

lisbizzz

  • Coppermine newbie
  • Offline Offline
  • Posts: 5

OK, I did it, this is the error:

While executing query "SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category = 2" on 0

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

ecto

  • Supporter
  • Coppermine frequent poster
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 144
    • My very incomplete gallery
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 20 queries.