Author Topic: Database screwed up - is there hope?  (Read 2369 times)

0 Members and 1 Guest are viewing this topic.

Offline Gwydion

  • Full Member
  • ***
  • Posts: 126
    • View Profile
Database screwed up - is there hope?
« on: June 30, 2007, 07:24:30 PM »
My glorious webspace provider had technical problems and as result my gallery database has been screwed up completely.
We were able to restore the db with the backup one but there are lots of errors.
The problem I am confronted with is that about 50 % of the thumbnails are missing.
Of course I tried to use the auto-thumbnailer first but it could only handle very few files and mostly came up with an error like this:

Create thumbnail for: filename (filename.jpg) ....   

Warning: imagejpeg() [function.imagejpeg]: Unable to open './../data/thumbnails/9/filename.jpg' for writing in /home/username/public_html/gallery/includes/image_utils.php on line 88
Error creating thumbnail!

I then thought that it might need to check for new images first but this comes up with the following error:

Warning: opendir(./../data/media/13) [function.opendir]: failed to open dir: No such file or directory in /home/username/public_html/gallery/admin/checkimages.php on line 800

The categories in question are all in the category list (cpanel) and I can see on FTP that the files are in the image folders (but like in this example category 9 was missing in the thumbnails).
I thought of making this directory directly via FTP but the script still comes up with errors.

I am not sure whether it is a problem with the files themselves or a script and/or database issue.

I don't know how to fix it. The worst case scenario would be to re-install the gallery inclusive all db entries (which would be some hell of work; I don't even want to think about it).
What shall/can I do?