Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Moving picture directories  (Read 2434 times)

0 Members and 1 Guest are viewing this topic.

Concorde Rules

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Moving picture directories
« on: December 09, 2006, 06:17:25 pm »

right, I run www.concorde-photos.co.uk.

The G-BBDG section has been going in one folder, so 2004, 2005 and 2006 photos are all in one folder, making it dam hard to find adding new folders.

I want to move the folders into another folders with the respective year, so 2005 photo folders go into a 2005 folder.

Using this link:
http://forum.coppermine-gallery.net/index.php?topic=32477.0

I see I have to use PHP My admin, I've basically familar with it.

Now its says this:

UPDATE cpg_pictures SET filepath = '/new/file/path/' WHERE filepath = '/old/file/path/';


Im not *quite* sure how it should be.


Lets say I want to move the 2nddecember2006 folder to 2006.

Would it be:
UPDATE cpg_pictures SET filepath = '/albums/concorde/202_bbdg/2006/2nddecember2006' WHERE filepath = '/albums/concorde/202_bbdg/2nddecember2006';



Would this be run in: Run SQL query/queries on database (Main one or cpg_pictures?)

Cheers :)

« Last Edit: December 10, 2006, 07:41:10 am by Sami »
Logged

Concorde Rules

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Moving picture directories
« Reply #1 on: December 09, 2006, 06:33:00 pm »

ahaha, lol! dont it myself.

Easy that :)

Just takes a while..

Gotta update the site while im at it, new updates every week it seems ;)
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.