There was an error while processing a database query.
While executing query "SELECT * FROM cpg148_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 8" on 0
mySQL error: Can't create/write to file '/tmp/#sql_2c92_0.MYD' (Errcode: 17)
what should i do?
Means that your database is broken. Run the repair command. If you have no idea about this, google for "mysql repair" or ask your webhost for support.