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: Datbase error  (Read 5066 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.019 seconds with 18 queries.