Critical error: There was an error while processing a database query

[Manutjee]

I've been getting this error on one of my Coppermines lately, and I don't have any experience with this error at all. I've googled a bit, and I have enabled debug_mode and now it's giving me this:

While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
                FROM cpg15x_pictures AS r
                INNER JOIN cpg15x_albums AS a ON a.aid = r.aid
                WHERE (1)
                AND approved = 'YES'
                ORDER BY ctime DESC, pid DESC
                 LIMIT 0 ,8' in include/functions.inc.php on line 1504

mySQL error: Got error 28 from storage engine

What does this mean, and how can I solve it?

[Stramm]

Please ask your host. The hd where mysql stores its data or its temp files are full.

[Manutjee]

Thank you for letting me know!