Print Page - How to change Owner name

Title: How to change Owner name
Post by: patexocet 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

Title: Re: How to change Owner name
Post by: Stramm 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

Title: Re: How to change Owner name
Post by: patexocet on October 17, 2005, 01:44:16 PM

Thank you Stramm, it works fine...

Pat

coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: patexocet on October 17, 2005, 12:52:53 PM