While developing our Umbraco solution, we somehow managed to demote our only user with userType 1 (admin) to userType 3 through the umbraco users dashboard. We have tried changing the userType for the user back to 1 in the database manually, but to no effect. We've deleted umbraco.config file and temp and cache folders but nothing has helped.
Is there anyway to set a user as admin outside of using the users dashboard that we can no longer access?
Any change that you can post a screendump of what the umbracoUser table looks like? Perhaps there are more fields that need to be edited. Just hide the sensible values from it of course.
Is it correct to assume you're still able to login to the backoffice?
You should search the installed items to check if these two updates are installed "* If you have Windows Server 2012 R2 + IIS and either KB3000850 or KB3007507 installed, YOU ARE AFFECTED"**
setting the userType back to 1 in the database should reset your user back to an Administrator. Have you changed anything else in the user settings other than that? also try logging into the backoffice and see if you have access to the users tab if so, you should be able to set it back to administrator there.
Try check if the id is set to 0, if not try changing the id to 0 in the db as well.
Lost our only admin user
While developing our Umbraco solution, we somehow managed to demote our only user with userType 1 (admin) to userType 3 through the umbraco users dashboard. We have tried changing the userType for the user back to 1 in the database manually, but to no effect. We've deleted umbraco.config file and temp and cache folders but nothing has helped.
Is there anyway to set a user as admin outside of using the users dashboard that we can no longer access?
Thanks in advance.
Hi Mikkel and welcome to our :)
Wow that's a weird issue...
Any change that you can post a screendump of what the umbracoUser table looks like? Perhaps there are more fields that need to be edited. Just hide the sensible values from it of course.
Is it correct to assume you're still able to login to the backoffice?
/Jan
You should search the installed items to check if these two updates are installed "* If you have Windows Server 2012 R2 + IIS and either KB3000850 or KB3007507 installed, YOU ARE AFFECTED"**
If they are that might be the cause.
/Jan
setting the userType back to 1 in the database should reset your user back to an Administrator. Have you changed anything else in the user settings other than that? also try logging into the backoffice and see if you have access to the users tab if so, you should be able to set it back to administrator there.
Try check if the id is set to 0, if not try changing the id to 0 in the db as well.
is working on a reply...