Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: There was an error while processing a database query  (Read 2773 times)

0 Members and 1 Guest are viewing this topic.

Sideswipe

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
There was an error while processing a database query
« on: September 11, 2006, 11:36:58 pm »

Hi,

All of a sudden I've started getting this error message on the main page of my galley "There was an error while processing a database query", and I have no idea how to fix it.

I enabled debug mode and this is what I got :

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

mySQL error: Can't create/write to file '/tmp/#sql_12e6_0.MYI' (Errcode: 13)


This error only started appearing today, I had no problems yesterday.

Any help would be appreciated.

Thanks
Lee.
Logged

Nibbler

  • Guest
Re: There was an error while processing a database query
« Reply #1 on: September 11, 2006, 11:37:35 pm »

Contact your host, it's a server issue.
Logged

xplicit

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 214
Re: There was an error while processing a database query
« Reply #2 on: September 12, 2006, 02:53:41 am »

Nibbler is correct.

Dont suspect your coppermine instal or database, but ask your host to check if the rights voor the tmp directory whch is used by the database itself are set correctly. Hosts soemtimes are working on servers and make changes without setting them back, so that can explain why you experienced problems today while yesterday everything worked fine

It's something only the host has access too unless you are self hosted.

so don't worry :)
Logged
Don't ask me: Can you do this .... or Give me that...or I need Quick help in PM's. I'm not Santaclaus so post your questions on the board so it will be in the benefit for everyone.
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 20 queries.