Move all Administrator galleries from "User Gallery" to a Category

[dke]

Why isnt this as simple as it sounds? Should be really simple just like moving a picture from a gallery to another but for some reason there is no dropp down menu for "Category" when editing a album created in "User Gallery" or also known as "*My Gallery*"

Only way i see it is to manually take "Edit Files" on the album, and then manually change every single file to the category i want it in. But if i have around 100 000 objects to manually change that would take a lifetime, so i need some kind of tool that can do this for me. I guess a simple sql query could do this aswell, since it should only be a ID that changes to a different table?

Anyone have a clue, i really need to get this done asap, thanks in advance

[dke]

Ive looked around some more and found under "Update Album" there is a "Album Category" but this one is hardcoded to User Gallery and can not be changed. Shouldnt there be a little arrow there where i should be able to browse for another category and just change it to "No Category" ?

Thing is that i want my albums to be displayed on the front page, and i didnt know this was possible untill now, and i have 16 albums that needs to be moved from "My gallery" to "No Category"

EDIT: Check here http://coppermine-gallery.net/demo/cpg14x/docs/pics/edit_album.gif you can clearly see that there is a arrow there in that picture besides "Album Category" how come i dont have this arrow?

[dke]

i can move single pictures to a category ive created, but i cannot move the entire album, since i have 140 000 pictures to move, help!

[Nibbler]

You can't move albums from user galleries to main galleries.

[dke]

how come? im not trying to move other users galleries im trying to move my own, shouldnt i have the premission to move my own galleries to "no category" all i really want is my albums to be displayed on the main page, is there other ways?

[dke]

k i guess there is no simple way through the ui to do this, reason? there is no reason.... just plain simple not added, i have no clue why, everything is there but this simple feature. I guess i have to get my head into how the sql database is structured and execture a query that makes the changes i need, having to batch add every picture again just to get it out of user galleries would be to much of a timesink also killing the harddrive.

Please add to the faq that if you place your pictures inside user galleries you will NOT be able to move them as a whole, you will have to manually move each one, by using "Edit Files" and change all the dropp down menus for each data to the other category you would like, this would spare people who might intend to never have users on their coppermine but accidently upload their data to "my gallery" alot of time.

[dke]

i figured it out, using mysql front or any other mysql editor, just go to table cgp147_albums and just change the category manually. The user categories begin with 1001+ and no category = 0 so if you want your User Gallery albums moved to no category just change all the category colums to 0, ive tested this slightly and it works for all i know