Unable to Recreate user in liferay DB | After deleting user from database

[Abhishek Saxena, geändert vor 14 Jahren.]

Hi All ,

I was experincing an exception for a particlular user

An unexpected system error occurred.
com.liferay.portal.LayoutFriendlyURLException

To resplve the issue i was updating the relevant entries in user_ and Group , layout tables ,
accidentally user was deleted by query
delete from User_ where screenName="xyz";

now I m trying to create a user with similar screen name but the user creation portlet dosent allow me to do so
throwing an error saying username already exists .

is there any more association that needs to be removed from database and how to get that entry.

I have to get this xyz user working again


Thanks in advance

[Axel Nagel, geändert vor 14 Jahren.]

Hi,

does ist say user does already exist, or is it 'SCREENNAME' does already exist?
Than you have a problem with an orphaned contact_ entry!

look at this post