Advanced search  


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.

Pages: [1]   Go Down

Author Topic: How to choose another user  (Read 2208 times)

0 Members and 1 Guest are viewing this topic.


  • Coppermine newbie
  • Offline Offline
  • Posts: 9
How to choose another user
« on: February 26, 2014, 06:20:11 pm »

After uploading photos how to choose another user who would author the photos?
Thank you so much.


  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: How to choose another user
« Reply #1 on: February 27, 2014, 04:07:35 am »

Coppermine sets the owner to the user uploading (or batch adding) the files. Don't know of any interface in Coppermine to change owner...
However it can be quite simple to change the owner of all pics in given album via phpMyAdmin.

You will need some data values from other tables (or more complex SQL)
For example to change owner of all pics in album with aid '3' to user with user_is 8 and cpg table prefix of 'cpg_':
UPDATE cpg_pictures SET owner_id = '8' where aid = '3'

Other criteria can of course be used as appropriate... Always a good idea to backup your databases before updating.

My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money
Pages: [1]   Go Up

Page created in 0.02 seconds with 19 queries.