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: mySQL error: Incorrect key file  (Read 2989 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.062 seconds with 20 queries.