moving user galleries pics to reg. albums

[ktwenrick]

I have searched around the boards and found this http://forum.coppermine-gallery.net/index.php?topic=22895.0  but not sure if it can help me since its for 1.3x

i was wondering if anyone has a solution for moving photos that users have uploaded into the User Galleries and allowing the admin (myself) to move them into regular albums, so that they are more organized and visitors can find them much eaiser.. thanks to anyone who can help me.

[wahhsabee]

I'm bumping this because it's old and it needs to be addressed.

I'd really love to be able to do this right now.

[Joachim Müller]

Files can be moved at any time by going to "edit files" next to the thumbnail that represents the album and then using the dropdown field to move the pics.

[wahhsabee]

Files can be moved at any time by going to "edit files" next to the thumbnail that represents the album and then using the dropdown field to move the pics.

This allows you, the admin/s, to move individual files within a user's gallery into any other galleries, but is there a way to move entire albums?

Yes, I can move files within albums by selecting each file within the users album, but that is very time consuming and you risk not selecting the appropriate album (more files to move, more dropdowns, more margin for error).

I might be overlooking something, but is there a way to move whole albums?

[Joachim Müller]

Currently, you can't move albums from the user galleries to the public ones using the coppermine UI. Only "fast" option is to use a third-party tool like phpMyAdmin.

[wahhsabee]

Thanks for the quick reply!

I see. Are there plans for it in the future?

And can you point me in the proper direction for the mysql queries?

[Joachim Müller]

I see. Are there plans for it in the future?

Being considered. Not that easy though, as quota needs to be taken into account.

I see. Are there plans for it in the future?

Use phpMyAdmin's user interface. Change the albums table, modifying the category column. Backup before you start your modifications.

[wahhsabee]

Being considered. Not that easy though, as quota needs to be taken into account.
Use phpMyAdmin's user interface. Change the albums table, modifying the category column. Backup before you start your modifications.

You're a finely tuned, well lubed machine at quick replies!

Thanks for the tips. I'll give it a shot.

I'll report back (hopefully with good news.)

[wahhsabee]

Holy crap that was easy.

Why didn't I think of that before!

I think even easier than using cpg gui. That would require more clicks!

[DonSpliff]

Hello.

Can you explain in a few words how you did it ?

Thanks in advance.

[no way]

It's very simple:
First open your phpMyAdmin.
Select your database.
Open  cpg149_albums
View entries and change the number of the category...

that's it

[DonSpliff]

Thanks Dude.

[natrlhy]

Thanks, this post helped me move an album from one catagory to another.  I also got more comfortable with phpMyAdmin. Modified other fields like the pid, ctime, etc. I made sure I created a backup/dump of the database first though.