There was an error while processing a database query

[r.gely]

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.

[Paver]

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).