Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Help removing an album  (Read 5143 times)

0 Members and 1 Guest are viewing this topic.

Bazzah

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Help removing an album
« 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]
« Last Edit: May 28, 2007, 09:18:24 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Help removing an album
« Reply #1 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.
Logged

Bazzah

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Help removing an album
« Reply #2 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
Logged

Bazzah

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Help removing an album
« Reply #3 on: May 27, 2007, 10:28:02 pm »

bump??
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Help removing an album
« Reply #4 on: May 28, 2007, 09:19:46 am »

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

Bazzah

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Help removing an album
« Reply #5 on: May 28, 2007, 02:14:48 pm »

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

username : temp

passowrd : orary

Thanks for looking
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Help removing an album
« Reply #6 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).
Logged

Bazzah

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Help removing an album
« Reply #7 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Help removing an album
« Reply #8 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;
Logged

Bazzah

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: Help removing an album
« Reply #9 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Help removing an album
« Reply #10 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 19 queries.