New category and albums transfer?

[shinymama]

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

[Tranz]

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

[shinymama]

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.

[shinymama]

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

[Tranz]

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

[shinymama]

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://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.shinymama.com%2Falbum.jpg&hash=a45101ce8592130b51c4f88e005e3ae628785d74)

[Joachim Müller]

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

Joachim

[shinymama]

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

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

[Tranz]

Since you put the files into a user gallery, instead of the general gallery...

# 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 Expand

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.