forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: mr.d on October 29, 2005, 09:12:59 pm

Title: 42 albums to 1 album..?
Post by: mr.d on October 29, 2005, 09:12:59 pm

Hi!

I'm using coppermine 1.3.2. I have 42 albums, over 25.000 pictures. And now, i want to move all files to one album. Is it possible to move all files at the same time? It too hard to move file by file.

mr.d

Title: Re: 42 albums to 1 album..?
Post by: Nibbler on October 29, 2005, 09:55:26 pm

You can run a query directly on the database.

Code: [Select]

UPDATE cpg_pictures SET aid = 123
Change cpg_ to the prefix you chose during installation and 123 to the id of the album you want the pics in. Backup first.

Title: Re: 42 albums to 1 album..?
Post by: Joachim Müller on October 30, 2005, 12:21:46 pm

and while you're at it: upgrade from cpg1.3.2 to the most recent stable cpg1.3.5 - see the announcement board to get an idea why you should.