forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Bojan on July 29, 2007, 11:12:08 pm

Title: error while processing a database query
Post by: Bojan on July 29, 2007, 11:12:08 pm

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 ?

Title: Re: error while processing a database query
Post by: Nibbler on July 29, 2007, 11:18:28 pm

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.

Title: Re: error while processing a database query
Post by: Bojan on July 29, 2007, 11:28:45 pm

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)

Title: Re: error while processing a database query
Post by: Joachim Müller on July 30, 2007, 07:55:28 am

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

Quote from: Nibbler on July 29, 2007, 11:18:28 pm

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? (http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#createWriteMYI)