Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
Bruno Galvao
Accidentally deleted user in database....
7 de Outubro de 2011 08:53
Resposta

Bruno Galvao

Ranking: Junior Member

Mensagens: 58

Data de entrada: 26 de Agosto de 2011

Mensagens recentes

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
Arvind Mishra
RE: Accidentally deleted user in database....
7 de Outubro de 2011 12:00
Resposta

Arvind Mishra

Ranking: Regular Member

Mensagens: 220

Data de entrada: 13 de Fevereiro de 2008

Mensagens recentes

You can remove it from Layout table.
Bruno Galvao
RE: Accidentally deleted user in database....
7 de Outubro de 2011 12:07
Resposta

Bruno Galvao

Ranking: Junior Member

Mensagens: 58

Data de entrada: 26 de Agosto de 2011

Mensagens recentes

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!
Bruno Galvao
RE: Accidentally deleted user in database....
7 de Outubro de 2011 12:49
Resposta

Bruno Galvao

Ranking: Junior Member

Mensagens: 58

Data de entrada: 26 de Agosto de 2011

Mensagens recentes

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.
Subhash Shah
RE: Accidentally deleted user in database....
10 de Janeiro de 2013 20:16
Resposta

Subhash Shah

Ranking: Junior Member

Mensagens: 77

Data de entrada: 29 de Novembro de 2011

Mensagens recentes

I know its an older thread, but just to update, I was facing the same problem but the solution worked for me too.
Mika Koivisto
RE: Accidentally deleted user in database....
10 de Janeiro de 2013 22:38
Resposta

Mika Koivisto

LIFERAY STAFF

Ranking: Liferay Legend

Mensagens: 1493

Data de entrada: 7 de Agosto de 2006

Mensagens recentes

Don't delete anything directly from the database use the API or UI otherwise you'll end up corrupting the the database.
Hitoshi Ozawa
RE: Accidentally deleted user in database....
19 de Janeiro de 2013 09:50
Resposta

Hitoshi Ozawa

Ranking: Liferay Legend

Mensagens: 7990

Data de entrada: 23 de Março de 2010

Mensagens recentes

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.