critical error

[satumaa13]

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 :'(

[Nibbler]

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

[satumaa13]

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???

[Nibbler]

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