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: mySQL error: Incorrect key file  (Read 3017 times)

0 Members and 1 Guest are viewing this topic.

dcbrit2003

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
mySQL error: Incorrect key file
« on: April 09, 2006, 01:57:01 am »
Hi All,

When I go the album index/home page in my Coppermine installation I just started getting an error message and when itno debug mode. I saw this error message :

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

mySQL error: Incorrect key file for table '/tmp/#sql_179e_0.MYI'; try to repair it

I logged into MySQL manually and tried to repair the table with "repair table cpg143_pictures;" but this did not work. Any suggestions?

Regards, Mark
« Last Edit: April 09, 2006, 10:52:40 pm by Nibbler »
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: mySQL error: Incorrect key file
« Reply #1 on: April 09, 2006, 02:35:26 am »
Do a check table on the pictures table to get an actual MySQL error message.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

dcbrit2003

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: mySQL error: Incorrect key file
« Reply #2 on: April 09, 2006, 10:48:39 pm »
problem solved. THere was a large file taking up all the space in /tmp
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.017 seconds with 20 queries.