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: Lost images due to server crash  (Read 3671 times)

0 Members and 1 Guest are viewing this topic.

Forgott3n

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
  • Coppermine User
    • C3Studios
Lost images due to server crash
« on: November 19, 2007, 09:59:12 pm »

Hello,

There was an issue with our server and some image data was lost. However, the MySQL database survived and now means that there are roughly 200 photo entries in the database that point to no actual existing images.

When I try to remove the entries (aka delete albums and photos within albums) I get an error saying,

Quote
Directory 'albums/###/' is not writable, files can't be deleted

Where "###" is the album number.

Of course this is because no such ### folder exists. Is there any way I can fix the problem? You can see the gallery here:

http://www.avrilbandaids.com/Gallery
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4862
    • Windsurf.me
Re: Lost images due to server crash
« Reply #1 on: November 19, 2007, 10:23:48 pm »

You could use a tool such as phpmyadmin to manually edit the database.

Does your host not have a recent backup you could restore to?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Forgott3n

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
  • Coppermine User
    • C3Studios
Re: Lost images due to server crash
« Reply #2 on: November 19, 2007, 10:33:25 pm »

You could use a tool such as phpmyadmin to manually edit the database.

Does your host not have a recent backup you could restore to?

I can manually delete the images in Phpmyadmin, I am just wondering if there is an easier/faster method. There is no way to use a backup to restore the lost images. This is due to the fact that this dedicated server did not have the backup system activated until after the crash. It was then we realized that no such system was online.

Could you tell me which entires I have to delete or edit to make sure I don't break the database by accident?


Thanks.
Logged

Nibbler

  • Guest
Re: Lost images due to server crash
« Reply #3 on: November 19, 2007, 10:46:03 pm »

Best thing to do is create the directories it complains about. If you delete things manually then you could end up with the database in an inconsistent state.
Logged

Forgott3n

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 13
  • Coppermine User
    • C3Studios
Re: Lost images due to server crash
« Reply #4 on: November 20, 2007, 02:19:53 am »

Best thing to do is create the directories it complains about. If you delete things manually then you could end up with the database in an inconsistent state.

Would it be wise to create a tool to automatically weed out missing data so one doesn't have to manually remove albums? Thanks for your help, I've started on your method.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 21 queries.