forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: StephMarie834 on August 21, 2008, 03:29:32 am

Title: an error while processing a database query
Post by: StephMarie834 on August 21, 2008, 03:29:32 am

This is what my gallery has been saying lately.

There was an error while processing a database query.

What should I do?

Title: Re: an error while processing a database query
Post by: François Keller on August 21, 2008, 07:13:26 am

is this the whole error message ?
was your gallery working before?
a link?

Title: Re: an error while processing a database query
Post by: StephMarie834 on August 21, 2008, 08:17:26 am

Yes that's the whole message and yes the gallery worked before and for some reason it popped up and said an error while processing a database query. Here is the link to the gallery:

http://inspiring-couple.com/Privileged-Online/Photo-Gallery/

Title: Re: an error while processing a database query
Post by: François Keller on August 21, 2008, 10:00:33 am

enable debugg mode http://coppermine-gallery.net/tutorial/debug_mode.php (http://coppermine-gallery.net/tutorial/debug_mode.php)

Title: Re: an error while processing a database query
Post by: StephMarie834 on August 21, 2008, 11:57:04 am

Okay I did it step by step and still didn't work.

Title: Re: an error while processing a database query
Post by: François Keller on August 21, 2008, 01:26:17 pm

you have th ewhole error message here

Quote

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

mySQL error: Got error 127 from storage engine

look into your database via a tool like phpmyadmin and try to repair the tables

Title: Re: an error while processing a database query
Post by: StephMarie834 on August 21, 2008, 08:35:22 pm

how? I've tried everything.

Title: Re: an error while processing a database query
Post by: Nibbler on August 22, 2008, 12:36:29 pm

Then ask your webhost for support.