Mcsirl Posted February 18, 2021 Share Posted February 18, 2021 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 Link to comment Share on other sites More sharing options...
support Posted February 18, 2021 Share Posted February 18, 2021 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.