forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Bazzah on May 23, 2007, 12:27:07 pm

Title: Help removing an album
Post by: Bazzah on May 23, 2007, 12:27:07 pm

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]

Title: Re: Help removing an album
Post by: Joachim Müller on May 23, 2007, 01:00:41 pm

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

Title: Re: Help removing an album
Post by: Bazzah on May 23, 2007, 06:43:32 pm

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 (http://www.hirescovers.net/coppermine.jpg)

Title: Re: Help removing an album
Post by: Bazzah on May 27, 2007, 10:28:02 pm

bump??

Title: Re: Help removing an album
Post by: Joachim Müller on May 28, 2007, 09:19:46 am

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

Title: Re: Help removing an album
Post by: Bazzah on May 28, 2007, 02:14:48 pm

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

username : temp

passowrd : orary

Thanks for looking

Title: Re: Help removing an album
Post by: Joachim Müller on May 28, 2007, 08:46:47 pm

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).

Title: Re: Help removing an album
Post by: Bazzah on May 28, 2007, 09:37:06 pm

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.

Title: Re: Help removing an album
Post by: Joachim Müller on May 29, 2007, 06:51:58 am

In phpMyAdmin or similar, run a query like this:

Quote

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

Title: Re: Help removing an album
Post by: Bazzah on May 29, 2007, 12:21:56 pm

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.

Title: Re: Help removing an album
Post by: Joachim Müller on May 30, 2007, 09:22:50 am

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.