Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Easy way to move albums from one category to another  (Read 2801 times)

0 Members and 1 Guest are viewing this topic.

lolainslacks

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Easy way to move albums from one category to another
« on: October 25, 2011, 05:37:55 am »

When I started off my gallery I sorted events pics by categories like Awards & Galas, Movie Premieres & Screenings, Film Festivals, etc.. But now I want to sort the albums by year. How do I move the albums from these categories to the years ones?

Is there an easy way to do that without losing the viewings count? Maybe via phpMyAdmin?

Help, please!

Thanks in advance!
Logged

lurkalot

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 949
  • +Tinyportal Support team.
Re: Easy way to move albums from one category to another
« Reply #1 on: October 25, 2011, 09:45:01 am »

See, http://documentation.coppermine-gallery.net/en/albums.htm#album_howMoveAlbum

All comments, views, votes etc will move with them.  If you're not sure, just create a test album, and try moving it around, and you see how it works
Logged
Running SMF 2.1.4  / Tinyportal 3.0.0, bridged with Coppermine 1.6.25, plus cpmfetch 2.0.0

lolainslacks

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Re: Re: Easy way to move albums from one category to another
« Reply #2 on: October 25, 2011, 10:22:58 am »

See, http://documentation.coppermine-gallery.net/en/albums.htm#album_howMoveAlbum

All comments, views, votes etc will move with them.  If you're not sure, just create a test album, and try moving it around, and you see how it works

I have over 150 albums. Is there any way of batch doing it?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Easy way to move albums from one category to another
« Reply #3 on: October 25, 2011, 12:12:20 pm »

There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.
Logged

lolainslacks

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Re: Re: Easy way to move albums from one category to another
« Reply #4 on: October 25, 2011, 09:10:19 pm »

There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.

Do I have to change anything in the pictures table?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Easy way to move albums from one category to another
« Reply #5 on: October 25, 2011, 10:08:44 pm »

No.
Logged

lolainslacks

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Re: Re: Easy way to move albums from one category to another
« Reply #6 on: October 25, 2011, 10:26:28 pm »

There's no built-in batch moving feature. If you want to do this with PHPMyAdmin, have a look at the albums table and adjust the category values.

What do you mean by adjust the category values?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Easy way to move albums from one category to another
« Reply #7 on: October 25, 2011, 10:55:38 pm »

Just look at the albums table. There's a column with the categories' IDs in it, which determine which album belongs to which category. If you adjust that value (for each album), it/they will appear in the corresponding category.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.