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: database query  (Read 3052 times)

0 Members and 1 Guest are viewing this topic.

Master D

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
database query
« on: March 18, 2006, 03:58:27 am »

I don't know what to do to fix this problem.

"Critical error
There was an error while processing a database query "

I turned on Debug mode:
Code: [Select]
While executing query "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg143_albums AS a  LEFT JOIN cpg143_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (11)GROUP BY a.aid" on 0

mySQL error: Got error 127 from table handler

Please help!  Any help is greatly appreciated.

Thank you!    :)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: database query
« Reply #1 on: March 18, 2006, 07:08:08 am »

In the future, please search for your error message first (has been reported before). The error message means that your database got corrupted. Fix it running mysql's repair command from a console or in phpMyAdmin.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 15 queries.