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: Critical Error after server goes down...  (Read 3242 times)

0 Members and 1 Guest are viewing this topic.

unquiet_void

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Critical Error after server goes down...
« on: August 03, 2006, 06:01:11 pm »

My hosts server went down during the process of adding albums earlier this morning. As a result, There is apparently an error in the database stopping visitors from viewing my gallery at all. In addition, I cannot delete the category the albums were supposed to be in, even when in Debug Mode. Here is the error message. I can supply Debug Information if needed.

Thanks. ^_^


CRITICAL ERROR:
While executing query "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg148_albums AS a  LEFT JOIN cpg148_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (10, 11, 12, 13, 14, 23, 15, 16, 17, 18, 19, 20)GROUP BY a.aid" on 0

mySQL error: Got error 127 from table handler
« Last Edit: August 06, 2006, 03:41:23 am by TranzNDance »
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Critical Error after server goes down...
« Reply #1 on: August 03, 2006, 06:09:43 pm »

means a table got corrupted. Use a tool like phpmyadmin to repair the table or ask your host for support

unquiet_void

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Critical Error after server goes down...
« Reply #2 on: August 03, 2006, 06:13:04 pm »

okay. well my hosts "support" isn't exactly brilliant and i'd be lucky if i got a reply tomorrow, lol. And unfortunately I don't have access to anything like phpMyAdmin...

I only installed my gallery yesterday, would it be okay to just delete the database altogether, make a new one and re-install the gallery from install.php?

or will that end up creating 2 galleries/more problems?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Critical Error after server goes down...
« Reply #3 on: August 03, 2006, 06:19:30 pm »

Possible... but it's always good to have a tool like phpmyadmin. Download it, install and repair the table. Eventually your server will go down again and you have the same problem. To avoid that think about regular db backups (-> phpmyadmin)
http://www.phpmyadmin.net/home_page/index.php

unquiet_void

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Critical Error after server goes down...
« Reply #4 on: August 03, 2006, 06:30:05 pm »

ah!

okay, thanks for the advice! ^_~
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.