forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: satumaa13 on July 11, 2007, 11:05:26 pm

Title: critical error
Post by: satumaa13 on July 11, 2007, 11:05:26 pm

Hi ...

I need help with this error, everytime I open the main URL of my Coppermine gallery I get this message:
"There was an error while processing a database query"

URL= http://janne-tulkki.eu/kuvagalleria/index.php

Is this a Mysql error or a Coppermine error or is it a problem of the server??? I use Coppermine 1.4.5

Any help is MUCH appreciated!!!
Nicola :'(

Title: Re: critical error
Post by: Nibbler on July 11, 2007, 11:12:49 pm

http://coppermine-gallery.net/tutorial/debug_mode.php

Title: Re: critical error
Post by: satumaa13 on July 11, 2007, 11:19:23 pm

Sorry I am a newbie.....

this is what I get when I enable the debug mode:

While executing query "SELECT * FROM cpg145_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_7cc1_0.MYI'; try to repair it


Hmmmm.... any ideas what I have to change???

Title: Re: critical error
Post by: Nibbler on July 12, 2007, 12:11:48 am

Ask your webhost for support. It's a problem with MySQL, possibly related to lack of disk space on /tmp. You can disable the random block in config as a workaround (admin.php).