error while processing a database query

[Bojan]

My gallery have worked more than 6 months, but today I received mesage

"There was an error while processing a database query"

If I select Abum list  in Admin menu, I received the same mesage, but Last uploads, Most viewed works.

Do you have any idea , where is the problem ?

[Nibbler]

Enable debug mode in config and post the mysql error message you get (not the entire debug output) when you replicate the error. Please search the board before posting.

[Bojan]

Thanks

I reseived

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 '/tmp/#sql_2181_0.MYI' (Errcode: 13)

[Joachim Müller]

Not related to Coppermine. Ask your webhost for support. You apparently failed to read Nibbler's second suggestion:

Please search the board before posting.

See FAQ -> I get the error message Can't create/write to file '/tmp/#sql_45d5_0.MYI'. What's wrong?