Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Help removing an album  (Read 5350 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.02 seconds with 19 queries.