We currently have a user set up with an incorrect username. What is the easiest

We currently have a user set up with an incorrect username. What is the easiest way to amend this please?
Thanks

OriginalPostID-138141

OriginalPostID-138141

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi Eduardo, even we were facing the same problem and reacted the problem in the same way by renaming it to a temp value and then renaming back to required value. Rename worked but the problem is that we are getting this error in logs for that user "ERROR org.hibernate.util.JDBCExceptionReporter - Violation of UNIQUE KEY constraint 'usr_username_uc'. Cannot insert duplicate key in object 'dbo.usr'. " Also since the user's entry in usr table is with old username, the user cannot post news feed. Is updating the usr table a good option? Can the plugin be updated to handle this?
Reply
  • 0
    Certified Lead Developer
    Hi Eduardo, even we were facing the same problem and reacted the problem in the same way by renaming it to a temp value and then renaming back to required value. Rename worked but the problem is that we are getting this error in logs for that user "ERROR org.hibernate.util.JDBCExceptionReporter - Violation of UNIQUE KEY constraint 'usr_username_uc'. Cannot insert duplicate key in object 'dbo.usr'. " Also since the user's entry in usr table is with old username, the user cannot post news feed. Is updating the usr table a good option? Can the plugin be updated to handle this?
Children
No Data