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: New category and albums transfer?  (Read 5393 times)

0 Members and 1 Guest are viewing this topic.

shinymama

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 9
    • shinymama.com
New category and albums transfer?
« on: March 06, 2005, 07:16:46 pm »

I've had the photo gallery for almost a year now and I'm quite happy with it.
I don't have any others using the gallery, just me.

I'm acquiring quite a large amount of photos and want to seperate my band photography from my personal pictures.
Right now they are all in one category, I wasn't anticipating wanting to do this in the beginning but now I want to.
I realize now that I should have set it up differentlly.

I tried to create new categories but I notice I cannot move any albums that already exist in the main category over to any new ones.
I did search for a possible solution and I saw  something about going into the database to fix this,  but I'm not sure exactly what to do (didn't find in my search).

Any help is appreciated and thanks.

Here is my photo gallery url so you can see what I mean
http://www.shinymama.com/album/index.php
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: New category and albums transfer?
« Reply #1 on: March 06, 2005, 07:29:06 pm »

You should be able to change the category in the album's properties.
Logged

shinymama

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 9
    • shinymama.com
Re: New category and albums transfer?
« Reply #2 on: March 06, 2005, 08:39:17 pm »

You should be able to change the category in the album's properties.

Yes, I was thinking that also, and I have tried to do just that.
The thing is when I create a new category and go to the album I wish to transfer, the drop-down in the properties doesn't have the new category listed just the existing albums.
Logged

shinymama

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 9
    • shinymama.com
Re: New category and albums transfer?
« Reply #3 on: March 15, 2005, 04:01:10 am »

Is this too hard or is it a really dumb question with an obvious answer?
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: New category and albums transfer?
« Reply #4 on: March 15, 2005, 04:21:24 am »

Actually, you are using v. 1.2x so I'll move this thread accordingly.

Please upgrade to 1.3.2 and you should get a dropdown box of categories under "Album category". It should look like this: http://coppermine.sourceforge.net/manual.php#album_prop
Logged

shinymama

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 9
    • shinymama.com
Re: New category and albums transfer?
« Reply #5 on: March 15, 2005, 10:45:19 pm »

Thank you so much for the heads up. I wasn't quite sure which version I had, I assumed I had the newer one.

Ok, I updated successfully but I am still not seeing the dropdown menu that I'm looking for.
I'm just afraid I initially set up the album wrong and I'll have to re-upload alll the pics after a new configuration.
I am still showing "user gallery".

(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fwww.shinymama.com%2Falbum.jpg&hash=3901abb9b04cd39e08042390003d6f68)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: New category and albums transfer?
« Reply #6 on: March 15, 2005, 11:50:50 pm »

enable "Users can can have private albums" in coppermine's config.

Joachim
Logged

shinymama

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 9
    • shinymama.com
Re: New category and albums transfer?
« Reply #7 on: March 16, 2005, 01:46:55 am »

Ok, well now I think this topic has to be moved again!  ;D

Anyway, the properties on the albums still say "user gallery" after I tried your suggestion.
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: New category and albums transfer?
« Reply #8 on: March 16, 2005, 02:18:07 am »

Since you put the files into a user gallery, instead of the general gallery...
Quote
# Modify my albums
The user can edit album title and description (similar to "album properties" for the admin, but the user can't move his albums to other categories)

This can be fixed by going into the database and changing the aid (album id) to an album that exists in the general gallery. Should only be done after a backup and with some competence manipulating databases.

Here's the query:
Code: [Select]
UPDATE `PREFIX_pictures` SET `aid` = 'X' WHERE `aid` = 'Y';PREFIX = replace with the one in your database. Usually starts with cpg and includes the version number
X = the album id of the one you want to change the album to in the gallery so that the album is no longer in user gallery. You can get this value by looking at the url when viewing the album. It will have this:
album=X where X is the album number
Y = is the album number of the album currently in user gallery.

Please only run this after backing up. I am not taking responsibility if there are issues with this. Doing this method, you could even do a query for certain criteria to move band photos into their own album/category. But we might want to keep things simple for now. ;)
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.