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
-
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 :'(
-
http://coppermine-gallery.net/tutorial/debug_mode.php
-
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???
-
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).