"Username not avaliable" Error while creating user with already deleted Usernames

[AnveshNalimela]

Description:

When creating a new user, if the username matches one that belonged to a previously deleted account (soft deleted), the system incorrectly shows the "username already taken" error. This issue arises because the system is not distinguishing between active and deleted accounts during the username availability check.

Steps to Reproduce:

1.An admin deletes a user (soft delete).
2.A new user attempts to create an account using the same username.
3.The system shows the error "username already taken," even though the previous user has been deleted.

Expected Behavior: The system should allow new users to register with the same username if the previous account has been deleted.

Actual Behavior: The "username already taken" error is shown, preventing new account creation with the same username.

Suggested Fix: Update the username availability check to exclude usernames from deleted (soft deleted) accounts or provide the option to permanently delete usernames upon account removal.

[DraKen0009]

@rithviknishad I want to work on this issue