Help removing an album

[Bazzah]

I have been trying to figure this out for some time now, but I can not. I have the gallery set up so certain members can create their own albums, in a separate category. However, one of my members done something I can not figure out. They created a new set of albums, but I can not remove it :S I just want to delete the album so it doesn't appear on the list. As you can see by the image below, it says there are 6 albums containing 8 files, but when you click into it, it is empty :S

[edit GauGau] replaced hotlinked image with attachment [/edit]

[Joachim Müller]

You forgot to attach the screenshot that you have refered to. Post a link to your gallery for a start.

[Bazzah]

The screen shot is working fine for me, and it isn't hot link protected or anything. My sites gallery is also unavailable to guests, but the site is www.hirescovers.net

http://www.hirescovers.net/coppermine.jpg

[Bazzah]

bump??

[Joachim Müller]

Post a deep link to the page where you took that screenshot.

[Bazzah]

http://www.hirescovers.net/gallery/index.php?cat=1

username : temp

passowrd : orary

Thanks for looking

[Joachim Müller]

Well, the thumbnail http://www.hirescovers.net/gallery/albums/batch/s_3/thumb_starwars_20.jpg that is suppossed to represent the album http://www.hirescovers.net/gallery/index.php?cat=10003 is missing. Seems like you deleteted the file using your FTP app (instead of using the Coppermine UI).

[Bazzah]

The problem is, it was created by an old administrator of the site, and I am not sure exactly what they have done. It isn't just the thumbnail that is missing. If you go into the album, which is supposed to have 6 albums and 8 files, it is empty. I simply just want to remove that album from showing.

[Joachim Müller]

In phpMyAdmin or similar, run a query like this:

DELETE FROM `YourCoppermineTablePrefix_albums` WHERE `aid` = 10003 LIMIT 1;

[Bazzah]

Thanks GauGau - will that just remove the album, or will it remove all of folder 10003. I only ask as folder 10003 has something around 10000 images in it, so obviously I do not want to lose them.

[Joachim Müller]

The query run on the database will not delete files nor folders. It will remove the album. If you're afraid to do anything wrong, backup your database (create a dump) before performing the query. The query will delete the album in coppermine's database, nothing else.