coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Ginger on October 18, 2007, 03:40:40 PM

Title: Deleted category from phpMyAdmin - what about the files?
Post by: Ginger on October 18, 2007, 03:40:40 PM
Okay, this is kind of hard to explain. But I wanted to do a little revamp on my Scarlett Johansson gallery (http://www.scarlett-photos.com), specifically on the "Other Projects" gallery. So I wanted to delete the category and start fresh because I had so many sub-categories under that one. I deleted the category from "Categories" and then all of the subcategories ended up on the main page. I thought maybe I could delete all of the subcategories faster from phpMyAdmin and I did that. Fine, and none of the albums from the deleted categories ended up on the main page. But I noticed that the picture count stayed the same so basically the image information is still there, only the photos nor the albums are not and some of those images show in the random files with errors.

My question is, what happened to those albums from the sub-categories that I deleted from phpMyAdmin? Is there a way for me to delete them and hence remove those deleted images from the database too? Or is the only way to try and find the pictures from phpMyAdmin and delete through that?

Like some of the images can be seen here:

http://www.scarlett-photos.com/thumbnails.php?album=lastup&cat=0&page=115

Any help would be much appreciated.
Title: Re: Deleted category from phpMyAdmin - what about the files?
Post by: Stramm on October 18, 2007, 04:09:36 PM
you'll need to even more mess with your db now (phpmyadmin)
with deleting a category using phpmyadmin you didn't delete subcategories neither albums nor the pictures in it

So you first need to assign the albums again to an existing category. In the albums table adapt the field 'category'. You can set this also to 0 (zero). Then the album will upear on the main page (no category)
Title: Re: Deleted category from phpMyAdmin - what about the files?
Post by: Ginger on October 19, 2007, 03:30:09 PM
Thanks very much! Got rid of them now. :)