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: How to change Owner name  (Read 2877 times)

0 Members and 1 Guest are viewing this topic.

patexocet

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
How to change Owner name
« on: October 17, 2005, 12:52:53 pm »

Hello,

I want to change the owner_name for many pictures in one operation. How can I do that.

Thank you for your help.

Pat
« Last Edit: October 17, 2005, 05:24:14 pm by GauGau »
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: How to change Owner name
« Reply #1 on: October 17, 2005, 01:10:09 pm »

assume the user name is Stramm and you want to change it to Kelly
1. in the admin menu click users, search for Stramm and change his name to Kelly.. unfortunately this will only change his name in profile and for the new pics but not for the old ones. I think that needs improvement in new CPG versions

2. To avoid this use phpmyadmin and execute a command like that one
Code: [Select]
UPDATE `cpg_pictures` set  owner_name='Kelly' WHERE  owner_name='Stramm';
change the cpg to your table prefix. Backup your database before you mess with it

patexocet

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: How to change Owner name
« Reply #2 on: October 17, 2005, 01:44:16 pm »

Thank you Stramm, it works fine...

Pat
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.