Critical Error .. pls help me..

[RenTunG]

Sorry if im using broken english..
this my error appear..

There was an error while processing a database query.

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

mySQL error: Can't create/write to file '/var/tmp/mysql_tmp/#sql_232d_0.MYI' (Errcode: 2)

and

Notices

/include/themes.inc.php
Warning line 1192: Cannot modify header information - headers already sent
Warning line 1193: Cannot modify header information - headers already sent
/include/functions.inc.php
Warning line 163: Cannot modify header information - headers already sent

my web: http://www.rentung.net/g/
how i want to fix it??? anyone help me plss..

[Hein Traag]

Im not a MySql wizzard but i reckon this is a problem to be solved by your hoster.

[Joachim Müller]

http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#createWriteMYI