How to change a Username ?

Darwin · February 27th, 2011, 07:35 PM

Hello

Is there any SQL-Query to change a Username ?
A User wanted to change his Name. Now I changed the Username in Database pp_users.
All Photos uploaded by this User are still under the old Username.

I think I can change it all in pp_photos, but it would be a lot more easier to do it with a SQL-Query or a Function in ACP.

Regards
Michael

Chuck S · February 27th, 2011, 08:21 PM

If you have changed a user's username there is an option in scan database to update a username on photos and comments in that utility in admin.

genehunter · February 27th, 2011, 08:25 PM

assuming the pp_photos table is all that you have to change an update statement should do the trick. there may be other tables, but I am not sure. something like

UPDATE pp_photos
SET pp_photos.user = 'username'
WHERE pp_photos.user = 'oldusername';

Its interesting they have the user id and user name in the table. I am assuming it is for performance reasons not having to do a join to get the username from the pp_users table. only a guess though.

Chuck S · February 28th, 2011, 09:26 AM

Gene there is already functionality in the admin panel that updates usersnames that have changed.

Darwin · March 6th, 2011, 11:00 AM

Quote:

Originally Posted by Chuck S

If you have changed a user's username there is an option in scan database to update a username on photos and comments in that utility in admin.

Thanks, worked fine in Gallery.

But in Statistics-Pal the Username is now missing. Check attachment.

I tried DB-Scans "recalculate photos/posts numbers" and "resync photo/comments usernames/update comments counts" without Success.

Chuck S · March 6th, 2011, 03:56 PM

Maybe turn off the category cache?

what pal is that? Any pals the information is taken off whats in the database.

Darwin · March 6th, 2011, 04:33 PM

Sorry, the empty Field comes from a deleted User.

How do I delete the number of uploaded Photos too ?

Category cache is always off, it`s the Original Topposter-Pal.

Chuck S · March 6th, 2011, 09:46 PM

Okay well that makes sense. There is no way to delete photos after a user is deleted.

You can try inputting this url in your browser with your site name of course etc and change the userid to the userid of that deleted user to see if it deletes his photos. This is the url format used in a users profile where the admin can delete all there photos

http://www.yoursite.com/gallery/adm-...lphotos&uid=49

Darwin · March 7th, 2011, 09:52 AM

Thanks a lot, worked fine !

Chuck S · March 7th, 2011, 10:59 AM

No problem glad that worked.