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

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]

Main Menu

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

Started by dke, July 15, 2006, 07:00:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

dke

July 15, 2006, 07:00:12 PM Last Edit: July 15, 2006, 08:11:30 PM by 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

#1
July 15, 2006, 07:31:10 PM
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

#2
July 15, 2006, 07:46:40 PM
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

#3
July 15, 2006, 07:50:34 PM
You can't move albums from user galleries to main galleries.

dke

#4
July 15, 2006, 07:53:49 PM
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

#5
July 15, 2006, 08:30:00 PM
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

#6
July 15, 2006, 08:51:38 PM
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 :)
Print
Go Up Pages1
User actions