Cannot unlock member
# help-with-umbraco
g
Our customer failed to login a couple of times and got locked out. We tried to lock out the member in the backoffice. The operation succeeds, but the member remains locked out. How to unlock the user? I cannot find any errors in logs. Umbraco v13.5.2 https://cdn.discordapp.com/attachments/1318945143474356326/1318945143830609984/lockout.gif?ex=67642ae3&is=6762d963&hm=41002fb6be19cf2d83bd948c663c62f8db385927fac07af29d899e9e6294e5ff&
@here anyone has an idea ?
The problem occurs only for some users and not all. If I lock myself out, I can unlock my account without any issues.
I found out that if the lockOut date is more than 30 days in the past, than we cannot unlock the user anymore. Is that intentional? https://cdn.discordapp.com/attachments/1318945143474356326/1319317432833409095/lockoutDate.gif?ex=6765859b&is=6764341b&hm=d5d8c8194f676bbada40f385c5446be762b46791ccdc43b88a73148676224d78&
l
You can usually unlock the user directly in the database. Usually it's the 'noConsole' property on the user table that is set to true. Still weird that you cannot unlock the user through the backoffice
g
This is for members, not users. Members don't have
noConsole
property in the DB.
l
ah ok, I thought you were talking about users
m
If you need it for members it is a normal property...
Copy code
sql
SELECT TOP (1000) [id]
      ,[dataTypeId]
      ,[contentTypeId]
      ,[propertyTypeGroupId]
      ,[Alias]
      ,[Name]      
  FROM [dbo].[cmsPropertyType]
  where Alias like '%lock%'
usually 31 for the
umbracoMemberLockedOut
then
Copy code
sql
SELECT TOP (1000) [id]
      ,[versionId]
      ,[propertyTypeId]
      ,[languageId]
      ,[segment]
      ,[intValue]
      ,[decimalValue]
      ,[dateValue]
      ,[varcharValue]
      ,[textValue]
  FROM [dbo].[umbracoPropertyData]
  where propertyTypeId = 31
should get you values that you should be able to alter from 1 -> 0 to unlock.. and then rebuild the nucache via the backoffice.
39 Views