forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: shinymama on March 06, 2005, 07:16:46 pm

Title: New category and albums transfer?
Post by: shinymama 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
Title: Re: New category and albums transfer?
Post by: Tranz on March 06, 2005, 07:29:06 pm
You should be able to change the category in the album's properties.
Title: Re: New category and albums transfer?
Post by: shinymama 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.
Title: Re: New category and albums transfer?
Post by: shinymama on March 15, 2005, 04:01:10 am
Is this too hard or is it a really dumb question with an obvious answer?
Title: Re: New category and albums transfer?
Post by: Tranz 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
Title: Re: New category and albums transfer?
Post by: shinymama 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=a45101ce8592130b51c4f88e005e3ae628785d74)
Title: Re: New category and albums transfer?
Post by: Joachim Müller on March 15, 2005, 11:50:50 pm
enable "Users can can have private albums" in coppermine's config.

Joachim
Title: Re: New category and albums transfer?
Post by: shinymama 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.
Title: Re: New category and albums transfer?
Post by: Tranz 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. ;)