Advanced search  


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  (Read 2245 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine newbie
  • Offline Offline
  • Posts: 1
mysql error
« on: September 27, 2009, 09:02:33 pm »


suddenly I get a MySql-Error.


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

mySQL error: Incorrect key file for table '/var/lib/mysql/.tmp/#sql_e94_0.MYI'; try to repair it

But on the server ist no file like sql_e94_0.MYI - so I can't repair it.

Please help me to fix this error.

Thank You

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
Re: mysql error
« Reply #1 on: September 27, 2009, 11:05:28 pm »

Ask your webhost for support. That file is the core of the mysql database. You don't have access to that if you're webhosted. The error means that your mysql database is broken. Not related to coppermine.
If you have further questions, please respect board rules in the future: it's mandatory to post a link to your gallery in each thread you start.
Pages: [1]   Go Up

Page created in 0.016 seconds with 19 queries.