[SOLVED] How to really delete users?

[7年前 に Mirto Silvio Busico によって更新されました。]

Using LR 7.0 CE GA3 I'm not able to delete users.

Step to reproduce:

• select an organization and create an user (eg x1)
• login with the new user (x1) and then logout
• from the organization, delete the user
• verify that the user cannot login
• reboot the server (just to be sure)
• try to recreate the user (x1): you reveive the error: "x1 screenname already taken"

I also tried to directly delete the user row from the "user_" database tabe.
Then trying to recreate the user I receive the error: "the friendly url is already taken"

What can I do to definitively delete an user and then create a new one with the same screenname?

[7年前 に Olaf Kock によって更新されました。]

Mirto Silvio Busico:

I also tried to directly delete the user row from the "user_" database tabe.
Then trying to recreate the user I receive the error: "the friendly url is already taken"

The most important lesson: You do never use SQL to change Liferay's Database. As you can see, it's a recipe for desaster.

What looks like "deletion" of a user on the UI is actually a "deactivation". You can then look for deactivated users on the UI and delete them: You do need this dual step process when coming through the UI.

I can't and won't help you restoring the integrity of your database though, other than asking to restore from backup - because this would imply that I do remember *all* the relationships within the database. Note: There are more than just the one which occupies your friendly URL .

[7年前 に Mirto Silvio Busico によって更新されました。]

I know I don'have to mess up the database
I'm using a virtual machine to develop a site; but I use a different virtual machine to reproduce the problem I encounter.
In this VM you are right: uders are dectivated and can be reactivated.

This evening I'll try to reproduce the other machine situation:

• the users are not listed in the user view and in any organization view
• the users still exist and are able to login correctly

But I didn't verify if they are listed in the deactivated user list (but deactivated users should not be able to login?)

Thanks

[7年前 に Mirto Silvio Busico によって更新されました。]

Verified on the other VM: the gost users magically reapeared.
Thanks again