掲示板

Accidentally deleted user in database....

thumbnail
12年前 に Bruno Galvao によって更新されました。

Accidentally deleted user in database....

Junior Member 投稿: 58 参加年月日: 11/08/26 最新の投稿
I deleted a user from the Users table in the database.
Now when I try to recreate the user in the Control Panel, I get the following error when i try the same screename:
"The screen name you requested is associated with an existing friendly URL. "

How do I remove the user's friendly URL?

Thanks,
Bruno
thumbnail
12年前 に Arvind Mishra によって更新されました。

RE: Accidentally deleted user in database....

Regular Member 投稿: 226 参加年月日: 08/02/13 最新の投稿
You can remove it from Layout table.
thumbnail
12年前 に Bruno Galvao によって更新されました。

RE: Accidentally deleted user in database....

Junior Member 投稿: 58 参加年月日: 11/08/26 最新の投稿
Arvind Mishra:
You can remove it from Layout table.



Hey Thanks for the information. How would I know which row belongs to the deleted user if there is no column with userId?
There are multiple rows with the friendly URL \home I just do know which one is the correct one to delete.

Thanks!
thumbnail
12年前 に Bruno Galvao によって更新されました。

RE: Accidentally deleted user in database....

Junior Member 投稿: 58 参加年月日: 11/08/26 最新の投稿
Bruno Galvao:
Arvind Mishra:
You can remove it from Layout table.



Hey Thanks for the information. How would I know which row belongs to the deleted user if there is no column with userId?
There are multiple rows with the friendly URL \home I just do know which one is the correct one to delete.

Thanks!



I deleted the user from the Groups_ table and I was able to recreate.
I did not have to delete anything from the Layout table.
11年前 に Subhash Shah によって更新されました。

RE: Accidentally deleted user in database....

Junior Member 投稿: 78 参加年月日: 11/11/30 最新の投稿
I know its an older thread, but just to update, I was facing the same problem but the solution worked for me too.
thumbnail
11年前 に Mika Koivisto によって更新されました。

RE: Accidentally deleted user in database....

Liferay Legend 投稿: 1519 参加年月日: 06/08/07 最新の投稿
Don't delete anything directly from the database use the API or UI otherwise you'll end up corrupting the the database.
thumbnail
11年前 に Hitoshi Ozawa によって更新されました。

RE: Accidentally deleted user in database....

Liferay Legend 投稿: 7942 参加年月日: 10/03/24 最新の投稿
Mika, these guys already corrupted their databases. User table is also related to the contact table and several other tables.

Also, if you're going to do any direct database operation (even though you're not really suppose to them on liferay tables),
create a backup so you'll be able to go back to what you had.

That said, it probably was better to recreate an user in the user table checking other tables for keys.