Lost images due to server crash Lost images due to server crash
 

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

Main Menu

Lost images due to server crash

Started by Forgott3n, November 19, 2007, 09:59:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Forgott3n

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,

QuoteDirectory '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

phill104

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?
It is a mistake to think you can solve any major problems just with potatoes.

Forgott3n

Quote from: phill104 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?

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.

Nibbler

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.

Forgott3n

Quote from: Nibbler 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.

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.