OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



change usernames

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

change usernames

Postby Krekels » Wed Apr 26, 2006 8:28 am

Hello,

For an new launch of an existing journal we import the current user registration files. That all works fine. But now we initially register the users by ther registration number which will easily be forgotten. It would be very nice if users could change their username in their profile. Is this in any way possible.

Kind Regards,

Hubert Krekels
Krekels
 
Posts: 17
Joined: Mon Dec 05, 2005 9:02 am

Postby asmecher » Wed Apr 26, 2006 8:39 am

Hi Hubert,

You'll have to do this in the database as follows:
Code: Select all
UPDATE users SET username='new_username_here', password=MD5(CONCAT('new_username_here', 'new_password_here')) WHERE username='old_username_here';
Note that you'll have to reset passwords as well, since they are part of the password hash. (In this example, I'm using MD5 hashing; check which hashing function you're using in OJS's config.inc.php file.)

Regards,
Alec Smecher
Open Journal Systems Team
Last edited by asmecher on Tue May 22, 2007 9:42 am, edited 1 time in total.
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

username key in system?

Postby Liz » Mon Jul 24, 2006 3:28 pm

I just want to check that the username is not a key elsewhere in the system that will cause problems later down the road?
Liz
 
Posts: 17
Joined: Wed Nov 16, 2005 12:15 pm

Postby asmecher » Mon Jul 24, 2006 3:47 pm

Hi Liz,

No, the username is not used as a key elsewhere. The only gotcha is that you'll have to re-hash the password as above.

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: change usernames

Postby msengulj » Mon Oct 20, 2014 3:26 pm

Hello Alec, Thanks for this detail. Has anything changed in terms of changing usernames since 2006? I would like to change the usernames of a few members of our journal on their behalf. If not, I am also unclear exactly what it means to "do this in the database as follows:" where would the "database" be that I'd be inserting new code?

Thanks for your help in advance.
MSJ
msengulj
 
Posts: 6
Joined: Tue Aug 05, 2014 12:11 am

Re: change usernames

Postby asmecher » Mon Oct 20, 2014 3:49 pm

Hi MSJ,

No, we're still using the same approach to usernames. The statement quoted above is a database SQL statement; you'll have to execute it in a database client, e.g. phpMyAdmin.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: change usernames

Postby msengulj » Mon Oct 20, 2014 5:29 pm

Hi Alec, thanks for the quick response. I actually found a different work-around. I enrolled users using different email addresses and this time put their preferred username. Then I went in and merged the users, so that the old user was merged with the new user. Then I changed the email address so that their initial address was affiliated with the entry.
msengulj
 
Posts: 6
Joined: Tue Aug 05, 2014 12:11 am


Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 0 guests

cron