coppermine-gallery.com/forum

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.

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.