Deleted uStore user - changing StatusID from 2 to 1

[markb]

Hi all,

A staff member mistakenly deleted a short list of users and I asked XMPie support if there by chance if there is a flag in the database to reinstate and they confirmed there is:

"R&D would strongly discourage this approach; however, it is technically possible. Updating the StatusID from 2 to 1 for the deleted users in the dbo.Users table will reinstate the users in uStore along with their addresses. I strongly recommend backing up the database first and testing this on a single user. We validated this on a test server with one user and did not encounter any issues."

It's not a large issue, we can let the accounts know to create a new account, but was curious if anyone has managed this before? I am hesitant to do this as I see another column in the user table named "IsDeleteCompleted" with a "1" value so that may point to other tables that have been updated during the delete process.

If anyone has additional feedback if this may be "safe" to update the StatusID from 2 to 1 for the deleted users, please let me know? My instinct tells me to just let folks know to re-sign up. 

[Wayne]

Its really a question of timing - XMPie often use the Garbage Collector for cleanups.

If the Garbage Collector has run it's cleanup task I would not recommend changing the Status in the Users Table.

Regards,

Wayne

[markb]

Thanks Wayne, I'll leave them as is.