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: Datbase error  (Read 5067 times)

0 Members and 1 Guest are viewing this topic.

colinmann

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 29
Datbase error
« on: March 15, 2005, 10:18:17 pm »
When i go to my photos site @ www.colinmann.com/photos, i get this...

"While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000" on 0

mySQL error: Can't open file: 'cpg11d_pictures.MYI'. (errno: 145)"

Things were working fine earlier today. Please don't tell me it means I've got to rebuild what I've done. I've tried to repair the database... but it says:

"error    : Can't open file: 'cpg11d_pictures.MYI'. (errno: 138)"

Have you please got any other ideas?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Datbase error
« Reply #1 on: March 15, 2005, 11:47:33 pm »
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Datbase error
« Reply #2 on: March 16, 2005, 03:19:40 am »
If you still can't access/repair the table, you might be out of luck.  Do you have a recent MySQL database backup handy?
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

colinmann

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 29
Re: Datbase error
« Reply #3 on: March 16, 2005, 10:11:54 am »
i was unable to restore the database, so i restored it from december :-(. Still an amazing application.
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Datbase error
« Reply #4 on: March 16, 2005, 01:00:55 pm »
Here's more MySQL repair information:

http://dev.mysql.com/doc/mysql/en/repair.html
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
Pages: [1]   Go Up
« previous next »
 

Page created in 0.018 seconds with 19 queries.