Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: There was an error while processing a database query  (Read 3148 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.017 seconds with 19 queries.