forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: r.gely on June 08, 2006, 07:15:19 am

Title: There was an error while processing a database query
Post by: r.gely 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.

Title: Re: There was an error while processing a database query
Post by: Paver 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).