How to re-enable the default UMP liferay site?

Document ID : KB000040135
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

While I was customizing the UMP on one of our instances I deactivated the default Lifefray site, now I can't access the UMP, it returns the following error:
"This site is inactive. Please contact the administrator."

How can I re-enable the site?

Answer:

You will need direct access to the back end database to correct this issue.
Once you have admin level access to the dabase you can run the following queries

To check for the deactivated site run
select * from group_ where active_ = '0';

The default site should be named Guest by default. You can get the <groupid> for .this row

Then run the following query to reactivate group
update group_ set active_ ='1' where groupid=<groupid>;


NOTE: replace <groupid> with the actual value.

Then you will need to restart wasp and I believe this should correct your issue.