Deleted category from phpMyAdmin - what about the files? Deleted category from phpMyAdmin - what about the files?
 

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]

Main Menu

Deleted category from phpMyAdmin - what about the files?

Started by Ginger, October 18, 2007, 03:40:40 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Ginger

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.

Stramm

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)

Ginger