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: [Solved]: database error  (Read 2911 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.02 seconds with 18 queries.