Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: There was an error while processing a database query  (Read 3116 times)

0 Members and 1 Guest are viewing this topic.

r.gely

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
There was an error while processing a database query
« on: June 08, 2006, 07:15:19 am »

Hi there,

I know this issue has been posted before (I read the posts) but I cannot seem to fix my issue. I am using a French translated version of CPG and all of the sudden I am unable to access any of the albums. I get the following error message:

There was an error while processing a database query
While executing query "SELECT filepath, filename FROM rgpics_pictures WHERE filepath LIKE 'Piscine_Updt3%'" on 0
mySQL error: Table './raphael_gely/rgpics_pictures' is marked as crashed and should be repaired

How could I repair this. I cannot find a repair menu in the 'tools/utils' menu.

You can see from this I am a newbie so no flaming please.
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1609
  • Paul V.
Re: There was an error while processing a database query
« Reply #1 on: June 08, 2006, 07:17:35 am »

That's a MySQL error that Coppermine is passing along.  You need to repair the table using a MySQL tool like phpMyAdmin.  You cannot repair the table in Coppermine.

Often the table is fine after repair.  Sometimes it's not.

This is a good reason to make frequent backups of the database (along with the Coppermine files).
Logged
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 19 queries.