Error when trying to delete users

[Mcsirl]

Hi Guys,

 

Im getting the following error when trying to delete users (either single users or multiple)

 

I am on V8.9 (Build 8990) 

 

The error is : Error Code = The statement has been terminated. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Passwordstate.User.DeleteUserAccount(String strUserID, String strFirstName, String strSurname)

 

I get this either when clicking on the arrow beside the user and clicking delete or seleting Delete from the "Process Selected Items" dropdown at the bottom of the user page.

 

Can you help ?

 

THanks

Alan

 

 

[support]

Hi Alan,

 

We've reviewed the code, and we think this could possibly be a bug. Can you try updating the SQL Code below with the correct UserID, and then execute with SQL Server Management Studio - does this allow you to delete the account after that?

USE Passwordstate

DELETE FROM [AccessRequestApprovers] WHERE AccessRequestID IN (SELECT AccessRequestID FROM [AccessRequests] WHERE UserID = 'xxxx')
DELETE FROM [AccessRequests] WHERE (UserID = 'xxxx')

 

Regards

Click Studios