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: [Solved]: database error  (Read 2933 times)

0 Members and 1 Guest are viewing this topic.

Drew3178

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
[Solved]: database error
« on: April 19, 2004, 11:14:22 pm »
Quote
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)


this totally came out of the blue.. I havent changed any configs or anything, and I suddenly get this error..

any clues?
Logged

Drew3178

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
[Solved]: database error
« Reply #1 on: April 19, 2004, 11:23:37 pm »
BTW, this is integrated with Invision power board (same database even) and it is working fine, its just coppermine..

edit: I just repaired the table via mysql, but im still wondering WHY this happened?? I really dont want to have to repair the table all the time.
Logged

hyperion

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 1317
  • - retired -
[Solved]: database error
« Reply #2 on: April 20, 2004, 01:07:19 am »
Happens for many reasons. If the server went down or the process was terminated in the middle of writing to the database, you will get a corrupt table.
Logged
"Then, Fletch," that bright creature said to him, and the voice was very kind, "let's begin with level flight . . . ."

-Richard Bach, Jonathan Livingston Seagull

(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fwww.mozilla.org%2Fproducts%2Ffirefox%2Fbuttons%2Fgetfirefox_small.png&hash=9f6d645801cbc882a52f0ee76cfeda02625fc537)
Pages: [1]   Go Up
« previous next »
 

Page created in 0.027 seconds with 19 queries.