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.  (Read 4872 times)

0 Members and 1 Guest are viewing this topic.

unbeliever

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
There was an error while processing a database query.
« on: November 05, 2005, 12:57:20 pm »

While executing query "SELECT sum(hits) FROM copper_pictures as p LEFT JOIN copper_albums as a ON p.aid=a.aid WHERE 1" on 0

mySQL error: Got error 127 from table handler


what should i do ?!?
i just uploaded some pics, suddenly this message appeared !!

DEBUG-INFO.txt

thx
« Last Edit: November 05, 2005, 02:27:46 pm by Abbas Ali »
Logged

Nibbler

  • Guest
Re: There was an error while processing a database query.
« Reply #1 on: November 05, 2005, 01:29:07 pm »

Repair the table using phpmyadmin
Logged

unbeliever

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: There was an error while processing a database query.
« Reply #2 on: November 05, 2005, 01:34:01 pm »

and how ?
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: There was an error while processing a database query.
« Reply #3 on: November 05, 2005, 02:06:48 pm »

Use your website's Control Panel to repair the tables, or use phpMyAdmin to execute these sql queries:

repair table copper_pictures
repair table copper_albums
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

unbeliever

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: There was an error while processing a database query.
« Reply #4 on: November 05, 2005, 02:11:15 pm »

thx a lot.  ;D
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.