aguen
April 23, 2020, 7:10am
1
Hi all,
Is it safe to change the username for OJS3 directly in the user table of the DB?
@ctgraham wrote in an old discussion
In both OJS 2.x and in OJS 3.x the username is simply stored in the users table, under the username column. All references to the user by foreign key are handled by the table’s primary key, user_id. Changing the username should not break database referential integrity.
There is one outlier I’m aware of in the UI: in both 2.x and 3.x, OJS stores uploaded files by username, rather than by userid. In 3.x there is no facility for a user to manage their uploaded files, so change the username will…
Is this still valid: change of username will not affect functionality in OJS 3?
Thanks!
I recently did a search of the database tables in OJS 3.1.2 and still found that the username was only present in the users table. Public file uploads, to my knowledge, will still be keyed by the username.